How to Clean Data in Excel in 10 Minutes (Free File)

Подписаться 613 тыс.

Просмотров 34 тыс.

50% 1

How to clean any data in Excel using these 11 data cleaning tips & tricks (beginner to pro).
👩‍🏫 Master Excel formulas with real-world examples: bit.ly/course240305
⬇️Download the example file here and follow along: www.myonlinetraininghub.com/h...
Duplicates, extra spaces, misspelt words, and poor formatting make our job harder than it needs to be. That's not even a complete list of dirty data types. Today's tutorial is all about mastering data cleaning in Excel. We've got a dataset that's a bit on the wild side with all sorts of common issues, but don't worry! We'll tackle this together starting with the basics and then moving on to more advanced topics.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
#Excel #ExcelData #ExcelTutorial

Наука

Опубликовано:

4 мар 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 65

@MyOnlineTrainingHub 3 месяца назад

❓What's your most memorable "oops" moment with data? Master Excel formulas with real-world examples: bit.ly/course240305

@whazee 3 месяца назад

I think my most memorable (and something I made sure to never do again) was leaving a blank column in a large dataset, applying a filter to about half of it, then proceeding to re-organise (sort) those columns without realising that the rest of the sheet wasn't being sorted with it. Did I have to start from scratch again? Yes... yes I did. 😣

@ignatiusmba-bo5rq 20 дней назад

Thank you so much for this video. Its Slow, steady and with a soothing way of talking that makes it easy to listen.

@MyOnlineTrainingHub 20 дней назад

That's wonderful to hear. Thank you so much! 😊

@GregoryGlynn 3 месяца назад

I've been using Excel since Release 1.0 on Windows 3 and Mynda still shows me things I haven't considered. I love watching her well-constructed and informative videos.

@MyOnlineTrainingHub 3 месяца назад

Thanks for your kind words, Gregory! I'm so glad it was worth your time to watch 🙏🥰

@randovids7147 3 месяца назад

You should trim before checking for duplicates !

@MyOnlineTrainingHub 3 месяца назад

Yes! Good tip 👍

@GeertDelmulle 3 месяца назад

And also use CLEAN() for that matter. ;-)

@randovids7147 3 месяца назад

@@GeertDelmulle that’s a good one.

@Locomaid 3 месяца назад

Excellent! Was my first thought, also

@MikandaMaboto 9 дней назад

Thank you for the video, it is easy to follow along. And I must say, you have a very impressive list of clients.

@MyOnlineTrainingHub 8 дней назад

Glad it was helpful! 🙏

@chrism9037 3 месяца назад

Thanks Mynda, great video for those building their early Excel skills!

@MyOnlineTrainingHub 3 месяца назад

Thanks, Chris. Appreciate you taking the time to watch.

@SothearithKONGMrMuyKhmer 3 месяца назад

That’s really helpful, as always! Thank you! ❤

@MyOnlineTrainingHub 3 месяца назад

So glad to hear!

@vijayarjunwadkar 3 месяца назад

Thank you Mynda, for this very useful video! While I knew some techniques, I learnt new ones as well and even with known ones, there was something extra I could pick up. Keep them coming! 🙂

@MyOnlineTrainingHub 3 месяца назад

Wonderful to hear, Vijay!

@peevee2552 3 месяца назад

Thank you, perfect for data processing starting positions :)

@MyOnlineTrainingHub 3 месяца назад

Glad you found it useful 🙏

@kebincui 3 месяца назад

Brilliant as always 👍, thanks Mynda

@MyOnlineTrainingHub 3 месяца назад

Glad you enjoyed it!

@Vlog88999 2 месяца назад

Thank you very much 🎉🎉

@MyOnlineTrainingHub 2 месяца назад

You're welcome 😊

@markpodesta4605 3 месяца назад

Thank you Mynda.

@MyOnlineTrainingHub 3 месяца назад

My pleasure, Mark!

@RJCapeTown 3 месяца назад

Wonderful summary thx!

@MyOnlineTrainingHub 3 месяца назад

Glad you liked it '🙏

@williamthatsmyname 3 месяца назад

Awesome . A quick an easy alternative to power query.

@MyOnlineTrainingHub 3 месяца назад

Yep, perfect for one off cleaning tasks 👍

