Video description
Ready for the second part of Cleaning Data in Excel with Power Query?
In this lesson, we're transforming our unruly dataset for easy, organised data analysis. We'll start by removing unnecessary rows and blank spaces and getting rid of any unwanted elements. We’ll explore techniques to align and split columns for a more structured layout.
We'll explore clever tricks to handle any quirks in your data. By the end, you'll have a refined dataset ready for analysis.
Learning Objectives
- Remove unnecessary rows, handle blank spaces, merge and split columns, and fine-tune data types.
Table of contents
Product information
- Title: Cleaning Data in Excel with Power Query Part 2
- Author(s):
- Release date: March 2024
- Publisher(s): Assemble You
- ISBN: None
You might also like
video
Cleaning Data in Excel with Power Query Part 3
Welcome to the final instalment of our three-part series on Cleaning Data in Excel with Power …
video
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, …
video
Combine Files in Power Query in Excel
This lesson explores how to merge multiple files housed in a designated folder using Power Query. …
video
Organising Data with Subtotals in Excel
This lesson explores the feature that simplifies dataset summarisation. Subtotals enable you to calculate and display …