Uploaded December 2025 | Updated September 2026, 1 week ago
✅Download the free demo file and follow along here
➡️simonsezit.com/cleaning-data-in-power-query-webinar-demo-file
Master the essentials of data cleaning with this comprehensive training on Excel and Power Query. You’ll learn how to fix common data issues, format columns, extract information with functions, and organize datasets before transforming messy files using powerful automation tools in Power Query. Finish strong by building PivotTables, PivotCharts, and refreshable reports that keep your analysis accurate and efficient.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
SECTION 1
00:00:00 – Introduction
00:02:54 – Why Clean Data?
00:04:20 – Common Issues with Data
00:07:33 – Adjusting Rows and Columns
00:08:47 – Deleting Blank Rows
00:09:03 – Filling Blank Cells
00:11:27 – Clearing Messy Formatting
00:12:38 – Removing Duplicates
00:13:52 – Converting Numbers Stored as Text to Numbers
00:16:10 – Formatting Columns
00:19:05 – Cleaning Columns using Text Functions
00:24:43 – Finding and Replacing Data
00:25:23 – Check Spelling
00:26:13 – Formatting Data as a Table
00:33:46 – Using Functions to Extract Data
00:39:20 – Using Power Query to Clean Data
00:49:15 – Conclusion
SECTION 2
00:50:05 – Introduction
00:51:55 – What is Power Query?
00:52:32 – Example of a Messy Dataset
00:56:02 – Import a Text File with Get and Transform
00:58:59 – Power Query Editor
01:02:13 – Clean Dataset with Power Query Tools Part 1
01:13:17 – Clean Dataset with Power Query Tools Part 2
01:21:11 – Create a Pivot Table and Pivot Chart
01:24:37 – Update or Refresh Data
01:26:50 – Conclusion
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
✅Download the free demo file and follow along here
➡️simonsezit.com/cleaning-data-in-power-query-webinar-demo-file
Master the essentials of data cleaning with this comprehensive training on Excel and Power Query. You’ll learn how to fix common data issues, format columns, extract information with functions, and organize datasets before transforming messy files using powerful automation tools in Power Query. Finish strong by building PivotTables, PivotCharts, and refreshable reports that keep your analysis accurate and efficient.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
SECTION 1
00:00:00 – Introduction
00:02:54 – Why Clean Data?
00:04:20 – Common Issues with Data
00:07:33 – Adjusting Rows and Columns
00:08:47 – Deleting Blank Rows
00:09:03 – Filling Blank Cells
00:11:27 – Clearing Messy Formatting
00:12:38 – Removing Duplicates
00:13:52 – Converting Numbers Stored as Text to Numbers
00:16:10 – Formatting Columns
00:19:05 – Cleaning Columns using Text Functions
00:24:43 – Finding and Replacing Data
00:25:23 – Check Spelling
00:26:13 – Formatting Data as a Table
00:33:46 – Using Functions to Extract Data
00:39:20 – Using Power Query to Clean Data
00:49:15 – Conclusion
SECTION 2
00:50:05 – Introduction
00:51:55 – What is Power Query?
00:52:32 – Example of a Messy Dataset
00:56:02 – Import a Text File with Get and Transform
00:58:59 – Power Query Editor
01:02:13 – Clean Dataset with Power Query Tools Part 1
01:13:17 – Clean Dataset with Power Query Tools Part 2
01:21:11 – Create a Pivot Table and Pivot Chart
01:24:37 – Update or Refresh Data
01:26:50 – Conclusion
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
