Data Cleaning In Excel - Beginners Tutorial
Вставка
- Опубліковано 5 вер 2024
- 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:
www.youtube.co...
#ExcelDataCleaning, #DataCleaningInExcel, #HowToCleanDataInExcel
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 !
I loved your video, you explained everything with such a duplicity. Please make more video about data analysis. Thank you so much
You’re so good at teaching. Thank you so much.
Well explained! Thank you so much for the step-by-step demonstration!
I want to see more video from you on data cleaning/functions. Please keep on posting and thanks for your great great explanation!!!
this is the best explanation and new skill unlocked . thank you very much
So helpful, many thanks Please Please Please I need more of these tutorials
"I don't know about you, I'm feeling clean already" 🤣thanks for the chuckle and you made data cleaning fun. Just subscribed.
Thank you soooo much. It was really helpful. God bless you. ❤
Great work 👏👏
You did a great job explaining this concept, cleaning data. I am looking forward to learning more from you.
you are approachable , thanks
Madly underrated video!
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?
very clear explained
Thank you very much. Well explained
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.
Good, but the column date has different formats and some are text and others numbers ,how i can fixed?
Hello, your explanation is topnurch.
Very nice Sir.Thank you so much.
It was marvelous, i need the next step
Thank you so much.
It's really good clips, Dear.
great video. Thanks for sharing
thank-you!
Thank youuuuuuu🧡🧡🧡
Thank you.
Loved this video it deserves more views!
Great content .. keep going 👍🏾
thanks a lot sir .
Brilliant video!
thank-you! 😀
Awesome tutorial! Thanks❤
Thanks for that video, u are a cool dude, keep it up, the video was exactly what i needed mate :)
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.
simple but huge.
fab intro🤙 😂
Great video but what was that about the joke attempt on 8:10 ? 🤣🤣
Hey do you have part 2?