Master Data Cleaning Essentials with Power Query and Excel

Learn essential data cleaning techniques through this comprehensive webinar covering both Excel and Power Query methods. Discover how to identify and resolve common data issues including blank rows, messy formatting, duplicates, and incorrectly stored numbers while mastering column formatting and text functions for data extraction. Explore Power Query's automation capabilities to transform messy datasets efficiently, then apply your cleaned data to build dynamic PivotTables, PivotCharts, and refreshable reports that maintain accuracy over time. Practice hands-on with provided demo files as you progress through systematic data cleaning workflows, from basic Excel techniques to advanced Power Query transformations, culminating in professional reporting solutions that streamline your data analysis process.

Syllabus

– Introduction
– Why Clean Data?
– Common Issues with Data
– Adjusting Rows and Columns
– Deleting Blank Rows
– Filling Blank Cells
– Clearing Messy Formatting
– Removing Duplicates
– Converting Numbers Stored as Text to Numbers
– Formatting Columns
– Cleaning Columns using Text Functions
– Finding and Replacing Data
– Check Spelling
– Formatting Data as a Table
– Using Functions to Extract Data
– Using Power Query to Clean Data
– Conclusion
– Introduction
– What is Power Query?
– Example of a Messy Dataset
– Import a Text File with Get and Transform
– Power Query Editor
– Clean Dataset with Power Query Tools Part 1
– Clean Dataset with Power Query Tools Part 2
– Create a Pivot Table and Pivot Chart
– Update or Refresh Data
– Conclusion