Completed
– Create a Pivot Table and Pivot Chart
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Master Data Cleaning Essentials with Power Query and Excel
Automatically move to the next video in the Classroom when playback concludes
- 1 – Introduction
- 2 – Why Clean Data?
- 3 – Common Issues with Data
- 4 – Adjusting Rows and Columns
- 5 – Deleting Blank Rows
- 6 – Filling Blank Cells
- 7 – Clearing Messy Formatting
- 8 – Removing Duplicates
- 9 – Converting Numbers Stored as Text to Numbers
- 10 – Formatting Columns
- 11 – Cleaning Columns using Text Functions
- 12 – Finding and Replacing Data
- 13 – Check Spelling
- 14 – Formatting Data as a Table
- 15 – Using Functions to Extract Data
- 16 – Using Power Query to Clean Data
- 17 – Conclusion
- 18 – Introduction
- 19 – What is Power Query?
- 20 – Example of a Messy Dataset
- 21 – Import a Text File with Get and Transform
- 22 – Power Query Editor
- 23 – Clean Dataset with Power Query Tools Part 1
- 24 – Clean Dataset with Power Query Tools Part 2
- 25 – Create a Pivot Table and Pivot Chart
- 26 – Update or Refresh Data
- 27 – Conclusion
