Cleaning data in Excel with Power Query, Part 1

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 wi...

Full description

Bibliographic Details
Corporate Author: Assemble You Limited
Format: eBook
Language:English
Published: [Place of publication not identified] Assemble You 2024
Edition:[First edition]
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
Summary: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. Learning Objectives Clean and organise datasets in Excel using Power Query - navigate the Power Query Editor and use Applied Steps for data cleaning processes
Physical Description:1 video file (8 min.) sound, color