Top 30 Data Cleaning Tricks in Excel | Excel Data Cleaning Course

Рет қаралды 71,112

3 жыл бұрын

In this tutorial, we will learn Top Excel Data Cleaning Tricks.
Every Excel learner's Biggest Problem is How to Clean My Data?
I will show you 30 Simple tricks to clean the data in Excel.
Checkout Full Advanced Excel Course Library: bit.ly/30JD5is
We covered the following topics:
00:05 Introduction to Top 30 Data Cleaning Tricks
00:50 How to change the Case of the Text in Excel
02:30 How to Remove Extra Spaces in a Sentence in Excel
04:14 How to Find the Length of a Text in Excel
05:46 How to Convert Numbers stored as text back to a number in Excel
09:03 How can you add a chart inside a cell in Excel
10:31 How to add missing zeroes in Cheque numbers in Excel
14:45 How to Join Text from Different Cells in Excel
19:34 How to use a wildcard character asterisk with Find and Replace in Excel
22:29 How to use wildcard character questions mark with Find and Replace in Excel
24:45 How to delete wildcard character asterisk using Find and Replace in Excel
27:14 Why should you use MS Word's Find and Replace over MS Excel's
32:58 How to replace one cell color format with another in the entire worksheet
37:22 How to apply basics Text to Columns to Split the Text in Excel
40:08 How to keep the zeroes when applying Text to Columns on Data with preceding zeroes
43:59 How to Clean Number in Excel
46:19 How to Convert Number with Dr. and Cr. to positive and negative numbers in Excel
48:19 How to rectify incorrectly formatted date using Text to Column in Excel (Case-1)
51:35 How to rectify incorrectly formatted date using Text to Column in Excel (Case-2)
54:43 How to use LEFT and RIGHT Function in Excel
58:24 How can you increase the power of LEFT and RIGHT Formulas using the SEARCH Function in Excel
01:00:34 How is MID more powerful than LEFT and RIGHT Function in Excel
Top 30 Data Cleaning Tricks in Excel | Data Cleaning Course
#datacleaning #exceltricks #excelformula
Keep Yourself Updated. Follow Us Now!!!
Like us on / yodalearning
Tweet us at / yodalearning
Follow our boards at / yodalearning

Пікірлер: 93

@jumpropemonk7703 3 жыл бұрын

Wouldn't it be nice if there a copy of f the workbook that was used in the video so we can practice along?

@Telecomcore 3 жыл бұрын

One of the best excel video on KZfaq.!!

@alialbayati9368 3 жыл бұрын

Text to Columns are great tricks, really loved them. nevertheless, the tutorials are awesome. thanks a lot.

@mbunweemmanuel109 Жыл бұрын

A big thank you Yoda Learning Academy

@vilassadhwani5335 3 жыл бұрын

The challenge at 24:45 can also be solved by using this formula =SUBSTITUTE(D3,CHAR(42),""). I discovered it just a couple of months back. But your trick is also great sir👍🏻.

@ahmedsaieed__ 3 ай бұрын

Thank you so much, this video will be my reference for life

@wwpharmacist Жыл бұрын

Very helpful thank you

@hi.deepakmehta 7 ай бұрын

Really helpful sir. Thanks.

@boppanakishankanna6029 6 ай бұрын

Great tutorial

@hari60700 3 жыл бұрын

Simply wow.Rishab u are brilliant

@vilassadhwani5335 3 жыл бұрын

Though I already know almost every trick, but certain tricks work like magic. You are truly God of Excel🙏❤️

@Yodalearning 2 жыл бұрын

Wow, thank you

@bezualemfisseha2119 7 ай бұрын

Thank you so much

@muhammadrashid3307 4 ай бұрын

you have an impressive way of teaching ...thanks

@WJA5 3 жыл бұрын

Outstanding.....

@ahmedmohmmed5085 Жыл бұрын

thank you, l learned a lot

@HemanthKumar-lb4xt 3 жыл бұрын

Wildcard replace was awesome...

@user-rm4cg2zn6x 4 ай бұрын

Thank you Sir, Go ahead

@PradeepKumar-yp3tc 2 жыл бұрын

Standing ovation sir :)

@pratiksharma3598 3 жыл бұрын

I love your channel man 🤠

@a22258461 Жыл бұрын

So useful

@ezemms 7 ай бұрын

Thanks

@Muhammad_Shahnawaz Жыл бұрын

Excellent Honorable

@govindgupta9544 3 жыл бұрын

Great vedio🙏

@julianseralathan 5 ай бұрын

great video😊

@akashjagtap2854 Жыл бұрын

thanks sir that was really useful😃

@HoneyBunnySugarPlum 2 жыл бұрын

This is simply awesome. thank you so much for making life simpler.

@Yodalearning 2 жыл бұрын

You're very welcome!

@nimikajadav3004 6 ай бұрын

It's very video bhai... Jay swaminarayan...

@alimansoor4943 3 жыл бұрын

Sir you are super man in excle love you sir 🇵🇰

@manjit.sarania Жыл бұрын

Very good explanation sir

@ganeshmaruti597 3 жыл бұрын

much needed.. thanks

@Yodalearning 2 жыл бұрын

Welcome!

@rinkuthakur2888 3 жыл бұрын

It's my favourite channel

@yesudasnirosha3179 2 жыл бұрын

Great job. I have corrected my mistakes in sheets. Good and simple explanation.

@Yodalearning 2 жыл бұрын

Great job!

@775shahrukh Ай бұрын

can u upload some practise worksheet for this particular lesson???

@preetichadichal9791 2 жыл бұрын

Thanks a lot for the tutorial...very helpful

