◆ Excel · clean

Data Standardization

Standardize consultants' cost submissions: import each cost sheet into Power Query, unpivot fee line columns, split co…

2heights

60tasks

10roles do it

The same job, four heights

do it · improve it · decide · become

AExecute — “help me do it”Standardize consultants' cost submissions: import each cost sheet into Power Query, unpivot fee…+

Standardize consultants' cost submissions: import each cost sheet into Power Query, unpivot fee line columns, split combined description columns into Role and Scope, and output a single cleaned table sorted by consultant and line item for direct comparison.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

BImprove — “do it better”Before I present the consolidated fee schedule, make comparisons straightforward — normalise…+

Before I present the consolidated fee schedule, make comparisons straightforward — normalise currency and VAT treatment, add a column showing original file and row for audit, flag missing rate bases, and produce a pivot that compares identical line descriptions side-by-side so the design team can spot scope gaps quickly.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

8 of them

Standardize multiple consultants' cost submissions into one format so I can compare fees line-by-line.

Standardize every supplier invoice date format into the same column so my month-to-month reports work.

Apply a controlled list of genres and locations to new entries so everyone uses the same terms when cataloguing.

Standardize inconsistent donor dates and combine them into a single provenance timeline for appraisal meetings.

Standardize dates from different intake forms so every client's session timeline lines up correctly in reports.

Standardize all transaction dates from multiple sources so periods line up for the audit.

Standardize every date column from our multiple sources so time-based analysis lines up across reports.

Convert spreadsheets from multiple vendors into consistent dates, names and numeric formats so our briefing books don't break.

Who does this

10 roles

Architectural Project ManagerAuditorBusiness Intelligence AnalystCampaign ManagerCompliance ManagerConstruction ManagerPeople Operations ManagerRegulatory Affairs AnalystSales ExecutiveTransportation Planner

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.