Excel & Data
Clean this messy export
Data came out of a system in a state.
Here is a sample of my data: [PASTE 10 ROWS]. Identify every consistency problem — date formats, trailing spaces, duplicates, mixed units, blank keys. Give me the cleaning steps in order, and the formula or Power Query step for each.
Excel & Data
Compare two quotes properly
Two vendors, two formats, and the cheaper one is not obviously cheaper.
Here are two quotes: [PASTE BOTH]. Build a like-for-like comparison table. Put every line item on the same basis, flag anything one includes that the other does not, and list what is missing from both that I should be asking about.
Excel & Data
Formula from plain English
You know the answer you want, not the syntax.
My sheet has these columns: [LIST WITH ONE EXAMPLE ROW]. I want to [DESCRIBE THE ANSWER]. Give me the Excel formula, then the Google Sheets version if it differs, then explain in one line what could break it.
Excel & Data
Explain the number to a non-analyst
You have the analysis, now you have to present it.
Here is my analysis: [PASTE]. Write three sentences a non-technical director can repeat in their own meeting. Lead with the number that matters, then what caused it, then what we should do. No jargon, no hedging.