Data
Free
London (足球竞彩网)
Monday, 07 October, 2024
7
–
9
pm
+08
Clean and Prepare Data in Excel | FREE Data Skills
About This Class
Pop quiz: How useful is dirty data?
If you answered, "Not at all," you're right. Now that you’ve got that basic principle down, it’s time to clean and prepare your data for analysis.
This free, two-hour session will teach you best practices for handling null values and cleaning your data for analysis, then give you hands-on practice using basic formulas and functions like trim, text, average, and count to make sure your data is sparkling clean.
Don't miss our next session where you’ll get practice with Hands-on Excel Analytics. We’ll take your freshly cleaned dataset and begin analysis using popular methods like PivotTables and VLOOKUP to start to develop insights into what the data is saying. We’ll see you there.
Takeaways
- Learn common data cleaning actions like reformatting dates, removing duplicates, and combining data sources.
- Practice applying basic Excel functions and formulas like trim, text, average, count, and more to get your data ready for analysis.
Preparation
- This is a beginner-friendly series, so no prior knowledge is necessary.
- You’ll need an Excel account if you’re planning to follow along live. If you don’t have one already, you can sign up for a Free 1-Month Trial of Microsoft 365. Keep in mind, this part is optional.
- A recording of every session from Data Week will be shared within a few business days after the week’s end.
- This session will be held in a Zoom webinar, so your mic and camera will be off. We’ll interact through the chat, Q&A, and reactions.
About the Instructor
Preriit Souda
Data Science Director, Kantar
Preriit Souda is a Director: Data Science working for Kantar TNS UK. Kantar TNS is a leading global marketing research agency within WPP. Preriit’s key focus is to help organisations answer difficult strategic questions by unravelling explicit and implicit human expression through mining social media data.
He has provided real-time analysis of industrial actions, reaction to TV shows, and impact of negative PR. His work has helped develop new products and track brand reputation using social media data alongside more traditional market research approaches such as Survey, focus groups, IOT, Google search data, weather, CRM and mobile data.
足球竞彩网 Code of Conduct
Your registration for or attendance at any 足球竞彩网 Assembly offering indicates your agreement to abide by this 足球竞彩网 Code of Conduct policy and its terms.
.%20We%E2%80%99ll%20take%20your%20freshly%20cleaned%20dataset%20and%20begin%20analysis%20using%20popular%20methods%20like%20PivotTables%20and%20VLOOKUP%20to%20start%20to%20develop%20insights%20into%20what%20the%20data%20is%20saying.%20We%E2%80%99ll%20see%20you%20there.&link=/education/clean-and-prepare-data-in-excel-free-data-skills/london/203746&picture=https://ga-core.s3.amazonaws.com/production/uploads/program/default_image/17832/Email_Headers_Small_PNG-AdobeStock_374526493__1_.png&redirect_uri=/education/clean-and-prepare-data-in-excel-free-data-skills/london/203746)
