Top 30 Data Cleaning Tricks in Excel | Excel Data Cleaning Course
HTML-код
- Опубликовано: 5 мар 2021
- 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
Wouldn't it be nice if there a copy of f the workbook that was used in the video so we can practice along?
Very helpful Video😊
Text to Columns are great tricks, really loved them. nevertheless, the tutorials are awesome. thanks a lot.
A big thank you Yoda Learning Academy
One of the best excel video on RUclips.!!
Very helpful thank you
Thank you so much, this video will be my reference for life
you have an impressive way of teaching ...thanks
Simply wow.Rishab u are brilliant
Wildcard replace was awesome...
Thank you so much
Really helpful sir. Thanks.
Outstanding.....
Great tutorial
thank you, l learned a lot
Thank you Sir,
Go ahead
It's very video bhai...
Jay swaminarayan...
Great vedio🙏
Excellent Honorable
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👍🏻.
So useful
Sir you are super man in excle love you sir 🇵🇰
Standing ovation sir :)
Thanks
thanks sir that was really useful😃
This is simply awesome. thank you so much for making life simpler.
You're very welcome!
I love your channel man 🤠
Very good explanation sir
great video😊
It's my favourite channel
Great job. I have corrected my mistakes in sheets. Good and simple explanation.
Great job!
Good 👍
much needed.. thanks
Welcome!
Though I already know almost every trick, but certain tricks work like magic. You are truly God of Excel🙏❤️
Wow, thank you
Good sir i like this videos 👌🏻👌
Thanks a lot for the tutorial...very helpful
Welcome 😊
Very illuminating as an intermediate Excel user and Beginner Data Analyst. Thank you!
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!
awesome video! thanks mate
My pleasure!
One of the excel cleaning course on youtube
Wow, thanks!
Superb :) Thank you
Welcome 😊
As always superb 👍💐
Thanks a lot 😊
Thanks bro
Quite interesting topic
Glad you liked it
Cool
good
Thankyou 😊
🤗
For the rept function, to avoid the overflowing of the cell use the playbill font with the pipes and thank me later.
:)
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.
Good one brother
Thanks ✌️
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?
can u upload some practise worksheet for this particular lesson???
Can we have the data set used in video to practice along please ?
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.
SIR, CAN YOU PROVIDE DOWNLOAD LINK TO YOUR PRACTICE FILE
Can you share the unsolved excel file, for practice??
32:56 this is a cake walk with regex which is what google sheets implement
please provide pratice dataset
Ctrl+H , text to column
Pls provide sample data in description...
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 ?
nice. put link excel file in the description video...
Sir can you provide practice file.
Sir plz provide practice file
Sir,
I want to insert live clock in Excel, using now function, without refreshing, or auto refreshing!, Is it possible?
Please help if possible
Interesting question
how to clean the text before / on your 1:04:15
Sir, I would be interested in joining your MS Word course. Please send me link
Click here - yodalearning.com/courses/ms-word-tutorials/
please provide practice file
Sir, can you provide us a link to download file to practise along
Click here - yodalearning.com/courses/online-advanced-excel-course/
@@Yodalearning Sir It's not working
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
You can use pivot, or =if(), or =countif() formula maybe?
Please provide video data
How to get data cleaning job brother...
How to remove extra space in numberial?
use Trim function
please give me a raw file excel for practice
You sholud learn slowly not show your speed ,that is not way
no data to practice along..I am disliking this video :) :)