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
Dosto kaisa laga ye video 😊
@GiGiTales2293
10 ай бұрын
Super sir
@nishanth4323
10 ай бұрын
Bhai ji aap gajab ho..🫂👏👏
@madhusudandas2953
10 ай бұрын
Bht badhiya sir ji
@mrutyunjayasatapathi4567
10 ай бұрын
Sir mujhe bataye please me kis app se mobile me Excel ki sari tap ke sath practice kar seknu
@rajnipandey9901
9 ай бұрын
Bhut hi badhiya sir gajab
Thanks
You are too good, the way you explain is so simple and easy to understand.
Thank you so much ki aap practice file dete hain....many people don't realise the value of practice file.....
बहुत बढ़िया वीडियो. बहुत उपयोगी। आपका बहुत-बहुत धन्यवाद।
Thank you. Very helpful video.
Very helpful and good teaching sir..🙏🙏🙏..plz make video on power query and power BI.
Thankyou sir 🙏 awesome explained 🌸
Very helpful video thanks 🙏
Very Good facilitator...
You are Best teacher ❤️ love you ❤️
Thank you Sir for explanation clearly and it's video is very important and helpful for me.
U deserve 10M ASAP! 🙌
I am from Pakistan Your videos are Brilliant.
Excellent
Yes we can't use filters for blank rowa
REALLY Thankss!
AMAIZING
Excellent Deepak ji.
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.
Bahut achha lga ye video bhi sir ji
very nice and wonderful
Sir its extremely wonderful great information love from Karachi Pakistan
Amazing ❤❤❤❤❤
Great video and tricks👌
Amazing 🔥🔥🔥🔥
Excellent video brother
Mashallah bhai apki video zabardast hoti hean very helpful.
Good information, thanks ❤
Thank you very much sir
Thank u Sir 💐
Amazing sirji
Sir aap ki each every video mast hoti hn❤
Thanks Man. 😉
Excellent Deepak sir❤️
Thank you bhaiya जय हिन्द
Zabaradast bhai
Very useful video
Thanks you sir. ❤❤
very nice bhai
i like video like this , thanks so much sir..
Thanks guruji
Thanks Sir
मजा आ गया दीपक भाई साहब
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
Maan gaye bhai, and topppic
U r champion
Very nice.....
Nice one
Very nice brother ❤
Sir ap bhut acha samjatay ho
Great
TQ....
Very nice
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
The link data is mismatched to your data the one in the video. Please check.
Bina dekhe , Mai bolta hnu sir apka video achha hai.
Very good video
Good 👍
Excellent sir,most usefull videos,sir kindly give Excel practice set link ,I can't get link from ur discriptin box kindly guide me
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
Guru love you from Pakistan
Nice
Super
waoo nice videos sir
blank option not showing
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤ 🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤
Bhaiya aap please google sheets ke bhi video banayee naa
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
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
Sir first viewrs ho asi video ka
plz Power query ke vidos bnain.
sir apka konsa excel version he
use wrap text for address conversion from 2 to 1 line
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?
Sir plz power query ka full tutorial bano plz plz plz🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🇵🇰🙏🙏🙏🙏🙏🙏🙏🙏
Sir ye jo line break remove trick hai ye purane Excel mein nahi kaam krte hai kya?
Hi deepka power bi ka tutorial kijiye
Sir freelancer par kaam krne k liye kuchh special btaiye jisse main kuchh earn kar sku
when I try to replace something it shows that it is a protected sheets. What should I do?
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
Sir mujhy medicen Distribution k liye excel software banana Hai invocice warranty non warranty so ik video bna dein
step 3 not workig after much attempts? what can be reasons
Sir, ( 3:34 ) blanks option is not present in my excel
Sir ap excel ka knsa version use kre h
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🙏🏻
Sir you have any ai tool for cleaning data please make video on it or suggest to me 😊
Hi sir when i want to delete the blank rows, it doesn't show the blank in the filter section. Please help
@shahmuhammad7401
6 ай бұрын
same
@NikhilSingh-tk5hx
5 ай бұрын
Same
Bhaiya data clean baad kya mid point histogram create karne ke liye please reply today my exam
Sir apne jo file di h vo video wali file se alg h ... isem errors hain ... aise kaise chalega sir
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 😊😊😊😊😊😊😊😊😊😊
✅✅✅✅
Link kaha hai bhai
Link kidr h sir.. kaha se data download kare
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
2 ай бұрын
UnWanted remove Specisl charcters
Hello sir mere pass filter krne k bad blank show nh horaha or first 5 rows show horahi hn
@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.
Ctrl j is not responding.
Your Crtl +J functions is not doing anything, as it is done in your project file. Can you please check and let
@iqbalsheikh5027
9 ай бұрын
Will you help me where I am making mistake
@usmanjavaid9842
9 ай бұрын
Ctrl j is not working
Blank option not showing 😢😢
@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
2 күн бұрын
Same
Sir 14 * 12 ek hi cell mein multiply kaise kare
@monudahiya5841
10 ай бұрын
Reply plz