Power Query — Excel Course

Import, clean, combine and refresh data. Learn it step by step with guided practice on Excelquro.

Understand

A Power Query workflow is a pipeline: source → type/shape corrections → cleaning → filtering → combining/reshaping → load. Order matters. For example, convert numeric text before numeric filters, and standardize values before grouping them.

Worked example

The sequence can be refreshed against a new source file without manually repeating each edit.

Trim → Type conversion → Remove duplicates → Filter

Follow along

1. Inspect the raw source before changing it.
2. Trim and standardize text fields.
3. Convert numbers and dates to real types.
4. Remove blanks and duplicates using defined keys.
5. Filter or remove unwanted fields.
6. Refresh the query with another sample file and validate the output.

Interactive practice runs in your browser.