Query Editor is a powerful data transformation and preparation tool integrated into Excel. Users can profile, clean and shape their data from an Excel worksheet, without writing complex formulas or code, making it an essential skill for anyone working with large or messy datasets
This masterclass will show you how to bring your data from an Excel worksheet into Query Editor and use a range of tools to identify and resolve data errors and inconsistencies so your data is suitable for analysis
Content
- Understand the role of Power Query Editor in Excel worksheets: Bring your data into Power Query Editor to identify and resolve errors quickly and efficiently
- Clean and Transform your data: Discover a wide range of tools such as Split Columns, Unpivot, Trim, Extract and Format
- Profile your data: Use Column Quality, Profiling and Distribution to identify errors in your dataset
Target Audience
This masterclass is designed for anyone who uses Excel to prepare and cleanse data for analysis and wants to develop their skillset further
