Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Microsoft Excel"

272 prompts matching "Microsoft Excel"

"Microsoft Excel" ✕ Clear all ✕
excel Intermediate

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

#excel #scenarios #data tables
👁 7 views
excel Intermediate

Excel: Replace a Wall of Nested IFs With One Clean SWITCH or IFS

I have a nested IF formula that's grown unmaintainable. Rewrite it using SWITCH,...

#excel #formulas #switch
👁 7 views
excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#excel #goal-seek #solver
👁 6 views
excel Intermediate

Excel Variance Analysis Budget vs Actual

Build an Excel variance analysis report comparing Budget vs Actual for revenue a...

#excel #variance-analysis #budget
👁 6 views
excel Intermediate

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#rolling #trend #dynamic-range
👁 6 views
excel Advanced

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#sensitivity #what-if #modeling
👁 6 views
excel Intermediate

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #data-cleaning #power-query
👁 6 views
excel Intermediate

Excel: Diagnose Why a Slow Workbook Takes 30 Seconds to Recalc

My Excel workbook recalculates painfully slowly and I don't know which sheet or ...

#excel #performance #formulas
👁 6 views
excel Intermediate

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#excel #power-query #data-cleanup
👁 6 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

#excel #capacity-planning #modeling
👁 6 views
excel Advanced

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi
👁 6 views
excel Intermediate

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

#excel #dashboard #formulas
👁 6 views
excel Advanced

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#excel #automation #power-query
👁 6 views
finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#fp&a #financial-modeling #drivers
👁 6 views
excel Intermediate

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

#excel #let-function #formulas
👁 6 views
excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#excel #power-query #unpivot
👁 6 views
excel Advanced

Audit a Workbook for Broken Formulas and Hidden Dependencies

I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...

#excel #audit #formulas
👁 5 views
excel Intermediate

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#excel #power query #survey
👁 5 views
excel Intermediate

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #comparison #vlookup
👁 5 views
excel Intermediate

Excel Inventory Reorder-Point Calculator with Safety Stock

I'm building a reorder-point sheet for [number] SKUs in Excel. For each SKU I ha...

#excel #inventory #reorder
👁 5 views
excel Intermediate

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

#excel #gantt #project-management
👁 5 views
excel Advanced

Excel: Build a Three-Statement Model That Stays Internally Consistent

I need a three-statement financial model (income statement, balance sheet, cash ...

#excel #financial-modeling #three-statement
👁 5 views
excel Intermediate

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #power-query #data-cleaning
👁 5 views
excel Advanced

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

I have a master sheet with sales data tagged by manager. I want a VBA macro that...

#excel #vba #automation
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval