Search: "Excel analysis"

#excel #data cleaning #deduplicate

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#business #swot #strategy

business Beginner

Run a SWOT Analysis with Actionable Recommendations

You are a business strategy consultant. Conduct a structured SWOT analysis for t...

#data #storytelling #insights

Turn Raw Numbers into a Clear Data Story

Act as a data storyteller who helps non-technical stakeholders understand number...

#finance #decision #comparison

finance Intermediate

Compare Two Financial Options with a Clear Breakdown

You are a financial decision analyst who helps people think clearly about money ...

#cohort analysis #retention #saas

data Advanced

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

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

#excel #charts #data-visualization

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

#pivot tables #dashboard #monthly report

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

#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

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

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

#refactoring #imports #modules

coding Intermediate

Untangle a circular import that the codebase has been living with for years

Act as a refactoring lead. There's a circular import between two modules that th...

#textjoin #reporting #plain-english

Make a one-cell formula that summarizes a whole row in plain words

You're an Excel helper for non-technical users. I want a single formula that rea...

#excel #dropdown #data validation

excel Advanced

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

Write Nested IF and IFS Formulas for Tiered Commission

Act as an Excel formula expert. I need to calculate sales commission using tiere...

#excel #formulas #ifs

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

#excel #formulas #commission

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

#coding #algorithms #optimization

coding Advanced

Explain and Optimize an Algorithm

You are an expert algorithms tutor. Help me understand my algorithm's complexity...

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query

#excel #dashboard #pivottable

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#data #data-modeling #spreadsheets

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

#data #data-cleaning #quality

Write a Data Cleaning Checklist

You are a data-quality analyst. Based on the dataset I describe, produce a thoro...