Learn quick ways to become more organized and efficient when using Power Query, a tool inside Microsoft Excel that lets you search, connect, and shape data.
Overview
Syllabus
Introduction
- Get more from Power Query
- What you should know
- Disable auto detect data type
- View monospaced
- Rename column
- Move, insert, and delete query steps
- Rename steps in a query
- Determining query dependencies
- Navigate to new source
- Change load-to destination
- Reference a query
- Duplicate a query: Recycling
- Duplicate a query vs. reference a query
- Delete steps until the end
- Cross join: Matching everything with everything
- Rename queries
- Copy and paste queries to a new workbook
- Merging and segmenting data: Anti-join
- Merge queries as new
- Filtering in Power Query
- Sorting in Power Query
- Pass parameter: Drill down to a single value
- Prevent table from resizing
- Transformation table
- Filter for certain files when importing from a folder
- Warning: Two types of merges
- Splitting columns
Taught by
Oz du Soleil
