Search: "Excel analysis"

#data #analysis #insights

data Intermediate

Interpret a Dataset and Surface Insights

You are a data analyst. I'll paste a summary table or describe a dataset: [PASTE...

#data #analysis #data-science

data Intermediate

Find the Story Hidden in My Dataset

You are a data analyst who turns numbers into decisions. I will describe or past...

customer-service Intermediate

Turn Customer Feedback Into Themes and Actions

You are a customer insights analyst. I will paste a batch of customer feedback (...

#customer-service #feedback-analysis #voice-of-customer

#data #cohort analysis #retention

data Advanced

Design a Cohort Retention Analysis from Raw Event Data

Help me design a cohort retention analysis. My raw data: an events table with us...

#excel #comparison #vlookup

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #inventory #reorder

Excel Inventory Reorder-Point Calculator with Safety Stock

I'm building a reorder-point sheet for [number] SKUs in Excel. For each SKU I ha...

#excel #inventory #reorder-point

Excel Inventory Reorder Point Calculator

Build an Excel template that calculates the reorder point for each SKU using lea...

business Advanced

SWOT to OKR Translation Workshop

Given a SWOT analysis (Strengths, Weaknesses, Opportunities, Threats), translate...

#business #swot #okr

coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

data Advanced

Cohort Retention Analysis from Event Log

From the event log table with columns user_id, event_name, occurred_at, build a ...

#data #cohort #retention

customer-service Advanced

Voice-of-Customer Theme Synthesis from Tickets

Analyze the batch of customer support tickets provided. Synthesize into: top 5 r...

#customer-service #voc #insights

#excel #charts #visualization

excel Beginner

Excel: Pick the Right Chart for the Story You're Trying to Tell

I have data and a point I want to make, but I don't know which chart conveys it ...

#excel #financial-modeling #three-statement

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 #power-query #data-cleaning

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

#excel #power-query #vlookup

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 #charts #data-visualization

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 #pivot-tables #executive-reporting

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

#finance #business #financial-analysis

finance Advanced

Finance: Read a P&L and Find What the CEO Doesn't Want to See

Here's the latest P&L: [PASTE OR SUMMARIZE]. The CEO is presenting it in a board...

#excel #data-cleaning #names

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

#business #partnerships #due diligence

business Intermediate

Evaluate a partnership pitch that sounds great in the deck but feels off in the gut

A bigger company pitched me a partnership. The deck shows complementary audience...

#data #storytelling #presentation

data Intermediate

Turn a 6-tab analysis into a 3-slide story for executives

I have a 6-tab analysis with 14 charts. I have 10 minutes with the leadership te...

#excel #vlookup #reconciliation

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