Master Data Cleaning Essentials on Excel in Just 10 Minutes

[@KenjiExplains]

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

[@sabisabss1507]

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]

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

[@shivanandsoodi8854]

Sir pls tell me how download data u pinned

[@themajestyjoshua]

​@@abdulsalambamidele5389visit kaggle

[@muhammadlimanmahdi3934]

hi

[@dakesim]

=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]

Indeed!!

[@TheShadowgaming01]

Yes for sure

[@momjee01]

Yes 😊

[@shabbirhussain8429]

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

[@j_orpz]

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

[@dineshgohil2808]

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!

[@sharfaraazs9367]

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

[@neelakandank6195]

Unexpected

[@searchbug]

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]

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 ?

[@dccd673]

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

[@dhrumilpatel98]

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

[@stresslaxing.]

Welcome back KEnji. Helpful tutorial. Thanks!

[@KenjiExplains]

Thank you for supporting!

[@Dxrkwolf1]

wow this guy is super amazing am so happy i understand data cleaning now thanks

[@lieveren]

I learned so much in 10 mins. Thank you!

[@alicekuria9398]

This is very enlightening☺ Thank you Kenji, I've learnt alot🥳

[@KelvinMiano-yu9fn]

When i watch your videos i always learn something knew, your tutorials are always educative thank you🤗

[@kamilzbrog3858]

What an absolute masterpiece! I was searching for such a course like this. Great job, thank you for this :)

[@mayzinhan-i1b]

Thank You, Sir. It's the first time for me watching your Excel Tutorial Video. This's very useful not only for me but also others. So, I really to say "Thank You".

[@hashimqotaje5886]

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

[@mycophil]

This is pure awesomeness. Thank you!

[@akontia6]

These videos are amazing. Please keep it up!

[@ganiyulovesdata]

SUCH A GREAT VIDEO! THE ALGOROTHM BLESSED ME

[@victorbegnini5754]

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]

Thank you Victor! Glad you like them

[@ldmlhome]

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!

[@thaivang8726]

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

[@KenjiExplains]

Glad it was helpful!

[@knux5796]

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

[@willzinner8813]

youre back sir keep going

[@KenjiExplains]

Thank you, I will

[@atinOO7]

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

[@Prevailinzion]

You are straight to the point I love this

[@olajideadeboyejo171]

Short video with a very good insight in data cleaning

[@suleimanmuhammedhady1198]

You made everything look very easy. I am following you definitely

[@juachgarang3977]

I am so impressed. Learned about text to color,

[@ibrahimasylla7256]

You are the best Kenji !

[@tanjinasuchi6609]

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

[@Gambit889]

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

[@marivicagner6123]

Thank you very much! I learned a lot. God bless you.

[@jocyglindecamotan]

Your new subscriber here was amazed at how you taught us to navigate Excel.

[@newme7766]

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

[@mohdabdulmateen5159]

Hey Kenji bro ! Greatly appreciated this video as I’ve got to know these tricks, and the way you explain it feels to learn more.❤❤❤❤❤❤❤❤

[@hoanganhnguyen8206]

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

[@mohamedfarah7762]

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

[@shemustnotbenamed]

Very helpful! Thanks, Kenji☺️

[@musamaiza6259]

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

[@antoninpoint-cd9fy]

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 =)

[@The_Spontaneous_Adventurer]

This lesson was very insightful. Thank you

[@k.dailey2379]

You're Teaching Skills Are Awesome And Your Very Descriptive...This Video Is Greatly Appreciated 👏 👏👏👏👏

[@maryc5637]

I love your teachings, thank you so much

[@shukanyakhan3991]

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!

[@benjaminrawson3386]

I followed along with each step perfectly as a beginner. Now, to learn these by heart and have someone employ me for what I'm sure is a pretty basic skill.

[@心中满是欢喜]

start my Excel trip from here. Thank u

[@JayeshDeshmukh_96]

Superb explaination man😊 it is very helpful ,THANK YOU !

[@franksterkb891]

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

[@mowburnt]

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]

And Proper… awesome

[@mowburnt]

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

[@KenjiExplains]

Glad it was helpful :)

[@xCharjx]

Thanks this was a fun exercise!!

[@rehansiddique1875]

Very great tutorial, learned a lot

[@BB-pv6cf]

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

[@saravanansomasundaram4598]