@Yodalearning 2 жыл бұрын

Welcome 😊

@ben-cb5er 3 жыл бұрын

awesome video! thanks mate

@Yodalearning 2 жыл бұрын

My pleasure!

@nasrataimi3082 Жыл бұрын

Good 👍

@MrMsmith1 3 жыл бұрын

Very Good! I have a question... I would like to copy your video page number links above and put them into Excel in separate rows. So the first row would include a hyperlinked cell "00:05 Introduction to Top 30 Data Cleaning Tricks" etc. When I copy and paste it puts them into one cell with hyperlinks. I tried text to columns but did not work. How do I separate and keep original hyperlinks? Thank you.

@tamerhegab1513 11 ай бұрын

Cool

@sandiplabade6755 2 жыл бұрын

Good sir i like this videos 👌🏻👌

@rohandhepe7515 3 жыл бұрын

One of the excel cleaning course on youtube

@Yodalearning 2 жыл бұрын

Wow, thanks!

@3690markm 2 жыл бұрын

Very illuminating as an intermediate Excel user and Beginner Data Analyst. Thank you!

@3690markm 2 жыл бұрын

Also, I really liked the following tricks: Text to Column to rectify Dates Search() with Left/Right() The Find and Replace with *asterisk was really neat too Nifty tools for the DA toolbelt!

@RoopaliKadam 3 жыл бұрын

Superb :) Thank you

@Yodalearning 2 жыл бұрын

Welcome 😊

@nikhilparmar1770 3 жыл бұрын

As always superb 👍💐

@Yodalearning 2 жыл бұрын

Thanks a lot 😊

@janardhanreddy9836 2 жыл бұрын

Thanks bro Quite interesting topic

@Yodalearning 2 жыл бұрын

Glad you liked it

@riyamangla3754 2 жыл бұрын

Thankyou 😊

@Yodalearning 2 жыл бұрын

🤗

@rafaujma7534 3 жыл бұрын

hi man, great video! But i have question about populating 0 at the beggining of a number. Numbers you created with that formulas were in fact strings. So why would i ever need that i my work?

@muhammadshalah8724 3 ай бұрын

good

@mrmusicloverable 3 жыл бұрын

For the rept function, to avoid the overflowing of the cell use the playbill font with the pipes and thank me later.

@Yodalearning 2 жыл бұрын

@jumpropemonk7703 2 жыл бұрын

Can we have the data set used in video to practice along please ?

@Anonymous-31 3 жыл бұрын

Good one brother

@Yodalearning 2 жыл бұрын

Thanks ✌️

@_KING_SHADOW 3 жыл бұрын

Dear Rishabh, TOP 3 tricks are 1. tilt ~ to replace ****** 2. Text to Column dates conversion 3. Insert "Zero" before any number. Question :- Could it be possible or advise that if i have dr. & cr. two column would like to marge with 1 column which shows (-) negative number in (00000) like this. Two use those data in to pivot table.

@AravindHan008 2 жыл бұрын

How to fill NA values in financial dataset with last observation carried forward (LOCF) ? having a CPI dataset from 1989 to 2008 for all the countries .. does filling a LOCF affect the graph ? for example in 1988 Bolivia CPI =23.34002 but Brazil CPI = NA next value for brazil start from 1998 only having 10NA values above that . so if we fill the 1998 CPI value to above all NA areas for brazil will give totally wrong insights compare to Bolivia right ?

@nishantchaudhary7528 Жыл бұрын

Can you share the unsolved excel file, for practice??

@rajeevgosavi4514 3 жыл бұрын

SIR, CAN YOU PROVIDE DOWNLOAD LINK TO YOUR PRACTICE FILE

@patelalpesh6792 2 жыл бұрын

Sir, I want to insert live clock in Excel, using now function, without refreshing, or auto refreshing!, Is it possible? Please help if possible

@fahmifajriansyah1 2 жыл бұрын

Interesting question

@naresh548 4 ай бұрын

Sir can you provide practice file.

@shivakumars3204 Ай бұрын

Ctrl+H , text to column

@dakshbhatnagar 7 ай бұрын

32:56 this is a cake walk with regex which is what google sheets implement

@yuhasliza9745 2 жыл бұрын

how to clean the text before / on your 1:04:15

@DineshPal-nw1ss 2 жыл бұрын

please provide pratice dataset

@souvikdas9110 Жыл бұрын

Pls provide sample data in description...

@khursheedahmadrather3822 2 ай бұрын

Sir plz provide practice file

@ubaidillahmuhammad20 2 жыл бұрын

nice. put link excel file in the description video...

@pavankumar-lt9mq 10 ай бұрын

please provide practice file

@rajeevgosavi4514 3 жыл бұрын

Sir, can you provide us a link to download file to practise along

@Yodalearning 3 жыл бұрын

Click here - yodalearning.com/courses/online-advanced-excel-course/

@ahmadghaffar6213 3 жыл бұрын

@@Yodalearning Sir It's not working

@rajeevgosavi4514 3 жыл бұрын

Sir, I would be interested in joining your MS Word course. Please send me link

@Yodalearning 3 жыл бұрын

Click here - yodalearning.com/courses/ms-word-tutorials/

@anilkumarsahoo8780 3 ай бұрын

How to get data cleaning job brother...

@PradeepKumar-yp3tc 2 жыл бұрын

Sir, if we have tenure of employees in months, can we group them? Count of employees >12 months, Count of employees b/w 12 to 18 months, Count of employees b/w 18 to 24 months Count of employees b/w 24 to 36 months

@fahmifajriansyah1 2 жыл бұрын

You can use pivot, or =if(), or =countif() formula maybe?