Data cleaning in Excel is one of the most important things you can do in Excel. If you need to perform data analysis in Excel, then you need to use clean data.
What do we mean by clean Data in Excel? We mean data that is free from errors, formatting issues, data that have numbers stored as text, has dates stored as numbers, data with gaps in it, and every other error you could think of. This often happens in Excel when data is downloaded from a third-party system, like accounting software, a CRM, or Email Service Provider.
In this one-hour session, we show you how to use the various text functions in Excel to clean your data. We then move on to using Power Query to clean data and Power Query to join data.
If you'd like to follow along with this session, you can download the data set we use below.
Download the Excel Workbook and follow along ️
https://www.simonsezit.com/article/importing-and-cleaning-data-in-excel/
Excel Tutorial Markers:
0:00:00 - Introduction
0:03:37 - Why Clean Data
0:06:58 - Widen Columns in Excel
0:09:46 - Delete Blank Rows in Excel
0:10:05 - Fill Empty Cells in Excel
0:11:38 - Clear Formatting
0:12:58 - Remove Duplicates
0:14:41 - Format Columns
0:17:36 - Numbers Stored as Text in Excel
0:20:24 - Changing Case Using the Text Functions
0:26:19 - Find and replace in Excel
0:28:55 - Importing Data into Excel from a Text File
0:41:54 - Using Text Functions to Extract Data
0:51:29 - Import Data into Excel from an Access File
0:56:52 - Combining Files in Power Query
1:00:06 - Basic Clearing in Power Query
1:05:44 - Updating Queries in Power Query
Download the Excel Workbook and follow along ️
https://www.simonsezit.com/article/importing-and-cleaning-data-in-excel/
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb
Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Watch more popular tutorials from Simon Sez IT:
Microsoft Office 2021 and Office 365 Training Tutorials playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Microsoft Office 2019 Training Tutorials for Beginners playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7
PivotTable training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)