Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-tables"

219 prompts matching "excel-tables"

"excel-tables" ✕ Clear all ✕
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
excel intermediate

Trace a broken cell reference across a workbook before fixing it blindly

Act as an Excel auditor. A formula on the summary tab is returning #REF! after a...

#excel #auditing #debugging
👁 3 views
excel intermediate

Build a Dynamic Excel Dashboard with Slicers

Act as an Excel expert. Guide me through building a dynamic dashboard for [datas...

#excel #dashboard #slicers
👁 3 views
excel Intermediate

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#excel #dates #data cleaning
👁 3 views
excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#excel #data cleaning #deduplicate
👁 3 views
excel Intermediate

Build a Headcount Plan Spreadsheet with Hiring Ramp

Help me build a 12-month headcount plan in Excel. Inputs I'll provide: [list cur...

#excel #headcount #hiring
👁 2 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
👁 2 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro
👁 2 views
excel intermediate

Speed up a slow workbook that recalculates every keystroke

Act as an Excel performance specialist. I will describe a workbook that has grow...

#excel #performance #recalculation
👁 2 views
excel Advanced

Build a flexible scenario model without nesting IF statements ten layers deep

Act as a financial modeler reviewing my workbook. I have a model that runs base/...

#scenarios #modeling #choose
👁 2 views
excel Intermediate

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#debugging #audit #trace-precedents
👁 2 views
excel Intermediate

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#formulas #validation #helper-column
👁 2 views
excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#power-query #data-cleaning #pivot
👁 2 views
excel Intermediate

Write a lookup that survives someone reordering the columns

Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...

#xlookup #index-match #robust
👁 2 views
excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#excel #formulas #automation
👁 2 views
excel Intermediate

Build an Excel formula that flags duplicates across multiple columns

In Excel I need to find rows that are duplicates based on a *combination* of col...

#excel #duplicates #countifs
👁 2 views
excel Advanced

Reverse-engineer a broken Excel formula someone else wrote

I inherited a spreadsheet with a long, nested Excel formula I don't understand a...

#excel #formulas #debugging
👁 2 views
excel Intermediate

Write a nested IF that a coworker can actually read

I need an Excel formula that assigns a grade band based on a score, with at leas...

#excel #formulas #xlookup
👁 2 views
excel Advanced

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

#excel #dropdown #data validation
👁 2 views
excel Intermediate

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#excel #sumifs #debugging
👁 2 views
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
👁 2 views
excel Intermediate

Write Nested IF and IFS Formulas for Tiered Commission

Act as an Excel formula expert. I need to calculate sales commission using tiere...

#excel #formulas #ifs
👁 2 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval