Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-tables"

232 prompts matching "excel-tables"

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

Make a one-cell formula that summarizes a whole row in plain words

You're an Excel helper for non-technical users. I want a single formula that rea...

#textjoin #reporting #plain-english
👁 7 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
👁 7 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
👁 7 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
👁 7 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
👁 6 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
👁 6 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
👁 6 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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
👁 6 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
👁 6 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
👁 6 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
👁 6 views
excel Intermediate

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#excel #data-validation #dropdown
👁 6 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
👁 5 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
👁 5 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
👁 5 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
👁 5 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
👁 5 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
👁 5 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
👁 5 views
excel Intermediate

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#excel #dashboard #pivottable
👁 5 views
excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...

#excel #formulas #xlookup
👁 5 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
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval