Top 10 Ways to Clean Data in Excel Easily !

In this tutorial you'll learn Top 10 Ways to Clean Data in Excel Easily using excel tricks and formulas, every excel user must know theses 10 data cleaning tricks in microsoft Excel. We'll go from having a raw dataset that has several errors and convert it into a cleaned excel file, For this, you'll learn some amazing excel tricks such as fill blanks text to columns and remove duplicates, and several formulas such as the trim, proper, lower, upper and iferror and you can also download row dataset from download link given below.

My Channels :

00:00 Intro
00:41 Quickly Autofit Rows and Columns
01:25 Formatting Long Values
02:09 Remove Multiple Like breaks
03:01 Remove Blank Rows
03:55 Text to Column
05:19 Fill Blanks
06:02 Lower, Upper, Proper Formula
07:31 Fill Blanks With multiple Values
08:32 Magical Trim Formula
09:34 Remove Errors Using Iferror Formula
10:31 Remove Duplicate

Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.

Deepak EduWorld Playlist's:

POWERPOINT COURSE ►

ADVANCED EXCEL ►

ADVANCED EXCEL FORMULAS ►

EXCEL TIPS & TRICKS ►

MS WORD ►

HTML5 & CSS3 ►

COMPUTER TECHNICAL videos ►

AUTOMATIC INVOICE IN EXCEL ►

PHOTOSHOP TUTORIALS ►

Thanks for Watching
Deepak EduWorld

Related Searches : how to clean data in excel,data cleaning in excel,excel,how to clean up raw data in excel,clean data in excel,excel tips and tricks,microsoft excel,excel tutorial,how to clean raw data in excel,data cleansing in excel,learn excel,excel tricks,top data cleaning tricks in excel,how to do data cleansing in excel,cleaning data in excel,clean raw data in excel,excel for analysts,cleaning up raw data in excel,excel data cleaning,excel tips

[Rex-Solis]

Those who are facing blank option problem
Select Whole range of data using ctrl + A then press ctrl + T and enter
Then you will find the blank option

[kiranmody]

You are too good, the way you explain is so simple and easy to understand.

[mrinalmondal]

Thank you so much ki aap practice file dete hain....many people don't realise the value of practice

[nimaiskr]

Sir Video thi ekdom wo wala matlab Itna achha laga main Excel ka kaam nehi janta hoon but av aysa lag raha hai ki main mahir ho giya
Bye the way kafi help hua mere daily life main thoda bohot use kar leta hoon to ab bohot asan ho giya

[hiteshvashisth]

Great work done by you Deepak Bhai.. keep it up.. you will be a great man one day. A great successor. Because u providing real knowledge without any heavy fees.

[ROSHANKUMAR-cwlc]

Great work done by you Deepak Bhai.. keep it up.. you will be a great man one day. A great successor. Because u providing real knowledge without any heavy fees.

1


Reply

[manjit.sarania]

Very helpful and good teaching sir..🙏🙏🙏..plz make video on power query and power BI.

[anupsarkar]

बहुत बढ़िया वीडियो. बहुत उपयोगी। आपका बहुत-बहुत धन्यवाद।

[ehtishamali]

I am from Pakistan Your videos are Brilliant.

[mohankathe]

The link data is mismatched to your data the one in the video. Please check.

[AftabAhmed-uwki]

Sir aap ki each every video mast hoti hn❤

[sadiqahmed]

Sir its extremely wonderful great information love from Karachi Pakistan

[sumitkumarbhandari]

Bina dekhe, Mai bolta hnu sir apka video achha hai.

[subramaniyam]

Excellent sir, most usefull videos, sir kindly give Excel practice set link, I can't get link from ur discriptin box kindly guide me

[moumitamaity]

Sir Up bohot ache shikhate ho ehi sob shikhaneke liye mera 3000 ek Youtuber ne cute liye

[pstjsthstibantsptsmostrepe]

Mashallah bhai apki video zabardast hoti hean very helpful.

[AnujKumar-bsvb]

Thank you Sir for explanation clearly and it's video is very important and helpful for me.

[arunkumarsinghark]

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤
🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

[abdulafshan]

Yes we can't use filters for blank rowa

[osamakhan]

Bhai Jan ap aik Full Excel Tutorial Banaye
Only For Accountant Job
(How To Maintain Business Record In Excel From Basic To Advance Level) Please