Master Data Cleaning Essentials on Excel in Just 10 Minutes

Рет қаралды 451,060

Күн бұрын

Lear Data Cleaning Essentials in Excel in just 10 minutes
👉 Take our Excel course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video:
view.flodesk.com/pages/6482f5...
In this video you'll learn 10 data cleaning tricks on Excel. We'll go from having a raw dataset that has several errors, to a clean dataset that we can present to our managers. For this, we learn tricks such as text to columns and remove dupilcates, and several formulas such as the trim, proper, lower, iferror and more.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Autofit Rows and Columns
1:17 - Find & Replace
2:17 - Lower & Upper
3:39 - Trim & Proper
5:50 - Text to Columns
7:00 - Removing Duplicates
7:29 - Filling Empty Cells
8:28 - IFERROR
9:22 - Formatting
9:43 - Gridlines
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 192

@KenjiExplains 11 ай бұрын

🚀Take our Excel course here: www.careerprinciples.com/courses/excel-for-business-finance

@sabisabss1507 11 ай бұрын

Hello Kenji, Hope you’re doing great. Watching you from Angola (Africa). I currently do not have a credit card, and I’ll like to take the advance Excel classes as I’ll be needing it to improve on my data analytics skills at work. I can pay via Western Union? Looking forward to hearing from you.

@abdulsalambamidele5389 10 ай бұрын

how do I download RAW DATA to practice on my laptop??

@shivanandsoodi8854 5 ай бұрын

Sir pls tell me how download data u pinned

@themajestyjoshua 5 ай бұрын

@@abdulsalambamidele5389visit kaggle

@muhammadlimanmahdi3934 Ай бұрын

@shabbirhussain8429 5 ай бұрын

No time waste, no irrelevant talk, just to the point. Keep up the good work.

@dakesim 2 ай бұрын

=TRIM(PROPER(D3)) is the most beautiful thing I've seen this week! Thank you, Kenji! Your voice is so soothing it just gives me confidence that I can learn to become an advanced Excel user.

@stevenashley2626 2 ай бұрын

Indeed!!

@dhrumilpatel98 11 ай бұрын

I only can appreciate you for your time you're putting in for us. You're awesome and keep doing this good work.

@j_orpz 11 ай бұрын

Woooooooow the proper/trim combo is a game changer. Thanks!

@dantherman4202 11 ай бұрын

You're the man, Kenji! I have been using excel for a decade and still find something new for myself in every one of your videos. Best wishes.

@KenjiExplains 11 ай бұрын

Thanks for your message Dan! Really appreciate it glad you find the content useful 👍

@dineshgohil2808 7 ай бұрын

Kenji, I am a retired person. But still i love to learn new thins. i loved your simple and concise way of presentation. Great presentation. Keep posting. God bless you with Spectacular success!

@atinOO7 8 ай бұрын

Such simple & easy to remember shortcuts ...thanks kenji

@ldmlhome 10 ай бұрын

Thank you for your clear concise explanations and visual companion to the steps. I am loving your videos and appreciate the excellent Excel shortcut reminders! You are already saving me tons of time!

@The_Spontaneous_Adventurer 8 ай бұрын

This lesson was very insightful. Thank you

@hoanganhnguyen8206 8 ай бұрын

thank you for your service to excel learners like me! God bless you!

@hashimqotaje5886 8 ай бұрын

Kudos brother. Your an IT specialist. I am looking forward to learning data validation and data Visualization in your next upcoming videos.

@tanjinasuchi6609 8 ай бұрын

Thanks a lot, your way of delivering is awesome. I find this video very helpful for me. Thanks again!

@efledasongalia1375 11 ай бұрын

Hurray! Super helpful video. Thank you so much for sharing!💯💯💯

@starboi_6 8 ай бұрын

You are a life saver Kenji Thanks alot for those useful tricks 😘

@Phamousman 11 ай бұрын

Great video, and very easy steps to follow

@franksterkb891 8 ай бұрын

wow thanks for the practice file. really handy so we could follow your steps. cheers

@musamaiza6259 5 ай бұрын

Love your work Bro. Appreciate your effort to help people like learn analytics

@manal2271986 7 ай бұрын

شكرا لك معلومات قيمه يا استاذ ..

@searchbug 7 ай бұрын

What a time-saver! Your 'Master Data Cleaning Essentials on Excel in Just 10 Minutes' vlog is amazing. The quick and clear tips you shared are pure gold for anyone working with data in Excel. Thanks Kenji for making data cleaning so efficient and easy to understand.

@Potencyfunction 4 ай бұрын

It is facilitating greens sheets. That must be an outcome, to facilitate other services by deleting data and using of unapproved version. That is the whole start basis on the sheet. How can it be continued, whit suck smell and difficulty to understand out ?

@mycophil Ай бұрын

This is pure awesomeness. Thank you!

@shukanyakhan3991 5 ай бұрын

