Cleaning Data in Excel: Microsoft Excel Crash Course

✅Download the free demo file and follow along here

In this Microsoft Excel tutorial, we'll walk you through various formulas and functions that can help you with cleaning data in Excel. We'll discuss the common issues you may encounter with your data set and teach you various ways to clean and manipulate data before moving on to using Power Query to import, combine, and clean up data.

Check out the latest Microsoft courses from Simon Sez IT

Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:

For more recorded webinars from Simon Sez IT, take a look at this playlist

Check out our FREE 300+ hour training course playlist here ➡️

🖥️Watch more popular Microsoft tutorials from Simon Sez IT:

✅Excel 2021 Tutorials for Beginners playlist

✅Microsoft Office 2021 and Office 365 Training Tutorials

💬Stay in touch!

♥️ We appreciate your support!

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[SimonSezIT]

Check out our FREE 300+ hour training course playlist here ➡

[simonoganga]

Amazing teaching Ashby, I always love your webinars.

[rajeevgosavi]

There can not be a better explanation of cleaning data. Very nicely and lucidly explained. Thank you very much and looking forward to more such tutorials also on power query.

[midnajo]

Excellent Video as usual. Thank you very much for posting.

[jakehuai]

Thanks for the demonstration. It's so helpful.

[sumonahmed]

I'm from Bangladesh. I'm falling in love with your way of teaching. I want to learn more from you.

[rezvanyegane]

it's worth watching again and again. Thanks

[biglo]

OMG this was so good and informative I absolutely love how you give multiple avenues and using the operations and a very organized and clear in actual teaching the functions not just showing them🎉🎉🎉

[olufemiolawale]

I always like your style of teaching. I must confess this! Thanks so much, I am getting better!

[naahidul]

Really appreciate your effort. Really helpful and comprehensive.

[sandipanmajumder]

thank you ma'am for such a great Excel course. This one video was enough to learn all essential Excel tricks ❤❤
You've designed this crash course in good manner, THANK YOU AND LOTS OF LOVE

[SothearithKONGMrMuyKhmer]

Thanks Deborah! That’s really helpful! 👏

[amarankali]

Thank you mam, it helps very much to me, Respect from India 😊

[salaheddinelahlali]

hi in the first thanks for your amazing courses about cleaning data just an little remark in 46:11 minutes the fields in column date aren't in the same format can you madame give us one method to normalize the date format in dd/mm/aaaa have nice day madame

[yogktmk]

Hi! Unfortunately, you can't get the table file from the video for free at the link provided. At least for today

[mayasam]

Can you do course on powerquery
You explain very well n in detail

[keylanoslokj]

What if you have stacked data on one column, and wanna separate it on three distinct columns? But it's not easy cause manufacturer name has blue fill, brand name has indented and bold name. And specific items have more indented and non bold fonts. So how do you sort this data if its hundreds of lines?

[samiahussain]

Hi, I am working on logistic regression. My categorical variables contain no of yes=1, no=2. However, there are many data which are 96/97/98. I don’t need them. How can i clean them? I tried by giving these values in one number, but my results are changing. Please give suggestions.

[olusolaaiki]

Hello, I can't download the free demo files to follow up on this tutorial. I'm asked to register and pay.

[shvvevw]

in addition to numbers formatted as text, numerical values, especially with leading 0's, used as unique identifiers (like IMEI or SIM IDs) formatted as a number - the worse is formatted as an exponential number. These identifiers are values you will never apply arithmetic operations to like +, -, x!