FREE Workshop | Clean and Prepare Your Data

Thursday, 28 September, 2023
9 11 am EDT
Manama (Online)

About This Workshop

Pop quiz: How useful is dirty data?

If you answered, "Not at all," you got it right. Now that you’ve got the data basics down, it’s time to clean your data and prepare it for analysis.

This free, 2-hour workshop will teach you best practices for handling null values and cleaning your data, then we’ll dive into basic formulas and functions like Trim, Text, AVERAGE, and COUNT to take your data cleaning skills up a notch.

Make sure to join us for next week where we’ll cover Excel Analytics Basics. You’ll take your freshly cleaned dataset and start to analyze it using popular methods like Pivot Tables and VLOOKUP to find answers to your hypothesis. We’ll see you there.


You’ll leave this workshop knowing:

  • Common data cleaning actions like reformatting dates, removing duplicates, and combining data sources
  • How to use basic Excel functions and formulas like Trim, Text, AVERAGE, COUNT, and more to get your data ready for analysis


  • This is an entry level workshop, so no prior knowledge is necessary.
  • You’ll need an Excel account if you are 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
  • If anything prevents you from following-along live, the recording will be shared after the series so you can review the content anytime.
  • Your mic and camera will be off for the duration of the workshop.
  • Interact with your instructor and fellow classmates through the Chat and Q&A.

About the Instructor

Vaughn Caldon Photo

Co Founder, Ballstar

Vaughn is a Brooklyn born, father of two, serial entrepreneur who is currently on a mission to organize the world's sports data. Before launching his sports data platform Ballstar, Vaughn served as associate director of Alumni affairs for Prep for Prep and later as an Alum Trustee. Using data to build community, make connections, and to better focus fundraising efforts Vaughn is most proud of the work he has done to nurture niche communities of Alums like those in the arts and tech communities. Now Vaughn uses data to bring together the global Basketball community.

Community Code of Conduct

Your registration for or attendance at any General Assembly offering indicates your agreement to abide by this Community Code of Conduct policy and its terms.

Can't Make It?
Follow this workshop to get an email the next time it’s scheduled.
Sign-up not required
Spread the Word

You May Also Like


Can't Make It?

Follow this workshop to get an email the next time it’s scheduled.

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.
Join Us
By providing us with your email, you agree to General Assembly’s Terms of Service, and to receive email updates on courses, special events and GA news. You can change your mind at any time and unsubscribe from GA marketing emails by clicking the "unsubscribe" link located at the bottom of every marketing email or by emailing