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

Dirty data on your mind?
Just spray the amazing "data cleaner" on it.
In this video, learn how you can use 5 Excel features to clean data with 10 examples.

You will learn about:
1) Flash Fill
2) Text to Columns
3) Remove Duplicates
4) Formulas
5) Power Query

Video Topics ⏱👇
===============
0:00 - Data Clean-up - the challenge
1:17 - Extracting the first name (Flash Fill)
2:10 - Get the city from location (Flash Fill)
3:12 - Get the city from location (Text to Columns)
4:20 - Splitting cost centre & ID number (Text to Columns)
5:35 - Duplicate Valvalues (Remove Duplicates)
6:33 - But there is a problem!!!
7:16 - Remove extra spaces from name (Formulas)
8:01 - Full time or Part time (Formulas)
8:49 - Power Query!!!
10:04 - Splitting Cost Centre & ID with Power Query
10:57 - Fixing inconsistent dates with Power Query
11:40 - Adding a Full / Part column with Power Query
12:30 - Bonus Example - Fixing or Removing incomplete data
13:50 - Loading Cleaned up data to Excel & Data Updates (Refresh)

Download the sample file 🟩
=======================
Here is a blank data file. Use it to practice these data clean-up tasks:

Watch next 💻👍
==============

~

#Excel #powerquery

May your data be clean and your days be serene 😀

[lynnajema]

You are my plug when it comes to Thanks💖

[oseikwamejones]

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

[shreyanshdangi]

Your starting with lines of S.T. Coleridge inspires me more for becoming DATA ANALYST!!! Thamnkss

[anandk]

Our journey of data analysis with Excel in your hand.
We saw you really active from past six months.
Thank you for your dedication and hard work by heart.
Please don't let down us with basic to advance of Excel or any shortcut tips.
It is your responsibility to teach us everything in practical way.
And again thank you very much.

[Manjumannavlog]

Most sensible and Experienced data analyst ever seen in Youtube

[Azhar_Khan]

Your videos are like a gem to me every time I look to get updated about my skills. Awesome & amazing techniques. Thanks

[tinajefferies]

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!

[shubhamkumarram]

You are providing an excellent content Please Keep it up. I started learning Excel and Found it as a most powerful software which we used to ignore in our school days

[benjcheah]

Chandoo...Thank God I found you!!! This is the first time I actually understand Excel in the first 5 minutes and not tempted to watch Kdrama or Netflix. Anyone wanting to learn Excel quickly and not fall asleep..this guy your man ^^. Cheers mate! P.S, Do you have a video for those of us using Excel on Macs or just add in your vids short cuts for Macs if there are any. TQ

[gauravchheda]

You are awesome! Complex concepts explained with simplicity and loads of examples. Kudos.

[prathmesh_jadhav]

It is always amazing to watch your videos… you give accurate, on point and no nonsense information… Thank you Chandoo sir

[gauranshbhutani]

Gem of a so peaceful lectures...a big thank you

[pro]

Your video is very helpful bro.
I gained plenty of knowledge in Excel by your videos.

[priyaranjanbiswas]

The best and easy to understand video on Excel.

[yaswanthtirupathi]

Enjoying like a movie🤩🤩, impressed the way of your explanation. Thank you so much for sharing knowledge sir..🙏🙏

[shriramkulkarni]

Sir
I have completed 71 years of my age. I am interested in learning something related to IT. Pl guide me what I should learn at the beginning.
Thank you
Kulkarni

[julsofthesand]

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

[talkinghat]

Loving the insightful way you explain the data cleaning feature.

[mahanaiminternationalminis]

Wow! what a wonderful way to teach the data cleaning in Excel. Thank U Sir.

[make-n-mend-Anglesey]

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