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.
Download Row Dataset : bit.ly/3YPESPW
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
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 ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
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

[@DeepakEduWorld]

Dosto kaisa laga ye video 😊

[@GiGiTales2293]

Super sir

[@nishanth4323]

Bhai ji aap gajab ho..🫂👏👏

[@madhusudandas2953]

Bht badhiya sir ji

[@mrutyunjayasatapathi4567]

Sir mujhe bataye please me kis app se mobile me Excel ki sari tap ke sath practice kar seknu

[@rajnipandey9901]

Bhut hi badhiya sir gajab

[@kiranmody4472]

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

[@mrinalmondal1890]

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

[@anupsarkar8886]

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

[@tapashinaskar7444]

Thank you. Very helpful video.

[@manjit.sarania]

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

[@shivamsinha5394]

Thankyou sir 🙏 awesome explained 🌸

[@deepakbaghel9674]

Very helpful video thanks 🙏

[@tarakpopat2150]

Very Good facilitator...

[@niteshjaiswal2754]

You are Best teacher ❤️ love you ❤️

[@AnujKumar-bs6vb]

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

[@Alli21]

U deserve 10M ASAP! 🙌

[@ehtishamali9090]

I am from Pakistan Your videos are Brilliant.

[@kishangogna7295]

Excellent

[@abdulafshan12]

Yes we can't use filters for blank rowa

[@AmanKhan-sf5uz]

REALLY Thankss!

[@sarazain5287]

AMAIZING

[@sitalguchait3102]

Excellent Deepak ji.

[@hiteshvashisth3515]

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.

[@sureshram6907]

Bahut achha lga ye video bhi sir ji

[@gopalyadav1718]

very nice and wonderful

[@sadiqahmed814]

Sir its extremely wonderful great information love from Karachi Pakistan

[@poembydeveshdixit6798]

Amazing ❤❤❤❤❤

[@ramnaslai2980]

Great video and tricks👌

[@MohammedSafwan29]

Amazing 🔥🔥🔥🔥

[@ghulamnabi3385]

Excellent video brother

[@pstjsthstibantsptsmostrepe9515]

Mashallah bhai apki video zabardast hoti hean very helpful.

[@nishantyadav6151]

Good information, thanks ❤

[@todayscomputerworld5049]

Thank you very much sir

[@aparnamallick1240]

Thank u Sir 💐

[@bhaveshparmar431]

Amazing sirji

[@AftabAhmed-uw4ki]

Sir aap ki each every video mast hoti hn❤

[@vshal3880]

Thanks Man. 😉

[@khiladichunky3673]

Excellent Deepak sir❤️

[@Ajeetkumarkushwaha1]

Thank you bhaiya जय हिन्द

[@mohammadafroz8786]

Zabaradast bhai

[@parulbhaiya5158]

Very useful video

[@akashhela8521]

Thanks you sir. ❤❤

[@JAVEADKHAN]

very nice bhai

[@laxmanrajoriya825]

i like video like this , thanks so much sir..

[@firdoshahmed6330]

Thanks guruji

[@aashishsharma3212]

Thanks Sir

[@rameshwernagar1599]

मजा आ गया दीपक भाई साहब

[@kiranmody4472]

Thanks

