Search: "formulas"

#excel #reconciliation #fuzzy match

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#finance #runway #burn rate

finance Intermediate

Build a Runway Calculator With Burn Sensitivity

Help me build a runway calculator with sensitivity analysis. Inputs: current cas...

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline

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

#sensitivity #what-if #modeling

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

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

#excel #data-cleaning #power-query

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

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

#excel #performance #formulas

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 #power-query #data-cleanup

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 #capacity-planning #modeling

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...

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

#excel #dashboard #formulas

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...

#fp&a #financial-modeling #drivers

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 ...

#excel #let-function #formulas

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 #power-query #unpivot

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...

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

#excel #financial-modeling #three-statement

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

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

#excel #power-query #data-cleaning

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 #formulas #debugging

Excel: Fix the Formula That Works Until It Doesn't

Here's a formula that works on most rows but breaks on a few: [PASTE FORMULA AND...

#excel #formulas #running-total

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#excel #vlookup #reconciliation

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#commission #sales #formulas

Build a self-updating commission tracker for a sales team in Excel

Act as a RevOps analyst. Help me design an Excel commission tracker that auto-ca...

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #audit #inherited-model

Audit a spreadsheet a predecessor built before you trust a single number

I inherited an Excel model from someone who left. I need to know if I can trust ...