Data Cleaning in Excel - 10 Tricks (Beginner to PRO)

You are my plug when it comes to Excel....... Thanks💖

My fears of excel is vanishing, Thanks to you!!!

Thank you chief!

The best.

your way of teaching is awsome sir, i like this this video

This was amazing!

I am really thankful to all the tutorials you have. It saves me a ton of time and work. Keep it up🤟🤟🤟

What a professional teaching style. Really useful tutorial. Subscribed.

Chandoo - you are such a lovely man. Your videos are so clear and your teaching style is perfect! I, (a 75 year old grandmother retiree from the Uk), am teaching myself Excel and your videos are just superb!

You´re the best my friend, when i going to wacth a video with a powerfull tips you´re first option for ever.

Why my trim funstion is not working ?

I like your editing video 👍

Chandoo bhai ki Jai🫡

CAN WE DESIGN OWN FUNCTION FOR DATA CLEANING ?

finished watching nd practicing

New learning again..... Thanks..

Your Excel capabilities are out of this world. I'm glued to this channel.

Excellent tutorial.

thanks you, i am poor and i had to practice with google sheets and i had to figure things out but it is equally fun to follow, thanks!

❤

The best and easy to understand video on Excel.

Thank u sir great video

excellent.

Hi Chandoo, It was a great video as usual, thanks for teaching us in a simpler method where everyone can understand. I also found a mistake while cleaning the data by copy pasting the new values, so it shows the column gender where we changed null value to other but it shows zero in your video. Can you please look into the video again and explain why it is showing zero again instead of other. Thank you 😊

Explained Wonderfully! Thank you

The flash option is not working I will check also an option -advance is not showing

Thank you

Which version of the MS office is used here.?

Thanks Chandoo!

Hi Chandoo, I just started seeing your videos and you are awesome. Thanks. What version is your excel please? Cause my doesn't have some of the function....

sir if you allow us to download raw file to practice it will be vey very good for us to learn.

Many many thanks to you for this nice video on data cleaning.

I am becoming an Excel Pro with Chandoo!

Power Query is a must have/know tool.

In my Darkest hour it wasn't Batman ... It wasn't God or the universes creator ... It was Chandoo who saved me

Excellent...thanks from DATA is FuturRe hindi channel Dedicated to Data Science

Hi Sir, im your student im using MS Excel 2016 in which "from within sheet" command does not present, plz help me where is the problem, Thanks in advance

Thanks Chandoo.

I try step by step, following your instruction. But when i try on power Querry, after split columns of ID. The number ID is not the same especially when the number begin with zero. The zero number is dissapear. Could you explain why? or there is a settings for those columns should be done first before split the columns.

Sir , My flash fill option isn't working . I have pressed ctrl+e , double clicked the value . but my flash fill isn't working ? I am using ms Excel 2016

Chando one small doubt, as flash fill dont update automatically, if we convert the range in to table (including flashfill coloumn), is it update automatically...

Chando one small doubt, as flash fill dont till automatically, if we convert the range in to table (including flashfill coloumn), is it update automatically....

Thank you so very much

Very useful 👍 vedio

Thank you for sharing nice vedio

Thanks, Chandooooo! You are brilliant

You are so Awesome thanks Chandoo for imparting these tricks to us... More power to your channel...

Amazing

After adding new data and clicking "Refresh" I have noticed that at least one "0" got into Gender column. Maybe it's because it was neither Male nor Female but 0 that's why it wasn't substituted for Other.

you are great in excel + your sense of humour amkes it more interesting....i call you BOSS of excel