@drendelous 3 месяца назад

i really like these short to the point guides

@MyOnlineTrainingHub 3 месяца назад

Awesome to hear! 🙏

@ajdesigns1660 17 часов назад

Thanks for the information and the data of famous personas was cool 😂

@MyOnlineTrainingHub 17 часов назад

Glad you liked it!

@tristangeoffroy9286 3 месяца назад

Thank you so much for the short cut: control shift V !!!

@MyOnlineTrainingHub 3 месяца назад

Glad you can make use of it 😊

@silversolver7809 3 месяца назад

Very good, thanks :)

@MyOnlineTrainingHub 3 месяца назад

Glad you liked it!

@intotheforestbiking6300 3 месяца назад

Love your videos! Would you make a tutorial on how to track net worth with live stock investment updates? I see a lot of interactive stock dashboards, but would also like to include my cash savings and other investment forms as well. Thanks!

@MyOnlineTrainingHub 3 месяца назад

Great suggestion! I’ll keep it in mind 👍

@reginaoon8239 2 месяца назад

Really helpful video! Avoiding having text (e.g. missing) in a column with numbers is new to me. Anyone knows the reason why we shouldn't do so?

@MyOnlineTrainingHub 2 месяца назад

Because mixing numbers and text creates an ambiguous data type for the column preventing Excel PivotTables from knowing whether it should sum the data or count the data by default. Also, text in a numeric column will return errors in formulas that are expecting numbers, as you saw in this video where I had to use IFERROR to handle the errors returned by text.

@williamzhangzhijun 3 месяца назад

Hello. As always, thanks for the great video. I want to ask, how to use multiple value filters on pivot tables. Others showed filtering on label + value. What i want is filters on multiple values. E.g. filter the 'Sum of A' greater than X number, AND display top 10 of those based on 'Sum of B'. Could you help? Thanks.

@MyOnlineTrainingHub 3 месяца назад

You'd have to use Power Pivot and write a DAX measure for that. i.e. it can't be done with a regular PivotTable.

@williamzhangzhijun 3 месяца назад

@@MyOnlineTrainingHub i see. I'll try that. Thank you for the reply. 👍❤️

@abbottkatz8830 3 месяца назад

You can also populate the Region dropdown list by selecting the entire Region column in the data validation dialog box instead of typing the regions. The resulting dropdown list will return a unique instance of each region.

@MyOnlineTrainingHub 3 месяца назад

But then it would allow you to type anything in the cell since the list is referencing itself.

@abbottkatz8830 3 месяца назад

@@MyOnlineTrainingHubThanks. I may be misunderstanding your point, but my approach will obstruct non-list entries. I meant that you can cite the Region range as the Source for Validation criteria.

@MyOnlineTrainingHub 3 месяца назад

When I test that I can enter anything in the Region range without the data validation flagging it.

@ThePianoEvangelist-kg2qw 3 месяца назад

Can you help us with how best we can show the work on portfolio for prospective clients..

@MyOnlineTrainingHub 3 месяца назад

I think it would be cool if you created an Excel file containing your portfolio. I don't have any examples though, sorry.

@tridibbiswas3361 3 месяца назад

Thank you for the video. Can we have the file for follow through

@MyOnlineTrainingHub 3 месяца назад

Sure, you can download it here: www.myonlinetraininghub.com/how-to-clean-data-in-excel

@tridibbiswas3361 2 месяца назад

@@MyOnlineTrainingHub Thank you

@progbadger7042 3 месяца назад

Proszę w o więcej takich filmów:)

@MyOnlineTrainingHub 3 месяца назад

Thanks for watching. I will try!

@hotcarlsf 3 месяца назад

Nice video. I physically cringed though when you did the formula in the random blank cells to reference the value above them. Someone did something like that in a spreadsheet they provided me before. It screwed me over. Using F5 on the keyboard is a another quick way to get to go to special

@MyOnlineTrainingHub 3 месяца назад

Yeah, probably a good idea to paste as values if you plan on sorting the data. Thanks for the F5 tip 👍

@drendelous 3 месяца назад

5:09 i have to use ; instead of ,

@GeertDelmulle 3 месяца назад

That is because you use "," as a decimal 'point' and "." as a thousand separator.