Search: "Excel analysis"

#analysis #metrics #stakeholders

Translate a stakeholder question into something a dataset can answer

Act as an analytics translator. A stakeholder asked me a fuzzy question like "ar...

#data #analysis #insights

data intermediate

Analyze a Dataset and Find Insights

Act as a data analyst. I have a dataset with these columns: [list columns]. Sugg...

#data #analysis #insights

Interpret a Dataset and Find Insights

You are an expert data analyst. Help me find the story in a set of numbers I'll ...

Audit a Workbook for Broken Formulas and Hidden Dependencies

I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...

#excel #audit #formulas

#business #growth #diagnosis

business Advanced

Diagnose Why a Healthy Business Suddenly Stopped Growing

Walk me through how to diagnose why my business — profitable, retention-strong —...

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

Decide If This Data Is Worth Analyzing Before You Spend a Week On It

Before I dig into [dataset and analysis question], help me decide if it's worth ...

#data #analysis #scoping

#marketing #campaign #analysis

marketing Intermediate

Decide If This Campaign Worked Without Lying to Yourself

I just ran [campaign — channel, offer, audience, dates, spend]. Results: [paste ...

#rolling #trend #dynamic-range

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#excel #data-cleaning #power-query

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #formulas #debugging

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

#finance #accounting #cash-flow

finance Advanced

Finance: Read a Cash Flow Statement and Find the Real Problem

Here's a company's cash flow statement: [PASTE]. The income statement looks fine...

#excel #power-query #data-cleanup

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#coding #refactoring #legacy-code

coding Advanced

Coding: Refactor Code I Don't Have Tests For Without Breaking It

I need to refactor [MODULE/FUNCTION] and there are no tests. Yes, I should add t...

#excel #formulas #running-total

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

#excel #automation #power-query

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#data #analysis #statistics

Decide whether a metric change is real or just noise this week

A metric I track jumped by 15% this week compared to last week. Before I tell an...

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #let-function #formulas

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

#excel #template #validation

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #data validation #conditional formatting

excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...