Thanks, the video is really great, I have truly learned something. It's awesome. Looking forward to watching and practicing other lessons as well. Best wishes Kenji!

@dccd673 2 ай бұрын

In every Excel tutorial I have watched, I learn something new. Adding this to my Excel playlist lol

@niyasrahmannr716 9 ай бұрын

Well done brother.❤

@shemustnotbenamed 6 ай бұрын

Very helpful! Thanks, Kenji☺️

@ibrahimasylla7256 7 ай бұрын

You are the best Kenji !

@syedimraan5091 10 ай бұрын

Thank you so much! it has helped me in so many ways

@olajideadeboyejo171 4 ай бұрын

Short video with a very good insight in data cleaning

@mohamedfarah7762 27 күн бұрын

Master Kenji your explanation is very good and concise and thank you, go ahead to benefit from you.

@knux5796 3 ай бұрын

best vid. so much info in the span of 10mins 👏

@user-lf9ts8ld4s 7 ай бұрын

start my Excel trip from here. Thank u

@stresslaxing. 11 ай бұрын

Welcome back KEnji. Helpful tutorial. Thanks!

@KenjiExplains 11 ай бұрын

Thank you for supporting!

@Linkmeprofessional Ай бұрын

Thank you for sharing. I like your tutorials.

@AdamArzemy Ай бұрын

You managed to cover most of the data cleasing in just 1 video 👏🏻👏🏻👏🏻

@ganiyulovesdata Ай бұрын

SUCH A GREAT VIDEO! THE ALGOROTHM BLESSED ME

@BB-pv6cf Ай бұрын

Wow!! This is so wonderful; all this time i was so scared about data cleaning

@rehansiddique1875 22 күн бұрын

Very great tutorial, learned a lot

@Ravikanth.Asokan 3 ай бұрын

Great help Sir. Thank you.

@je2740 9 ай бұрын

Nice job. 🎉

@dkwizera 5 ай бұрын

Love you Kenji, You're super!!!!

@victorbegnini5754 8 ай бұрын

Man, great video! So much info in a short clip. Your videos are my newest addiction as I'm new to this world Cheers and congrats! 🎉

@KenjiExplains 8 ай бұрын

Thank you Victor! Glad you like them

@Gambit889 4 ай бұрын

This is awesome. Often we concentrate on other functions and wasting time on data cleaning.

@raymondasamoah3895 3 ай бұрын

Great job. You got it. awesome job.

@hnquran1002 7 ай бұрын

Thank you bro

@niharickakaul741 7 ай бұрын

this is so good...thanks

@re26channel32 10 ай бұрын

Hi Kenji, I love your video content, and very useful in handling my data, however, incident reports both human-induced and natural such as landslides, felled, and uprooted trees. Do you have any dashboard that could fit this data, Thank you very much....

@newme7766 8 ай бұрын

Wow 👌. I really don't know excel 😅. You've made me love excel, good Job.

@user-ic3sj1nw5v 5 ай бұрын

You are really good, thank you.

@eedd4255 Ай бұрын

thank you so much

@ernunal 5 ай бұрын

It was a really instructive and neat video. 🎉

@maryokon6146 Ай бұрын

Thanks so much

@rowenadiemsen2886 9 ай бұрын

Thank you

@jasonwamp4325 3 ай бұрын

Thanks bro. Too good.

@Coach-rq6jx 6 ай бұрын

Appreciate it, brother.

@abdikadirbarre2525 2 ай бұрын

THANK YOUUUUUUUUUUU my brother

@user-dm8zs6xq7m 6 ай бұрын

what a fantastic keep going, thank you too much.

@soodabahabibzai5814 Ай бұрын

Loving it

@Cakuyoas 5 ай бұрын

Thank You.....

@abdullahmiazi6666 Ай бұрын

this is a beautiful video

@user-mb3hw2mp9k 6 ай бұрын

Thankyou !!!

@astra9225 6 ай бұрын

thanks bunch man

@mowburnt 9 күн бұрын

Mind blown in the first couple of minutes. Never knew about the wildcard in replace or Alt V H H - been searching for that shortcut for years!

@mowburnt 9 күн бұрын

And Proper… awesome

@mowburnt 9 күн бұрын

And text to column - doh - could’ve used that today instead of finding the hyphen and trimming text doh lol

@KenjiExplains 9 күн бұрын

Glad it was helpful :)

@antoninpoint-cd9fy 26 күн бұрын

I have just watched this video and this is amazing stuff, thanks for your work. To complete the data cleaning, maybe we also could have sorted the date column =)

@RahulJaiswal-xw6pf 3 ай бұрын

Too Helpful video

@kirangurung3108 4 ай бұрын

Thanks great video.. plz make data cleaning for beginner to pro..

@rexbk 8 ай бұрын

Hi Kenji, have you ever used or created Accounting Software using Excel?

@williamsolufemi3636 7 ай бұрын

