Data Cleaning In Excel - Beginners Tutorial
HTML-код
- Опубликовано: 22 авг 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 Наука
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!
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 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.
You did a great job explaining this concept, cleaning data. I am looking forward to learning more from you.
Thank youuuuuuu🧡🧡🧡
Thank you soooo much. It was really helpful. God bless you. ❤
Great work 👏👏
Madly underrated video!
you are approachable , thanks
Thank you very much. Well explained
very clear explained
It was marvelous, i need the next step
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.
Thank you so much.
great video. Thanks for sharing
thank-you!
Very nice Sir.Thank you so much.
Hello, your explanation is topnurch.
It's really good clips, Dear.
Loved this video it deserves more views!
Brilliant video!
thank-you! 😀
Great content .. keep going 👍🏾
Thank you.
Thanks for that video, u are a cool dude, keep it up, the video was exactly what i needed mate :)
thanks a lot sir .
Awesome tutorial! Thanks❤
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?
fab intro🤙 😂
simple but huge.
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 ? 🤣🤣
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?