Search: excel-fix — AI Prompts

excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #formulas #xlookup

👁 4 views

excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#pivot tables #dashboard #monthly report

👁 4 views

excel Intermediate

Create a Self-Updating Excel Project Tracker with Gantt View

Act as a project management consultant. Build me a self-updating Excel project t...

#gantt #project-tracker #dashboard

👁 4 views

excel Advanced

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#power-query #m-language #etl

👁 4 views

excel Intermediate

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

#commission #sales #formulas

👁 4 views

excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

👁 4 views

excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#excel #fuzzy-match #deduplication

👁 4 views

excel Intermediate

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 #reconciliation #xlookup

👁 4 views

excel Intermediate

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

#excel #audit #inherited-model

👁 4 views

excel Advanced

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #template #validation

👁 4 views

excel Intermediate

Turn a flat sales export into a pivot-ready table

I have a raw sales export with merged headers, blank rows, and totals mixed into...

#excel #pivot table #data cleaning

👁 4 views

excel Intermediate

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#excel #cash flow #forecast

👁 4 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

👁 3 views

excel Intermediate

Excel Inventory Reorder Point Calculator

Build an Excel template that calculates the reorder point for each SKU using lea...

#excel #inventory #reorder-point

👁 3 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

👁 3 views

excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power query #decision

👁 3 views

excel Advanced

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#LET function #nested IF #refactor

👁 3 views

excel Advanced

Build a Cohort Retention Heatmap Workbook in Excel

Act as a senior analytics engineer. I will paste a list of user signup events wi...

#cohort #retention #heatmap

👁 3 views

excel Advanced

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance

👁 3 views

excel Intermediate

Build a cash runway calculator that updates from a bank statement paste

I am a founder. I want an Excel sheet where I paste my bank statement export int...

#excel #runway #burn-rate

👁 3 views

excel Advanced

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#excel #sensitivity-analysis #data-table

👁 3 views

excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#excel #power-query #reconciliation

👁 3 views

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

#excel #working-capital #finance-model

👁 3 views

excel intermediate

Build a weekly dashboard people actually open without retraining them

Act as a BI designer. I want a one-tab Excel dashboard that a non-analyst team o...

#excel #dashboard #reporting

👁 3 views

Search: "excel-fix"

Replace nested IFs with a lookup table you can actually maintain

Turn a flat sales export into a one-screen monthly summary

Create a Self-Updating Excel Project Tracker with Gantt View

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

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

Turn a messy CRM CSV export into a clean Excel dashboard

Detect duplicate-but-different customer records in an Excel list

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

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

Build a self-checking Excel template that catches user-entered errors before they propagate

Turn a flat sales export into a pivot-ready table

Build a Rolling 12-Month Cash Flow Forecast in Excel

Excel Inventory Reorder-Point Calculator with Safety Stock

Excel Inventory Reorder Point Calculator

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

Decide when to use Power Query vs formulas vs a real database

Replace a fragile nested IF with a clean LET-based formula

Build a Cohort Retention Heatmap Workbook in Excel

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

Build a cash runway calculator that updates from a bank statement paste

Build a sensitivity table that stress-tests three assumptions at once

Reconcile two messy spreadsheets when the join keys don't match

Build a working capital model from a P&L extract without manual joins

Build a weekly dashboard people actually open without retraining them