Search: "pivot table"

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

#migration #sql #zero-downtime

coding Advanced

Write a Defensive Migration Script for a NOT NULL Column Addition

Act as a database migration specialist. I need to add a NOT NULL column [column_...

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

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

#writing #editing #revision

writing Intermediate

Find the One Sentence Doing All the Work in Your Draft

Here's a draft I'm editing: [paste draft, 500-1500 words]. Help me find the sent...

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

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

#migrations #zero-downtime #schema

coding Advanced

Coding: Write a Migration Plan for a Schema Change That Can't Take Downtime

I need to change a schema (rename column, change type, add NOT NULL) on a high-t...

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

#writing #structure #essay

writing Advanced

Restructure an essay that has a great middle but a weak opening and ending

I have an essay where paragraphs 4-8 are doing real work but the opening (paragr...

#finance #debt #investing

finance Intermediate

Decide between paying off debt and investing without overthinking it

I have [DEBTS — type, balance, interest rate] and [INVESTMENT/SAVINGS CAPACITY —...

data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

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

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

#power-query #m-language #etl

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#five-whys #root-cause #management

business Intermediate

Diagnose a Stalled Initiative Using the Five Whys with Evidence

You are a management consultant. I will describe an initiative at my company tha...

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

#excel #fuzzy-match #deduplication

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#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

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