This course can be purchased as part of the
Personal Development
bundle. Enquire here!
Personal Development

Cleaning Data in Excel with Power Query Part 1

This course is in the base subscription pack
Category
Personal Development
Bundle - Sub Category
Course Duration
0:06
Subject Matter Expert
Deb Ashby
Provider
Assemble You

If you've ever found yourself grappling with messy datasets or are new to the Power Query, this lesson is for you. In this lesson, we cover how to import your data and use Applied Steps, Power Query's editor, and the Undo functionality. By the end of this lesson, you'll be equipped with the knowledge and skills to efficiently clean datasets using Power Query and ensure accuracy in your data analyses.

Target Audience

Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.

Learning Outcomes

Clean and organise datasets in Excel using Power Query – navigate the Power Query Editor and use Applied Steps for data cleaning processes.