Excel Fundamentals | One-day Workshop

Data

$350 USD each

New York City (Online)
Friday, 26 April, 2024
9 am – 4 pm EDT

About This Workshop

Now through April 30th, use the code TECHIT200 at checkout to take $200 off the cost of a workshop.

In this seven-hour workshop, you’ll learn why Excel is the leading tool — and how to use it — to enhance the way you analyze and restructure your data.

We’ll start with the basics of exploratory data analysis (EDA) to familiarize yourself with a dataset, and how to apply Excel formulas and best practices to clean a dataset and get it ready for analysis.

From there we’ll get into the actual analysis using references and ranges to manipulate the data, connecting data from multiple spreadsheets with popular functions like LOOKUP and creating PivotTables to quickly summarize your data. And what analysis is complete without some basic visualization? You’ll get hands-on practice with charts and conditional formatting to make your analysis easy to interpret.

By the end of this workshop, you’ll be equipped with the tools and knowledge to ask — and answer — the right questions of your data in Excel. You might even be inspired to pursue a career in data analytics with your new skills.

Please Note: Registration for this workshop will close 48 hours before the scheduled start date.

Takeaways

  • Conduct exploratory data analysis (EDA) in Excel to familiarize yourself with a dataset and generate descriptive statistics.
  • Utilize Excel formulas to apply data cleaning best practices, including splitting or combining columns, working with text data, and handling NULLs.
  • Use absolute references, relative references, and named ranges to effectively manipulate data.
  • Connect data across multiple spreadsheets using LOOKUP, INDEX, and MATCH functions.
  • Create PivotTables and use Excel aggregation functions to quickly summarize data.
  • Apply conditional formatting and create common Excel charts to visualize trends and outliers in data.

Preparation

  • This workshop is beginner friendly — no prior knowledge of product management necessary.
  • You’ll need an Excel account for this workshop — Google Sheets will not be covered. If you don’t have an Excel account already, you can sign up for a Free 1-Month Trial of Microsoft 365.
  • We’ll send an email one day before, and one hour before the workshop begins with the Zoom link.
  • There is no certificate for completing this workshop.
  • Reach out to help@ga.co with any questions.

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.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

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.

Sold Out!

Get on the waitlist

Be the first to know if a spot becomes available.

Add Me to the Waitlist

Can't Make It?

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

Sign-up not required

Follow
Spread the Word

You May Also Like

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 no.marketing@ga.co.