Search: "Excel analysis"

#pivot tables #dashboard #monthly report

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

#LET function #nested IF #refactor

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

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

#power-query #m-language #etl

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

#five-whys #root-cause #management

business Intermediate

Diagnose a Stalled Initiative Using the Five Whys with Evidence

You are a management consultant. I will describe an initiative at my company tha...

#win-loss #product-marketing #sales

marketing Advanced

Run a Win/Loss Analysis That Actually Changes Sales Behavior

Act as a product marketing leader. Design a win/loss analysis program that actua...

#commission #sales #formulas

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

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

#excel #fuzzy-match #deduplication

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 #runway #burn-rate

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 #power-query #office-scripts

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

#hr #pay-equity #compensation

hr Advanced

Run a pay equity audit that finds the actual gaps, not the surface ones

Act as a compensation analyst. Run a pay equity audit across [DIMENSION — gender...

#marketing #growth #activation

marketing Advanced

Find the activation moment that predicts a paying user

You are a growth analyst. We have [N] signed-up users and want to find the singl...

#excel #audit #inherited-model

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

#marketing #competitor-analysis #strategy

marketing Advanced

Audit a competitor without convincing yourself you need to copy them

I'm doing a competitor audit on [competitor] before [decision — repositioning, n...

#excel #performance #recalculation

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 #dashboard #slicers

excel intermediate

Build a Dynamic Excel Dashboard with Slicers

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

#excel #formulas #debugging

Reverse-engineer a broken Excel formula someone else wrote

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

#education #questions #self-testing

education Intermediate

Turn a dense chapter into questions that test real understanding

I'll paste or describe a chapter or article I'm studying. Generate questions at ...

#excel #pivot table #data cleaning

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 #cash flow #forecast

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

#business #negotiation #batna

business Advanced

Prepare for a Negotiation with a BATNA Worksheet

Act as a negotiation coach trained in principled negotiation. Help me prepare fo...

#data #schema #spreadsheet

data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...