Cleaning Data in Excel: Microsoft Excel Crash Course

Рет қаралды 58,930

Күн бұрын

✅Download the free demo file and follow along here
➡️www.simonsezit.com/cleaning-d...
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
🖥️ www.simonsezit.com/course-cat...
🌍 Get unlimited training with Simon Sez IT’s 160+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ www.simonsezit.com/ssit-first...
Looking for Excel tricks or Excel tutoring? Check out our Excel 2021 tutorials for intermediate users playlist here:
🔥 • Excel 2021 Tutorials f...
For more recorded webinars from Simon Sez IT, take a look at this playlist
🔥 • Simon Sez IT Live Webi...
Check out our FREE 300+ hour training course playlist here ➡️
🔥 • Simon Sez IT Long Trai...
🖥️Watch more popular Microsoft tutorials from Simon Sez IT:
✅Excel 2021 Tutorials for Beginners playlist
👉 • Excel 2021/365 Trainin...
✅Microsoft Office 2021 and Office 365 Training Tutorials
👉 • Microsoft Office 2021 ...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZfaq Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
Please SUBSCRIBE 🔔 kzfaq.info...
♥️ We appreciate your support!
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 55

@SimonSezIT Жыл бұрын

Download the free course files to follow along ➡www.simonsezit.com/cleaning-data-in-excel-webinar-demo-files Check out our FREE 300+ hour training course playlist here ➡ 🔥kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@rodpascual5573 Жыл бұрын

Hi Simon, I would appreciate if you could send me the 2017 and 2018 CSV file please. I have a presentation on the first of March 2023. Thanks

@nnamanichidera6647 7 ай бұрын

Please can I get the raw data so as to practice more. Thanks, great lesson.

@mahendrashekhawat4798 6 ай бұрын

@@nnamanichidera6647 I also need

@rajeevgosavi4514 Жыл бұрын

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.

@SimonSezIT Жыл бұрын

So nice of you, thanks!

@sumonahmed744 10 ай бұрын

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

@simonoganga9535 Жыл бұрын

Amazing teaching Ashby, I always love your webinars.

@rezvanyegane4300 Жыл бұрын

it's worth watching again and again. Thanks

@midnajo437 Жыл бұрын

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

@jakehuai Жыл бұрын

Thanks for the demonstration. It's so helpful.

@olufemiolawale3848 11 ай бұрын

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

@SimonSezIT 11 ай бұрын

Wonderful! Thanks for the visit :-)

@razzaqfasherazzaq1636 Жыл бұрын

Thank you , very useful..

@biglo813 Жыл бұрын

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🎉🎉🎉

@SimonSezIT Жыл бұрын

Wow, thanks! Glad it was helpful. 🙂

@NurSofi-pn2gz Жыл бұрын

useful ,thanks .

@FreeFire-ub7rj Жыл бұрын

Thank you

@naahidul Жыл бұрын

Really appreciate your effort. Really helpful and comprehensive.

@SimonSezIT Жыл бұрын

Thanks for the nice comments, Nahidul Islam 😀

@SothearithKONGMrMuyKhmer Жыл бұрын

Thanks Deborah! That’s really helpful! 👏

@SimonSezIT Жыл бұрын

You are so welcome!

@jasonwamp4325 5 ай бұрын

Thank you. Appreciate your work.

@SimonSezIT 5 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@sandipanmajumder9419 11 ай бұрын

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

@SimonSezIT 10 ай бұрын

Thanks for the love and appreciation ;-)

@amarankali646 7 ай бұрын

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

@SimonSezIT 7 ай бұрын

You are very welcome! Thanks for watching 🙂 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support! 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

@wwpharmacist Жыл бұрын

Very helpful Thanks

@SimonSezIT Жыл бұрын

Happy to help!

@christianmarshrosey1977 2 ай бұрын

Great tutorial!

@SimonSezIT 2 ай бұрын

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@DIY_Foodie 11 ай бұрын

amazing tutorial hatsoff

@SimonSezIT 11 ай бұрын

Glad you liked it

@kingstonmazulu8547 Жыл бұрын

Very very useful

@SimonSezIT Жыл бұрын

Glad you think so!

@samiahussain8316 2 ай бұрын

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.

@olusolaaiki3642 4 ай бұрын

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

@user-yo2gk9tm8k 4 ай бұрын

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

@MdKarim-rj3op 9 ай бұрын

Thanks mame

@SimonSezIT 9 ай бұрын

You're very welcome 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI We have additional free tutorials for various data analysis tools and services here 👉 kzfaq.info/sun/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@keylanoslokj1806 7 ай бұрын

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?

@salaheddinelahlali4698 Жыл бұрын

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

@jeremysimmons9285 Жыл бұрын

Better than Coursera!

@mayasam1326 9 ай бұрын

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

@SimonSezIT 9 ай бұрын

Glad you enjoyed it. Thanks for watching! 🙂 🔥 We have free tutorials for Power Query here 👉kzfaq.info/get/bejne/bpaYp9NzxpyzkYE.html Check out our FREE 300+ hour training course playlist here ➡️ 🔥kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!

@JackBlossom1789 6 ай бұрын

27:45 CLEAN(TRIM(PROPER(C2))) does not remove line break To work this formula, we need to put proper the top of them like PROPRE(TRIM(CLEAN(C2))) or PROPER(CLEAN(TRIM(C2))) Since I got "GerMany" when I just followed the video....

@user-sh1vv7ev9w 9 ай бұрын

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!

@keylanoslokj1806 7 ай бұрын

So what do you do in that case to clean them?

@Barchafel Жыл бұрын

Suriname😎

@henrybakky7523 Жыл бұрын

I just joined your webinar,quite educative and easily delivered for somebody just starting to take IT as a profession. I will love to have a download of previous presentations. Thanks for the good job

@SAXENA2904 Жыл бұрын

@shyanimukherjee2043 Жыл бұрын

Visibility is not clear

@SimonSezIT Жыл бұрын

To ensure the best video experience, set the video playback quality to 1080p HD. Click on the gear icon ⚙️ located in the bottom right corner. If the font size looks too small, you may need to watch the video in full screen mode.

@SAXENA2904 Жыл бұрын