Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-tables"

232 prompts matching "excel-tables"

"excel-tables" ✕ Clear all ✕
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
👁 13 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
👁 13 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
👁 13 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
👁 13 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
👁 12 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
👁 12 views
excel Intermediate

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#duplicates #dedupe #power-query
👁 12 views
excel Intermediate

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

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#excel #power-query #office-scripts
👁 12 views
excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query
👁 12 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
👁 12 views
excel Intermediate

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

#excel #formulas #commission
👁 12 views
excel Beginner

Pick the chart that tells the story instead of the chart that's easy to make

I have a dataset and I'm about to default to a bar chart because that's what Exc...

#excel #charts #visualization
👁 11 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
👁 11 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
👁 11 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
👁 11 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
👁 11 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
👁 11 views
excel Intermediate

Audit and Fix Broken Excel Formulas

Act as a spreadsheet debugger. I'll paste a formula that returns an error or wro...

#excel #debugging #errors
👁 11 views
excel Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba
👁 11 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
👁 10 views
excel Intermediate

Excel: Reconcile Two Lists That Should Match But Don't

I have two lists — one from our accounting system, one from the bank — that shou...

#reconciliation #matching #accounting
👁 10 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
👁 10 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval