Search: "pivot table"

#content-marketing #strategy #calendar

marketing Advanced

Plan a Quarterly Content Calendar Built Around One Big Bet

You are a content marketing director. Plan a quarterly content calendar built ar...

excel Advanced

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

#market-entry #partnerships #build-vs-partner

business Advanced

Decide whether to enter a new market through a partnership or a direct build

You're a strategy advisor who has watched both succeed and fail. We want to ente...

#textjoin #reporting #plain-english

excel Beginner

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

data Intermediate

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

#business #meetings #productivity

business Beginner

Turn Meeting Notes Into Action Items

You are an executive assistant. I will paste raw, messy meeting notes and you wi...

#pnl #financial-analysis #operations

finance Advanced

Read a P&L Like an Operator, Not an Accountant

Read this P&L like an operator. P&L: [PASTE OR DESCRIBE BY LINE]. Comparison per...

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

#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 #pivot-tables #analysis

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

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

excel Advanced

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

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

#marketing #content #pillar-content

marketing Advanced

Pick one piece of content to nurture into 50% of inbound for the quarter

You are a content strategist. Instead of publishing 12 mediocre posts this quart...

#data #quality #monitoring

data intermediate

Detect a data-quality problem before stakeholders find it for you

Act as an analytics engineer who has had to apologize for wrong dashboards. Help...

#legal #term-sheet #startup

legal advanced

Read a term sheet for the things they did not put in writing

Act as a startup lawyer who has read thousands of term sheets. Help me read mine...

#legal #contract #summary

legal Intermediate

Summarize a Contract into Plain-English Key Terms

You are a contracts analyst who explains legal documents in plain English. I wil...

#business #decision-making #matrix

business Intermediate

Build a Weighted Decision Matrix

You are an expert decision analyst. Help me choose between options objectively u...

#marketing #email #welcome-sequence

marketing Intermediate

Build a 5-Email Welcome Sequence

You are an expert lifecycle email marketer. Help me design a welcome email seque...

coding Advanced

Optimize a SQL Query for Speed

You are a database performance engineer. I will paste a slow SQL query and the t...

#coding #sql #database