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

Пікірлер: 163

  • @DeepakEduWorld
    @DeepakEduWorld10 ай бұрын

    Dosto kaisa laga ye video 😊

  • @GiGiTales2293

    @GiGiTales2293

    10 ай бұрын

    Super sir

  • @nishanth4323

    @nishanth4323

    10 ай бұрын

    Bhai ji aap gajab ho..🫂👏👏

  • @madhusudandas2953

    @madhusudandas2953

    10 ай бұрын

    Bht badhiya sir ji

  • @mrutyunjayasatapathi4567

    @mrutyunjayasatapathi4567

    10 ай бұрын

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

  • @rajnipandey9901

    @rajnipandey9901

    9 ай бұрын

    Bhut hi badhiya sir gajab

  • @kiranmody4472
    @kiranmody447219 күн бұрын

    Thanks

  • @kiranmody4472
    @kiranmody447219 күн бұрын

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

  • @mrinalmondal1890
    @mrinalmondal189010 ай бұрын

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

  • @anupsarkar8886
    @anupsarkar88869 ай бұрын

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

  • @tapashinaskar7444
    @tapashinaskar744410 ай бұрын

    Thank you. Very helpful video.

  • @manjit.sarania
    @manjit.sarania10 ай бұрын

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

  • @shivamsinha5394
    @shivamsinha53949 ай бұрын

    Thankyou sir 🙏 awesome explained 🌸

  • @deepakbaghel9674
    @deepakbaghel967410 ай бұрын

    Very helpful video thanks 🙏

  • @tarakpopat2150
    @tarakpopat215010 ай бұрын

    Very Good facilitator...

  • @niteshjaiswal2754
    @niteshjaiswal275410 ай бұрын

    You are Best teacher ❤️ love you ❤️

  • @AnujKumar-bs6vb
    @AnujKumar-bs6vb5 ай бұрын

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

  • @Alli21
    @Alli219 ай бұрын

    U deserve 10M ASAP! 🙌

  • @ehtishamali9090
    @ehtishamali90908 ай бұрын

    I am from Pakistan Your videos are Brilliant.

  • @kishangogna7295
    @kishangogna72952 ай бұрын

    Excellent

  • @abdulafshan12
    @abdulafshan1224 күн бұрын

    Yes we can't use filters for blank rowa

  • @AmanKhan-sf5uz
    @AmanKhan-sf5uz7 ай бұрын

    REALLY Thankss!

  • @sarazain5287
    @sarazain52879 ай бұрын

    AMAIZING

  • @sitalguchait3102
    @sitalguchait31029 ай бұрын

    Excellent Deepak ji.

  • @hiteshvashisth3515
    @hiteshvashisth35152 ай бұрын

    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
    @sureshram69074 ай бұрын

    Bahut achha lga ye video bhi sir ji

  • @gopalyadav1718
    @gopalyadav171810 ай бұрын

    very nice and wonderful

  • @sadiqahmed814
    @sadiqahmed81410 ай бұрын

    Sir its extremely wonderful great information love from Karachi Pakistan

  • @poembydeveshdixit6798
    @poembydeveshdixit67989 ай бұрын

    Amazing ❤❤❤❤❤

  • @ramnaslai2980
    @ramnaslai298010 ай бұрын

    Great video and tricks👌

  • @MohammedSafwan29
    @MohammedSafwan299 ай бұрын

    Amazing 🔥🔥🔥🔥

  • @ghulamnabi3385
    @ghulamnabi33859 ай бұрын

    Excellent video brother

  • @pstjsthstibantsptsmostrepe9515
    @pstjsthstibantsptsmostrepe95154 ай бұрын

    Mashallah bhai apki video zabardast hoti hean very helpful.

  • @nishantyadav6151
    @nishantyadav61513 ай бұрын

    Good information, thanks ❤

  • @todayscomputerworld5049
    @todayscomputerworld50498 ай бұрын

    Thank you very much sir

  • @aparnamallick1240
    @aparnamallick12409 ай бұрын

    Thank u Sir 💐

  • @bhaveshparmar431
    @bhaveshparmar43110 ай бұрын

    Amazing sirji

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki10 ай бұрын

    Sir aap ki each every video mast hoti hn❤

  • @vshal3880
    @vshal38803 ай бұрын

    Thanks Man. 😉

  • @khiladichunky3673
    @khiladichunky3673Ай бұрын

    Excellent Deepak sir❤️

  • @Ajeetkumarkushwaha1
    @Ajeetkumarkushwaha110 ай бұрын

    Thank you bhaiya जय हिन्द

  • @mohammadafroz8786
    @mohammadafroz87869 ай бұрын

    Zabaradast bhai

  • @parulbhaiya5158
    @parulbhaiya51587 ай бұрын

    Very useful video

  • @akashhela8521
    @akashhela85213 ай бұрын

    Thanks you sir. ❤❤

  • @JAVEADKHAN
    @JAVEADKHAN5 ай бұрын

    very nice bhai

  • @laxmanrajoriya825
    @laxmanrajoriya8252 ай бұрын

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

  • @firdoshahmed6330
    @firdoshahmed633010 ай бұрын

    Thanks guruji

  • @aashishsharma3212
    @aashishsharma321225 күн бұрын

    Thanks Sir

  • @rameshwernagar1599
    @rameshwernagar15994 ай бұрын

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

  • @nimaiskr
    @nimaiskr5 ай бұрын

    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
    @ilyasmwt480410 ай бұрын

    Maan gaye bhai, and topppic

  • @radhekrsna007
    @radhekrsna00710 ай бұрын

    U r champion

  • @ngpandit2660
    @ngpandit26603 ай бұрын

    Very nice.....

  • @vaghelajayendra
    @vaghelajayendra10 ай бұрын

    Nice one

  • @ajayshivpuje3797
    @ajayshivpuje37976 ай бұрын

    Very nice brother ❤

  • @hafiztahir9760
    @hafiztahir97607 ай бұрын

    Sir ap bhut acha samjatay ho

  • @SKSethia-cs4zc
    @SKSethia-cs4zc9 ай бұрын

    Great

  • @sadashivkage3133
    @sadashivkage31337 ай бұрын

    TQ....

  • @hafizurrahman9081
    @hafizurrahman90819 ай бұрын

    Very nice

  • @Rex-Solis
    @Rex-Solis7 күн бұрын

    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
    @mohankathe33323 ай бұрын

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

  • @sumitkumarbhandari6729
    @sumitkumarbhandari672910 ай бұрын

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

  • @Interestingboy642
    @Interestingboy6423 ай бұрын

    Very good video

  • @bijaytanty8434
    @bijaytanty84349 ай бұрын

    Good 👍

  • @subramaniyam176
    @subramaniyam1767 ай бұрын

    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
    @ROSHANKUMAR-cw3lc2 ай бұрын

    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
    @mientertainment10869 ай бұрын

    Guru love you from Pakistan

  • @syedikramullah1114
    @syedikramullah111410 ай бұрын

    Nice

  • @laxmipolymers2986
    @laxmipolymers29869 ай бұрын

    Super

  • @mdasgaransari295
    @mdasgaransari29510 ай бұрын

    waoo nice videos sir

  • @Elecnovate
    @Elecnovate9 ай бұрын

    blank option not showing

  • @arunkumarsinghark3024
    @arunkumarsinghark302410 ай бұрын

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

  • @gautamsoni8137
    @gautamsoni81379 ай бұрын

    Bhaiya aap please google sheets ke bhi video banayee naa

  • @osamakhan4275
    @osamakhan427510 ай бұрын

    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
    @ketannaliyapara20218 ай бұрын

    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
    @AftabAhmed-uw4ki10 ай бұрын

    Sir first viewrs ho asi video ka

  • @user-kb2hr5im3k
    @user-kb2hr5im3k10 ай бұрын

    plz Power query ke vidos bnain.

  • @CYLONE-zo2kb
    @CYLONE-zo2kbАй бұрын

    sir apka konsa excel version he

  • @Vikal_Gupta
    @Vikal_Gupta5 ай бұрын

    use wrap text for address conversion from 2 to 1 line

  • @geetasachdeva7620
    @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
    @AftabAhmed-uw4ki10 ай бұрын

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

  • @Prasant-Rathod
    @Prasant-Rathod6 ай бұрын

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

  • @ghanshyamahuja1829
    @ghanshyamahuja182910 ай бұрын

    Hi deepka power bi ka tutorial kijiye

  • @khiladichunky3673
    @khiladichunky3673Ай бұрын

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

  • @sifathasan4465
    @sifathasan446526 күн бұрын

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

  • @Bewafa_5961
    @Bewafa_59613 ай бұрын

    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

  • @Entertainment10391
    @Entertainment103919 ай бұрын

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

  • @meherrizwan1254
    @meherrizwan12548 күн бұрын

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

  • @abhishekchaudhary7009
    @abhishekchaudhary70095 ай бұрын

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

  • @muhammadtalha3163
    @muhammadtalha31637 ай бұрын

    Sir ap excel ka knsa version use kre h

  • @ranubond702
    @ranubond7029 ай бұрын

    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
    @nitinyeole17696 ай бұрын

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

  • @Sagar-nm7oq
    @Sagar-nm7oq8 ай бұрын

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

  • @shahmuhammad7401

    @shahmuhammad7401

    6 ай бұрын

    same

  • @NikhilSingh-tk5hx

    @NikhilSingh-tk5hx

    5 ай бұрын

    Same

  • @khushi4717
    @khushi47176 ай бұрын

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

  • @pogofreak8322
    @pogofreak83229 ай бұрын

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

  • @prashanthlastplayer3860
    @prashanthlastplayer38605 ай бұрын

    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
    @taajeducationielts2 ай бұрын

    ✅✅✅✅

  • @mohd.faisal4139
    @mohd.faisal41398 ай бұрын

    Link kaha hai bhai

  • @user-hk2ro2wr2x
    @user-hk2ro2wr2xАй бұрын

    Link kidr h sir.. kaha se data download kare

  • @1gevaypakistan
    @1gevaypakistan2 ай бұрын

    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

    @1gevaypakistan

    2 ай бұрын

    UnWanted remove Specisl charcters

  • @muhammadharis6930
    @muhammadharis69307 ай бұрын

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

  • @SagarKumar-nh3no

    @SagarKumar-nh3no

    5 ай бұрын

    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
    @usmanjavaid98429 ай бұрын

    Ctrl j is not responding.

  • @iqbalsheikh5027
    @iqbalsheikh50279 ай бұрын

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

  • @iqbalsheikh5027

    @iqbalsheikh5027

    9 ай бұрын

    Will you help me where I am making mistake

  • @usmanjavaid9842

    @usmanjavaid9842

    9 ай бұрын

    Ctrl j is not working

  • @skillyt04
    @skillyt04Ай бұрын

    Blank option not showing 😢😢

  • @jigneshrevankar

    @jigneshrevankar

    14 күн бұрын

    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

    @doubleDeeD

    2 күн бұрын

    Same

  • @monudahiya5841
    @monudahiya584110 ай бұрын

    Sir 14 * 12 ek hi cell mein multiply kaise kare

  • @monudahiya5841

    @monudahiya5841

    10 ай бұрын

    Reply plz

Келесі