Top 30 Data Cleaning Tricks in Excel | Excel Data Cleaning Course
Вставка
- Опубліковано 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?
One of the best excel video on UA-cam.!!
Text to Columns are great tricks, really loved them. nevertheless, the tutorials are awesome. thanks a lot.
A big thank you Yoda Learning Academy
Simply wow.Rishab u are brilliant
It's very video bhai...
Jay swaminarayan...
Thank you so much, this video will be my reference for life
you have an impressive way of teaching ...thanks
Very helpful Video😊
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👍🏻.
Great vedio🙏
Very helpful thank you
Great tutorial
Wildcard replace was awesome...
Really helpful sir. Thanks.
Outstanding.....
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.
Standing ovation sir :)
Thank you Sir,
Go ahead
It's my favourite channel
I love your channel man 🤠
Excellent Honorable
Thank you so much
great video😊
thank you, l learned a lot
Very good explanation sir
thanks sir that was really useful😃
Sir you are super man in excle love you sir 🇵🇰
So useful
Though I already know almost every trick, but certain tricks work like magic. You are truly God of Excel🙏❤️
Wow, thank you
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?
This is simply awesome. thank you so much for making life simpler.
You're very welcome!
Great job. I have corrected my mistakes in sheets. Good and simple explanation.
Great job!
Good 👍
Good sir i like this videos 👌🏻👌
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!
Cool
much needed.. thanks
Welcome!
can u upload some practise worksheet for this particular lesson???
Thanks a lot for the tutorial...very helpful
Welcome 😊
Can we have the data set used in video to practice along please ?
good
One of the excel cleaning course on youtube
Wow, thanks!
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.
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 ?
Superb :) Thank you
Welcome 😊
As always superb 👍💐
Thanks a lot 😊
Can you share the unsolved excel file, for practice??
For the rept function, to avoid the overflowing of the cell use the playbill font with the pipes and thank me later.
:)
Thankyou 😊
🤗
SIR, CAN YOU PROVIDE DOWNLOAD LINK TO YOUR PRACTICE FILE
Thanks bro
Quite interesting topic
Glad you liked it
Good one brother
Thanks ✌️
Pls provide sample data in description...
please provide pratice dataset
nice. put link excel file in the description video...
Sir can you 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 plz provide practice file
32:56 this is a cake walk with regex which is what google sheets implement
Ctrl+H , text to column
please provide practice file
How to get data cleaning job brother...
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?
Sir, I would be interested in joining your MS Word course. Please send me link
Click here - yodalearning.com/courses/ms-word-tutorials/
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
Please provide video data
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 :) :)