Get an intro to Power Query, a set of robust features in Microsoft Excel.
Overview
Syllabus
Introduction
- What is Power Query in Excel?
- What you should know
- Getting data from another file
- Getting data from an open workbook
- Common cleaning tasks
- Filtering and sorting data
- Splitting columns
- Conditional columns
- Next steps
Taught by
Dave Ludwig