Track · Dashboards · Power Query

Power Query: clean messy exports

10 lessons on report exports that look like the real thing: title rows, subtotals, text numbers, mixed dates and NDC formats, month columns. Work them in Excel's Power Query (Get & Transform), with a plain-Excel route noted for each. Synthetic data only.

How it works. Pick dataset A, B or C, download the export a lesson names (CSV, or .xlsx with real merged cells and dates), clean it, and type the answer. Reviews come back on the next dataset, so build each query once and reuse it.

Power Query is in Excel for Windows, Excel for Mac and Excel for the web (Data › Get Data). NDC-style codes in these files are made up and do not identify real products. ← Back to Dashboards · Practice lab

Dataset

No Power Query? Plain-Excel route

🧠 Recall card: