Search: Excel timeline — AI Prompts

excel Advanced

Excel: Build a Three-Statement Model That Stays Internally Consistent

I need a three-statement financial model (income statement, balance sheet, cash ...

#excel #financial-modeling #three-statement

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

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

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

👁 5 views

excel Beginner

Excel: Pick a Chart That Doesn't Need a Caption to Be Understood

I want to show [DESCRIBE COMPARISON OR TREND] to [AUDIENCE]. Tell me the right c...

#excel #charts #data-visualization

👁 5 views

excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#excel #pivot-tables #executive-reporting

👁 5 views

hr Advanced

Hr: Manage a Senior Hire Who's Not Ramping

I hired [NAME] at a senior level [N] months ago and they're not ramping: [SYMPTO...

#hr #performance-management #hiring

👁 5 views

excel Intermediate

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#excel #data-cleaning #names

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

👁 5 views

creative Beginner

Brainstorm without converging on the first idea that sounds plausible

I need to brainstorm [TOPIC — campaign, name, feature, solution]. Give me ideas ...

#creative #brainstorming #ideation

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

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

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

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

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

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

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

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

👁 5 views

coding Advanced

Write a postmortem that blames the system, not the engineer

We had a production outage caused by a deploy that bypassed a check. The enginee...

#coding #postmortem #sre

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

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

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

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

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

👁 5 views

Search: "Excel timeline"

Excel: Build a Three-Statement Model That Stays Internally Consistent

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

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

Excel: Replace a Fragile VLOOKUP Chain With Power Query

Excel: Pick a Chart That Doesn't Need a Caption to Be Understood

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

Hr: Manage a Senior Hire Who's Not Ramping

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

Reconcile two lists that should match but somehow never do

Brainstorm without converging on the first idea that sounds plausible

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

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

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

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

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

Write a postmortem that blames the system, not the engineer

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

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

Speed up a slow workbook that recalculates every keystroke

Build a Dynamic Excel Dashboard with Slicers

Reverse-engineer a broken Excel formula someone else wrote