Power Query
What you will be able to do
- Import data from files, workbooks and folders
- Clean and reshape data with repeatable steps
- Append and merge queries
- Automate a monthly import
19 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Getting data in
- What Power Query is and when to use itReal Excel
- Loading data from a table or rangeReal Excel
- Importing a CSV or text fileReal Excel
- Importing from another workbookReal Excel
- The Query Editor: applied stepsReal Excel
Module 2: Cleaning
- Data types and why they matterReal Excel
- Removing columns, rows, blanks and errorsReal Excel
- Splitting and merging columnsReal Excel
- Replace values, Trim and CleanReal Excel
- Fill DownReal Excel
- UnpivotReal Excel
- Pivot columnsReal Excel
Module 3: Combining
- AppendReal Excel
- MergeReal Excel
- Join types: left, inner, antiReal Excel
- Combining every file in a folderReal Excel
Module 4: Delivering
- Group By, custom and conditional columnsReal Excel
- Load options, refresh and parametersReal Excel
Project: automated monthly bank and ledger import
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free