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 ➡️
www.simonsezit.com/article/im...
📝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 ➡️
www.simonsezit.com/article/im...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
Check out our Excel 2021 tutorials for beginners playlist here
✅ • Excel 2021/365 Trainin...
Check out our FREE 300+ hour training course playlist here ➡️
🔥 • Simon Sez IT Long Trai...
💻Watch more popular tutorials from Simon Sez IT:
✅Microsoft Office 2021 and Office 365 Training Tutorials playlist
👉 • Microsoft Office 2021 ...
✅Microsoft Office 2019 Training Tutorials for Beginners playlist
👉 • Microsoft Office 2019 ...
✅ PivotTable training here 👉 • Pivot Tables - All you...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZfaq Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
🔔Subscribe to our channel:
👉kzfaq.info...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)