Happy to see Indian Tamil actor T Rajendar face @ 3:45 😊

[@kartikeyasingh433]

We Indian never focus on things what is beneficial for them 😂

[@Ravikanth.Asokan]

Great help Sir. Thank you.

[@ernunal]

It was a really instructive and neat video. 🎉

[@dkwizera]

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

[@efledasongalia1375]

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

[@Vishnuu007]

You can also use power query for cleaning data like to just select information and go to data then select from table range

[@fakeitsoyoumakeit]

brilliant man keep on!!!

[@dommanedounia4917]

THANK UUU !! This is AWESOME !!

[@Aphelele_N]

For the second client column, you can also use the proper formula. It will capitalize on the first letter and lowercase the rest. Thank you for this video 🙏

[@syedimraan5091]

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

[@oluwaseyikukoyi1967]

You are awesome.

[@m47kr3nt0n]

The first itch I got from your example sheet is to ctrl+a and alt+HOI everything.

[@ciaraarmy9374]

It's so useful and thanks to give us exel file

[@lilllyharris8110]

This video demonstrates a 10-step process to clean and format raw data in Excel, including resizing columns, removing unnecessary information, and applying formatting to improve readability. Key moments: 00:00 Learn how to clean raw data in Excel in 10 steps, including formatting columns, removing unnecessary text, and standardizing data for better readability and analysis. -Formatting columns by adjusting width for better visibility and readability. -Removing unnecessary text like parentheses from data entries to clean up the dataset. -Standardizing data by converting text to lowercase and cleaning up spacing and capitalization for consistency. 05:09 The video covers practical case studies alongside theoretical lessons, offering courses on various topics like Power BI, VBA, and macros. It demonstrates data cleaning, formatting, and visualization techniques using Excel functions and formulas. -The video showcases how to separate data into different columns using text-to-columns feature in Excel, enhancing data organization and clarity. -It explains the process of identifying and removing duplicate values in a dataset efficiently using Excel's 'remove duplicates' feature, ensuring data accuracy. -The tutorial demonstrates how to handle blank cells in a dataset by replacing them with 'N/A' using Excel functions, improving data consistency and analysis. Generated by sider.ai

[@Roseformyself]

Thank you for sharing. I like your tutorials.

[@princedestinyugo5514]

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

[@KenjiExplains]

Glad you like it!

[@princedestinyugo5514]

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👍!

[@starboi_6]

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

[@jonathanwambua6477]

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

[@KenjiExplains]

Great to hear that! Thanks for watching!

[@raymondasamoah3895]

Great job. You got it. awesome job.

[@hattersimble-hy2bj]

King of shortcuts

[@camlex6310]

Great tutorial!! Cheers

[@KenjiExplains]

Glad you liked it!

[@Saufii]

Thank you so much for sharing!

[@Aamir_Updates]

It helped me alot while cleansing abig data Excel spreadsheet.

[@himawarisunflower87]

Save to watch later. Let me try it tmr morning at work😂 thanks

[@Phamousman]

Great video, and very easy steps to follow

[@DATOSPRO22]

This is great video for learn new things or skills congrats 😮

[@manal2271986]

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

[@JerryDeLay-f6d]

You are really good, thank you.

[@Ayesha_01257]

Keep up the Good Work🤩

[@kirangurung3108]

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

[@SunilYadav-jq8sf]

Thank you so much for this video, I really like it. method.

[@AdamArzemy]

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

[@AbdiwassahAbshir-t9g]

Thank for every thing 🎉

[@jasonwamp4325]

Thanks bro. Too good.

[@niyasrahmannr716]

Well done brother.❤

[@vikramadityarathore97]

Great stuff kenji .

[@KenjiExplains]

Thanks for watching!

[@sharonvoosa8160]

Thank you!

[@Wissou_]

Thak you so much for this interesting video

[@niharickakaul741]

this is so good...thanks

[@Coach-rq6jx]

Appreciate it, brother.

[@abdullahmiazi6666]

this is a beautiful video

[@je2740]

Nice job. 🎉

[@arifzargar8624]

Extraordinary!!!

[@amoprince4353]

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

[@KenjiExplains]

Thanks for watching!

[@Leghar]

I'd like to add CTRL + SHIFT + V does the same as ALT H V V

[@mulukendesalegn-v7k]

what a fantastic keep going, thank you too much.