[@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

[@ilyasmwt4804]

Maan gaye bhai, and topppic

[@radhekrsna007]

U r champion

[@ngpandit2660]

Very nice.....

[@vaghelajayendra]

Nice one

[@ajayshivpuje3797]

Very nice brother ❤

[@hafiztahir9760]

Sir ap bhut acha samjatay ho

[@SKSethia-cs4zc]

Great

[@sadashivkage3133]

TQ....

[@hafizurrahman9081]

Very nice

[@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

[@mohankathe3332]

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

[@sumitkumarbhandari6729]

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

[@Interestingboy642]

Very good video

[@bijaytanty8434]

Good 👍

[@subramaniyam176]

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

[@ROSHANKUMAR-cw3lc]

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

[@mientertainment1086]

Guru love you from Pakistan

[@syedikramullah1114]

Nice

[@laxmipolymers2986]

Super

[@mdasgaransari295]

waoo nice videos sir

[@Elecnovate]

blank option not showing

[@arunkumarsinghark3024]

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

[@gautamsoni8137]

Bhaiya aap please google sheets ke bhi video banayee naa

[@osamakhan4275]

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

[@ketannaliyapara2021]

Dear sir Actually I required one FIFO base Excel sheet for shares dealing in which I can able to find the profit in the basis of FIFO and LIFO. Also wants to know stock prices as per FiFO and LIFO

[@AftabAhmed-uw4ki]

Sir first viewrs ho asi video ka

[@user-kb2hr5im3k]

plz Power query ke vidos bnain.

[@CYLONE-zo2kb]

sir apka konsa excel version he

[@Vikal_Gupta]

use wrap text for address conversion from 2 to 1 line

[@geetasachdeva7620]

Sir in step 6 you have shown us some blank cells but if - this symbol is already there in cell then also we need to put NA in that cell?

[@AftabAhmed-uw4ki]

Sir plz power query ka full tutorial bano plz plz plz🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🇵🇰🙏🙏🙏🙏🙏🙏🙏🙏

[@Prasant-Rathod]

Sir ye jo line break remove trick hai ye purane Excel mein nahi kaam krte hai kya?

[@ghanshyamahuja1829]

Hi deepka power bi ka tutorial kijiye

[@sifathasan4465]

when I try to replace something it shows that it is a protected sheets. What should I do?

[@Bewafa_5961]

Mujhe laga isme yhoda alag hoga..but is vedio me kuch bhi aisa nhi jo mujhe nhi aata ho🥺thank you batane ke liye ki jyada sochna shi nhi

[@khiladichunky3673]

Sir freelancer par kaam krne k liye kuchh special btaiye jisse main kuchh earn kar sku

[@Entertainment10391]

Sir mujhy medicen Distribution k liye excel software banana Hai invocice warranty non warranty so ik video bna dein

[@meherrizwan1254]

step 3 not workig after much attempts? what can be reasons

[@abhishekchaudhary7009]

Sir, ( 3:34 ) blanks option is not present in my excel

[@muhammadtalha3163]

Sir ap excel ka knsa version use kre h

[@ranubond702]

brother ek video Puri sheet ko print ke liye page par kese set kare us me kafi shamshya aati he uske liye please ek video bnado bhai🙏🏻

[@nitinyeole1769]

Sir you have any ai tool for cleaning data please make video on it or suggest to me 😊

[@Sagar-nm7oq]

Hi sir when i want to delete the blank rows, it doesn't show the blank in the filter section. Please help

[@shahmuhammad7401]

same

[@NikhilSingh-tk5hx]

Same

[@khushi4717]

Bhaiya data clean baad kya mid point histogram create karne ke liye please reply today my exam

[@pogofreak8322]

Sir apne jo file di h vo video wali file se alg h ... isem errors hain ... aise kaise chalega sir

[@prashanthlastplayer3860]

Sir I am job less and I don't have income can please share the more tips for the data cleaning that will help to me sir 😊😊😊😊😊😊😊😊😊😊

[@taajeducationielts]

✅✅✅✅

[@mohd.faisal4139]

Link kaha hai bhai

[@user-hk2ro2wr2x]

Link kidr h sir.. kaha se data download kare

[@1gevaypakistan]

Assalam O Alikum dear sir Sir excel ma Add Ins commsnd k andar uneanted remove charcacter command hy wo active ni hora mtlb okay ka option ni aara or ya b define kran ya command excel k kis version ma work kray ga excel install say use command tak all process. Shukria

[@1gevaypakistan]

UnWanted remove Specisl charcters

[@muhammadharis6930]

Hello sir mere pass filter krne k bad blank show nh horaha or first 5 rows show horahi hn

[@SagarKumar-nh3no]

Add a new column and apply the function COUNTA. It will add the records and then you can delete the values with 0 zero records.

[@usmanjavaid9842]

Ctrl j is not responding.

[@iqbalsheikh5027]

Your Crtl +J functions is not doing anything, as it is done in your project file. Can you please check and let

[@iqbalsheikh5027]

Will you help me where I am making mistake

[@usmanjavaid9842]

Ctrl j is not working

[@skillyt04]

Blank option not showing 😢😢

[@jigneshrevankar]

Click on the cell located to the left of column A and above row 1 is called the "Select All" button or "Select All" cell. Now Click Ctrl + Shift + L And click on down arrow and now search 🔍 (blanks) It's working 💯

[@doubleDeeD]

Same

[@monudahiya5841]

Sir 14 * 12 ek hi cell mein multiply kaise kare

[@monudahiya5841]

Reply plz