Advanced Excel Data Cleaning Tricks ONLY Experts Know

[@KenjiExplains]

👉 Take our Data Analyst Program: www.careerprinciples.com/career-track/the-data-analyst-program

[@shoboyjr]

Thanks a lot for the video! I really like the Aggregate Functions and Fuzzy Matching feature.

[@faizasultana2476]

I am loving his excel course. Great video Kenji!

[@KenjiExplains]

That's awesome thank you!

[@RakshitDwivedi-pq8qc]

Fuzzy Lookup is brilliant. Somehow i always get to learn something new from your videos. Btw still waiting for SQL part 3. That series helped me get invested in learning SQL.

[@jahbuikemanderson8109]

Much love Mr Kenji. Akways bell-on for your videos ❤

[@extraktAI]

I feel like I've been seeing excel even in my dreams lately 😅 thanks a lot Kenji, this was great!

[@Dan_Jun_10]

your videos are very helpful. I always learn couple of new tips from your videos even though I've been using Excel for a while. Thank you

[@rumeeburu3648]

Thank you Kenji. I’ll try this after lunch hehe!!!

[@KenjiExplains]

Awesome thanks for watching :)

[@josephbaba111]

Kenji, you are the best!!

[@HpVictus-dz7nt]

Brother Could you provide some Excel videos that are useful for supply chain management and operations roles? Please make a video on this topic. ❤❤❤❤❤

[@shafquatnawaz9544]

Same I need

[@EkiDevaFradhani]

up thisss!!!! 😂

[@Safe_n_Him]

Yessss, Pleasssse!! I work in supply chain and this would be so amazing ❤

[@angeloluz5056]

Fuzzy Lookup is a very useful tool in data cleaning. Could you do a separate in-depth tutorial with various samples. Thanks.

[@SandyLee1]

Kenji, there’s an error in the Datedif results at 9:01 mins in. The Charles Koch age should be 89. I’ve suffered the same error before using the Datedif function and therefore rarely use it. Appreciate the other tips though. Keep up the good work!

[@mohammadalbizri2013]

Thank you Kenji

[@sallyho146]

Liked. In data cleaning, can I use power query to combine last name first name? The total column to separate debit and credit for positive and negative? Can we use power query to match two files? Regarding Aggregate, how to fix if the total don’t add the new row amount?

[@Personal-4all]

Very Helpful..

[@alisashko21]

is it possible to apply fuzzy matching and merging based on multiple columns? i am reconciling trades based on vba checking each cell but due to typos, it is really easy to missmtach. therefore fuzzy matching could be a great way to solve this issue.

[@AbdulRahman-yp6oy]

very good please make a separate video on advance Power Query

[@KenjiExplains]

I'll keep your suggestion in mind :)

[@AbdulRahman-yp6oy]

@@KenjiExplains thanks 👍

[@siphomnyakeni2952]

Greetings. Great content as always. Do you have Data Analystics course in linkedin Learning?

[@KenjiExplains]

Thank you! We don't have courses on linkedin. All our courses can be found here: www.careerprinciples.com/all-courses

[@JoseCarlo-u4g]

hello sir kenji i would like to ask if do you have a month by month comparison like (last month VS this month? im doing a progress report hope you can help and i appreciate it

[@camlex6310]

Neat tricks!!

[@KenjiExplains]

Thank you!

[@nasflix_2.0]

On Microsoft word a function called sentence case, it helps to the data typing, but not default in Excel. So each time Capslock on and off after and before, hope you can fix my problem.

[@saurabh-zg7qc]

Hi kenji please upload this Sunday's video, eagerly waiting 😂

[@muhammadridhwan1075]

nice

[@sufimudi4524]

How you add duration using powerquery?

[@AhmedMohamed-xt5rn]

Hello, I would like to contact you privately regarding practical training in data analysis..

[@preetshah3793]

hello sir how enable data type option in excel 2021

[@pen.X.Spinner]

You have provided us various videos on excel But if it was in order then it will be of great help I am a finance Student and want to learn to do analysis through excel So can you make a video a short video in which you will only tell about the order in which we have to learn all this through your videos Like first starting with this topic and you can see my this video for this and then next step From beginner to advanced or starting to end. When we learn in a systematic way we learn it more efficiently.

[@lakkudawargave]

Kenji ur amazing ❤😁

[@KenjiExplains]

Thank you :)

[@AbdulRahman-yp6oy]

Sir why are you not dulpaded yours yesterday video ????

[@KenjiExplains]

Back next week thanks for asking:) Just took some time off

[@AbdulRahman-yp6oy]

@@KenjiExplains I eagerly wait for your videos. And I want to get classes from you , but I don't have enough money 😔

[@rockstarstudio2]

I can't seem to download the free excel file for this video ☹😢

[@KenjiExplains]

just checked seems to be working correctly, please check your email inbox :)

[@rockstarstudio2]

@@KenjiExplains Just did but i didn't recieve any mail

[@willzinner8813]

is fuzzy lookup new?

[@KenjiExplains]

it's been around for a good few years!

[@HpVictus-dz7nt]

Pls brother provide 4k resolution pls pls...

[@KenjiExplains]

Hey thanks for the suggestion. Are there things you struggle to see in 1080 HD? Seems decent with my 27inc screen but let me know!

[@HpVictus-dz7nt]

Because this is educational content, if you provide it in 4K resolution, I think it will be very helpful for everyone. Please consider my suggestion.

[@prakashabhijeet]

3:42 ,didn't get it

[@KarenTheComedian]

I thought Fuzzy match was when i had to much to drink at lunch.

[@KenjiExplains]

😂