You're good!!

@lieutenantsvince9476 11 ай бұрын

MERCI KENJI

@camlex6310 11 ай бұрын

Great tutorial!! Cheers

@KenjiExplains 11 ай бұрын

Glad you liked it!

@leophrix 10 ай бұрын

thanks

@sharfaraazs9367 3 ай бұрын

T R Thala ❤❤., neega intha video le irukinga😅 . Love from Tamil Nadu - India

@kanazspidirmostafahahsemi5771 Ай бұрын

very useful

@poongak 10 ай бұрын

Thank you for your great teaching. Would you please tell me how to add shape or color during video? Please tell me how to add vodeo effects. Because i need it for questions for explain my situation. Thank you.

@thaivang8726 11 ай бұрын

This is so interesting. You made Excel easy to learn and do data analysis.

@KenjiExplains 11 ай бұрын

Glad it was helpful!

@hunadikgwale372 16 күн бұрын

Awesome

@jonathanwambua6477 11 ай бұрын

Very impressive tutorial from Kenji...have gathered more skills of navigating Excel......bravo bro,,Am from kenya,Machakos county

@KenjiExplains 11 ай бұрын

Great to hear that! Thanks for watching!

@ashutoshthapa3184 8 ай бұрын

Thanks brother 🫂

@willzinner8813 11 ай бұрын

youre back sir keep going

@KenjiExplains 11 ай бұрын

Thank you, I will

@vikramadityarathore97 11 ай бұрын

Great stuff kenji .

@KenjiExplains 11 ай бұрын

Thanks for watching!

@waynez8136 9 ай бұрын

Excel samurai 👍

@emmanuelnwachukwu6071 10 ай бұрын

Kenji!!!🙌

@princedestinyugo5514 11 ай бұрын

This is hands-on! I cannot thank you enough. ❤

@KenjiExplains 11 ай бұрын

Glad you like it!

@princedestinyugo5514 11 ай бұрын

Thank you Kenji. ❤ You just simplified what often seems like a Rocket Science 📡 The data you provided was very helpful as it provided an opportunity to follow your Tutorials, step by step 👌🤗🤗🤗🤗 I will register for the course with Career Principles👍!

@mohankathe3332 2 ай бұрын

Thank you so much Sir. For Department and Region I applied Flash fill method CTRL E. And another thing I used CTRL H and replace blank space with N/A. instead of Go to Special method. Am I wrong? I appreciate your answer. Thanks....

@kingbonetti5978 9 ай бұрын

Hello do u have excel formation for marketing ?

@fakeitsoyoumakeit 2 ай бұрын

brilliant man keep on!!!

@amoprince4353 11 ай бұрын

It’s so interesting watching you! Thanks for what you do!

@KenjiExplains 11 ай бұрын

Thanks for watching!

@aaronmpofu9145 11 ай бұрын

Excel course is too expensive bro. $ 149.95 is like R 3,000 in South Africa. I really need to do it thou 😭😭 Time to save

@familyFood786 10 ай бұрын

In India it's almost 12000😢😢😢

@aditya3david 10 ай бұрын

KZfaq, udemy free courses to start

@neptoonpalace4027 10 ай бұрын

Coursera has great excel course...and you can audit it for free

@Steak_MediumRare-ro3db 8 ай бұрын

@@BleuJasper-rb9ei he's being funny 😂😂😂😂

@TevinC814 7 ай бұрын

Kyle pew full course is free on a website online

@tambahsaah8005 11 ай бұрын

I bookmark ome of your videos for reference in my personal library and this one definitely going in 😂! Thanks so much Kenji! Will best going up for your Power Bi class soon

@KenjiExplains 11 ай бұрын

Thats great to hear Tambah, thanks for supporting!

@user-zf8jp5hs4p 10 ай бұрын

Hi, could you please make an Inventory for 26 items with 3 salesman with shop record means shop name and sales items , opening and closing balance with auto update on daily basis data entry??? Thanks Love and Respect from Pakistan

@fatimazaim503 7 ай бұрын

hi thanks for this video but i cant seem to do the replace part.

@mixeddrinks8100 11 ай бұрын

they need a new shortcut for PASTE VALUE... I use it so often but hard to put that as a macro in the mouse hotkey or a macro in the keyboard. Only way I found is add the button to the ribbon on top, it does help make it slightly faster

@dantherman4202 11 ай бұрын

I usually do ctrl+V, then ctrl, down, down and hit select. feels faster to me, though maybe that's just because I've done it for so long that I don't even think about it.

@preeteshramdas3651 11 ай бұрын

Try control C to copy then when pasting, right click and press V on your keyboard..

@martinescalante2708 3 ай бұрын

Question: Why did the "remove duplicates" function didn't remove the David Rasmussen row, which is also repeated? I had to use Conditional Formatting to find out about it. I'm not judging I'm just truely curious to know about it.