Cleaning Data in Excel with Power Query Part 1

Cleaning Data in Excel with Power Query Part 1

Video • 8 minutes

Learning Objectives

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

    Lesson Description

    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.