Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-functions"

230 prompts matching "excel-functions"

"excel-functions" ✕ Clear all ✕
excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

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

#excel #reconciliation #fuzzy match
👁 11 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
👁 11 views
excel Intermediate

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#power-query #csv #data-cleaning
👁 11 views
excel Intermediate

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

#excel #commission #sales
👁 11 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
👁 11 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
👁 11 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
👁 11 views
excel Intermediate

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

#excel #pivot tables #reporting
👁 11 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
👁 11 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

#excel #dashboard #pivottable
👁 11 views
excel Intermediate

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable
👁 10 views
excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#budget tracker #personal finance #Excel template
👁 10 views
excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl
👁 10 views
excel Beginner

Excel: Pick the Right Chart for the Story You're Trying to Tell

I have data and a point I want to make, but I don't know which chart conveys it ...

#excel #charts #visualization
👁 10 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
👁 10 views
excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#excel #power-query #vlookup
👁 10 views
excel Intermediate

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#excel #data cleaning #dates
👁 10 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
👁 10 views
excel Intermediate

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

#excel #vlookup #reconciliation
👁 10 views
excel Intermediate

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

#excel #pivot-table #data-cleanup
👁 10 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
👁 10 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
👁 10 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
👁 10 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
👁 9 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval