Search: "pivot table"

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

#excel #formulas #xlookup

Write a nested IF that a coworker can actually read

I need an Excel formula that assigns a grade band based on a score, with at leas...

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

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

data Intermediate

Write and Explain a SQL Query From Plain English

Act as a SQL expert. I will describe what I want in plain English and you will w...

#data #sql #databases

#data #data-modeling #spreadsheets

data Intermediate

Design a Simple Data Model for My Spreadsheet

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

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

#excel #pivot-tables #reporting

excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

data Advanced

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill

#marketing #launch #campaign

marketing Advanced

Plan a launch that doesn't fizzle two days in

I'm launching [PRODUCT/FEATURE] on [DATE]. Help me build a launch that has a sec...

#decision #async #escalation

email Intermediate

Write the email that pushes a decision out of a stuck Slack thread

Act as a senior PM who is tired of decisions dying in Slack. A thread has been g...

#positioning #messaging #value-prop

marketing Intermediate

Find the one message that makes a feature actually matter to buyers

You're a positioning strategist. I will describe a feature or product and tend t...

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

#email #meeting-notes #follow-up

email Intermediate

Turn Meeting Notes into a Follow-Up Email

You are a meeting-summary assistant. I will paste rough meeting notes and you wi...

#education #quiz #assessment

education Intermediate

Design a 10-Minute Quiz That Actually Reveals What Students Know

I want to give a 10-minute quiz at the start of class to find out where my stude...

#SQL #window functions #query optimization

data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

#writing #interview #reporting

writing Advanced

Turn 90 minutes of background interview tape into a 600-word reported piece

You are a magazine editor. I just conducted a 90-minute interview with [SUBJECT]...

#excel #pivot-table #sales

Design a Pivot Table for Monthly Sales Analysis

You are an expert Excel reporting analyst. Guide me through building a pivot tab...

#finance #ratios #analysis

finance Intermediate

Explain Key Financial Ratios for a Business

You are an expert financial analyst. Help me understand and compute the financia...

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

#excel #pivot-table #reporting

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...