Data Cleaning In Excel - Beginners Tutorial
ฝัง
- เผยแพร่เมื่อ 10 ก.ค. 2021
- Beginners tutorial on how to clean data in Excel.
Check out this video for a beginners tutorial on how to clean data in Python: • Data Cleaning In Pytho...
In this video, we answer "Why is Data Cleaning important?" and explore 10 incredibly useful Data Cleaning tips and tricks in Microsoft Excel to easily:
✅ Import a CSV using Text To Columns / Text Import Wizard
✅ Escape Commas in a CSV using Double Quotes
✅ Resize Columns using AutoFit
✅ Delete Blank Rows using Go To Special, Blanks
✅ Remove Duplicates
✅ Remove Excess Spaces in Text using the TRIM function
✅ Replace Values using Find and Replace
✅ Replace Formulas with Values using Paste Special, Values
✅ Standardise Text using UPPER, PROPER, and LOWER functions, and
✅ Standardise Dates
Link to the sample file - stonks.csv:
bit.ly/2UADOCz
After watching this video, download the sample file and try data cleaning by yourself to solidify your understanding in preparation for your next Excel job interview!
Subscribe:
th-cam.com/users/edgecate?sub_...
#ExcelDataCleaning, #DataCleaningInExcel, #HowToCleanDataInExcel - วิทยาศาสตร์และเทคโนโลยี
![BOWKYLION - เจ้านายคะ (work-life imbalance) [Official MV]](http://i.ytimg.com/vi/6bFj8G2pOi4/mqdefault.jpg)
You are an exceptional teacher, Andrew! I noticed you have not uploaded on here in a while. Do you have a new channel? If so, please let us know! Cheers, Eileen
I am a newbie in this area and you explain so clearly no questions are left behind. Thank you for the hard work !
You’re so good at teaching. Thank you so much.
I want to see more video from you on data cleaning/functions. Please keep on posting and thanks for your great great explanation!!!
Well explained! Thank you so much for the step-by-step demonstration!
I loved your video, you explained everything with such a duplicity. Please make more video about data analysis. Thank you so much
Thank you for the tutorial. i just feel that we should also focus on the decimal places as well for the columns like Open, high and Low.
Awesome tutorial! Thanks❤
You did a great job explaining this concept, cleaning data. I am looking forward to learning more from you.
So helpful, many thanks Please Please Please I need more of these tutorials
Thanks for that video, u are a cool dude, keep it up, the video was exactly what i needed mate :)
"I don't know about you, I'm feeling clean already" 🤣thanks for the chuckle and you made data cleaning fun. Just subscribed.
this is the best explanation and new skill unlocked . thank you very much
It was marvelous, i need the next step
Thank you soooo much. It was really helpful. God bless you. ❤
Thank you so much.
you are approachable , thanks
Thank you very much. Well explained
Thank you.
Loved this video it deserves more views!
Thank youuuuuuu🧡🧡🧡
very clear explained
thanks a lot sir .
Madly underrated video!
Great work 👏👏
It's really good clips, Dear.
Great content .. keep going 👍🏾
Very nice Sir.Thank you so much.
Hello, your explanation is topnurch.
In your example file the dates are not formatted as dates, they are text, How would you clean that up to be able to change the date format and/ or sort by date?
Brilliant video!
thank-you! 😀
BIG LIKE :)
great video. Thanks for sharing
thank-you!
fab intro🤙 😂
simple but huge.
I have one scenario, was trying to extract the Month based on the Date column. However, it's always showing January as the month. Just curious to know why it's happening.
Hey do you have part 2?
Good, but the column date has different formats and some are text and others numbers ,how i can fixed?
Great video but what was that about the joke attempt on 8:10 ? 🤣🤣