Top 30 Data Cleaning Tricks in Excel | Excel Data Cleaning Course
ฝัง
- เผยแพร่เมื่อ 28 ก.ย. 2024
- 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?
Though I already know almost every trick, but certain tricks work like magic. You are truly God of Excel🙏❤️
Wow, thank you
Great job. I have corrected my mistakes in sheets. Good and simple explanation.
Great job!
you have an impressive way of teaching ...thanks
Sir you are super man in excle love you sir 🇵🇰
One of the excel cleaning course on youtube
Wow, thanks!
Wildcard replace was awesome...
Very helpful Video😊
Thanks a lot for the tutorial...very helpful
Welcome 😊
can u upload some practise worksheet for this particular lesson???
Thanks
great 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👍🏻.
So useful
Can you share the unsolved excel file, for practice??
Outstanding.....
Good sir i like this videos 👌🏻👌
Cool
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 ?
You sholud learn slowly not show your speed ,that is not way
32:56 this is a cake walk with regex which is what google sheets implement
For the rept function, to avoid the overflowing of the cell use the playbill font with the pipes and thank me later.
:)
One of the best excel video on TH-cam.!!
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
Text to Columns are great tricks, really loved them. nevertheless, the tutorials are awesome. thanks a lot.
SIR, CAN YOU PROVIDE DOWNLOAD LINK TO YOUR PRACTICE FILE
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.
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.
no data to practice along..I am disliking this video :) :)
Can we have the data set used in video to practice along please ?
Way of explanation is Very nice ❤🎉 🦚
How to get data cleaning job brother...
how to extract data from a wrapped text ?
please give me a raw file excel for practice
Sir can you provide practice file.
Sir plz provide practice file
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
Ctrl+H , text to column
Please provide video data
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?
I love your channel man 🤠
Great vedio🙏
good
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?
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
Thank you so much, this video will be my reference for life
It's very video bhai...
Jay swaminarayan...
Really helpful sir. Thanks.
nice. put link excel file in the description video...
Pls provide sample data in description...
please provide pratice dataset
It's my favourite channel
thanks sir that was really useful😃
Very good explanation sir
Thank you Sir,
Go ahead
Simply wow.Rishab u are brilliant
Very helpful thank you
Excellent Honorable
A big thank you Yoda Learning Academy
thank you, l learned a lot
Thank you so much
Great tutorial
Thanks bro
Quite interesting topic
Glad you liked it
Standing ovation sir :)
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!
Good 👍
How to remove extra space in numberial?
use Trim function
This is simply awesome. thank you so much for making life simpler.
You're very welcome!
awesome video! thanks mate
My pleasure!
Superb :) Thank you
Welcome 😊
much needed.. thanks
Welcome!
Good one brother
Thanks ✌️
Thankyou 😊
🤗
As always superb 👍💐
Thanks a lot 😊