Prerequisites
To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.
Goal
Get data where ever it exists, clean it and transform it, combine it and analyze it all together.
Excel Power Query Topics
- What is Power Query?
- DataSources
- Connect to a web data source
- Connect to a spreadsheet
- Connect to a database
- Add a Wikipedia page data source
- Organizing Data
- Build repeatable processes to filter, clean, aggregate, and transform.
- Shape data in the subject table
- Remove Other Columns to only display columns of interest
- Replace Values to clean up values in a selected column
- Filter values in a column
- Queries
- Name a query
- Load the query to a worksheet
- Share queries and their data with other users in your organization
- Common Problems Solved
