Hot skills summer is back. Get $/£/€1,500 off a short course.

Don't miss our Skill Seeker Series from Sept 30 - Oct 30.

My Account
Employers
Clean and Prepare Data in Excel | FREE Data Skills

Upcoming in Online

7

Monday, 7 October
Online

Online Campus

Online
Anywhere
Online

Past Locations for this Class

Clean and Prepare Data in Excel | FREE Data Skills | Online

7
Attend the next event on Monday, 7 October.

Upcoming in Online

7

Monday, 7 October
Online

Online Campus

Online
Anywhere
Online

Past Locations for this Class

About this class

Pop quiz: How useful is dirty data?

If you answered, “Not at all,” you got it right. Now that you’ve 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 sparkles.

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.

Prereqs & 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 this session will be sent via email at the end of the full Skill Seeker series.
  • 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.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.