Search: "Excel analysis"

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#excel #burn-down #project management

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

#data #visualization #charts

data Beginner

Choose the Right Chart Type for the Question You're Asking

I have [DATA DESCRIPTION] and I'm trying to answer [QUESTION] for [AUDIENCE]. Wa...

#excel #goal-seek #solver

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#excel #commission #sales

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

#sensitivity #what-if #modeling

excel Advanced

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#metrics #variance #signal-vs-noise

data Intermediate

Data: Spot When a Metric Movement Is Just Noise

My weekly metric moved 12% — is that signal or noise? Help me decide without doi...

#data #analysis #statistics

data Advanced

Data: Stop a Stakeholder From Acting on a Spurious Correlation

A [ROLE] just sent me [CHART/CLAIM] showing [X correlates with Y] and they're ab...

#excel #capacity-planning #modeling

excel Advanced

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#anomaly detection #metrics #WAU

data Intermediate

Decide if a weekly metric drop is signal or noise

Our weekly active users dropped 8% week-over-week. Before I escalate, help me de...

#fp&a #financial-modeling #drivers

finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#excel #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#finance #budget #personal-finance

finance beginner

Personal Budget Planner and Financial Health Analyzer

Create a personalized budget plan and financial health analysis. My situation: ...

#ab testing #statistics #significance

data Advanced

A/B Test Analysis Statistical Significance Sample Size Calculator

You are a data scientist. Help me analyze an A/B test on [METRIC] comparing [VAR...

#mortgage refinance #break-even analysis #home loan

finance Intermediate

ChatGPT Prompt: Mortgage Refinance Break-Even Analysis Calculator

Analyze whether I should refinance my mortgage based on these details: Current ...

#business #swot #strategy

business Intermediate

Build a Lean SWOT Analysis Tied to Concrete Actions

Act as a strategy consultant. Build a SWOT analysis for {{company / product / te...

writing Advanced

Outline a Long-Form Essay With Argument Mapping

Help me outline a long-form essay (2000-3000 words) on [topic]. Use argument map...

#writing #essay #outline

data Advanced

Run a Power Analysis Before an A/B Test

Help me calculate the required sample size for an A/B test. Walk me through: def...

#data #ab-test #power

#data #SQL #funnel analysis

data Intermediate

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#finance #10-K #investing

finance Advanced

Read a 10-K Like an Investor, Not a Reader

Walk me through reading a 10-K filing for [COMPANY] efficiently. Output: (1) the...

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline