Cleaning Data in Power Query – Recorded Webinar
In this recorded live webinar, we’ll teach you the best tips and tricks for cleaning data in Power Query in Microsoft Excel.
Your expert Excel trainer and Microsoft MVP, Deb Ashby, discusses what Power Query is and provides an example of what a messy Excel dataset looks like. She will walk you through importing a text file using the Get & Transform function, using the Power Query Editor, cleaning your dataset using Power Query tools, creating a PivotTable and Pivot Chart, and so much more!
In this month’s webinar, Deb discusses the following:
- What is Power Query?
- Example of a messy dataset
- Can we copy and paste?
- Import a text file with Get & Transform
- The Power Query Editor
- Clean the dataset with Power Query tools
- Remove top rows and blank rows
- Merge columns
- Apply filters
- Split columns
- Promote headings
- Rename columns
- Trim columns
- Change data types
- Add a custom column
- Close and load to Excel
- Create a PivotTable and Pivot Chart
- Update/refresh data
Watch the session here, and download the instructor demo file to follow along.
Cleaning Data in Power Query – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Practical Uses of Lookup Functions in Excel
Practical Uses of Logical Formulas in Excel
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!
