Data and graphs in spreadsheet documents for online analysis

EXCEL FUNDAMENTALS | two-day evening workshop

Give us three hours for two evenings, and walk away with fundamental Excel skills. Learn why Excel is the leading tool to enhance the way you analyze and restructure your data — and how to actually use it.

Think of this workshop as a low-risk way to test the waters of a data analytics career, or to get the skills to start performing your own data analysis in your current role. We can’t think of a good reason not to have Excel skills in your professional toolkit.

 
Business | AVAILABLE ONLINE

Join US

  • Hands on practice
  • Live instruction
  • Foundational Excel skills
  • Clean, analyze, and visualize data in Excel
Get Started

Who’s this for?

This workshop is for you if…

  • You’ve heard data analytics skills are essential in 2024, but have little or no experience using Excel and need a starting point.
  • You have access to datasets in Excel, but need some professional guidance getting started with analysis.
  • You’re interested in taking a data analytics short course or bootcamp, but want to test the waters before investing in a longer course.
Beautiful south american woman working at computer at office

technical requirements

To participate in this workshop, you’ll need to make sure you’re set up for success with the following:

  • A free Google account
  • A Zoom account
  • An Excel account
Professional Developer programmer working a software website design and coding technology, writing codes and database in company office, Global cyber connection technology.

Key Takeaways

You’ll leave this workshop confident in your ability to:

Understand Excel basics

You’ll learn why Excel is the leading data tool — and how to use it to enhance the way you analyze and restructure your data. Then practice basic Excel navigation and explore a dataset to determine the right questions to ask of your data for analysis.

Prepare and analyze data in Excel

After applying basic data cleaning functions to prepare your data for analysis, you’ll use references and ranges to manipulate the data, connect data from multiple spreadsheets, and create PivotTables to quickly summarize your data.

Build visualizations from your data analysis

You’ll learn when to use different types of visualizations to accurately convey your data, then get hands-on practice with charts and conditional formatting to make your analysis easy to interpret.

Workshop Agenda

Conduct exploratory data analysis (EDA) in Excel to familiarize yourself with a dataset, and learn to ask the right questions of your data so you know what you’re looking for in your analysis.
Before you can analyze a dataset, it will almost always need to be cleaned first. Learn common Excel functions and formulas for data cleaning, then get your hands dirty applying best practices like splitting or combining columns, working with text data, and handling NULLs to prepare your data for analysis.
Understand how to effectively manipulate data using absolute references, relative references, and named ranges. Then practice connecting data across multiple spreadsheets using LOOKUP, INDEX, and MATCH functions. Take your analytics to the next level with PivotTables and aggregation functions to quickly summarize data.
Turn your analysis into a visual. Learn the difference between visualizations like bar charts, line graphs, and scatterplots — and when to use them. Once you know which to use when, you’ll apply conditional formatting and create common Excel charts to visualize trends and outliers in data.

About the INSTRUCTORs

Next Steps

QUESTIONS? WE'VE GOT ANSWERS.

We get it, sometimes life gets in the way. If you’re unable to attend a workshop you signed up for, let us know at least a week before the start date and you’ll get a full refund. If you need to cancel within one week of the workshop, you’ll be eligible for a credit to transfer to the next session. Reach out to help@ga.co if you need to cancel or reschedule a workshop.
Look out for an email one day before, and one hour before the workshop with the Zoom link and workshop materials. If you don’t see the email, check your spam folder or reach out to help@generalassemb.ly and we’ll make sure you’re set up.
Our workshops are split into two evening sessions that are each three hours long. Workshops typically take place on a Monday and Wednesday, or Tuesday and Thursday, from 3–6 p.m. PT/6–9 p.m. ET.
Don’t worry, we know life can be hectic — and unpredictable. If you can only make one session, you'll still have access to the recordings for the entire workshop that you can reference at any time.
You bet — we want you to continue practicing and referencing the things you learned long after your workshop ends. You should receive the recording and any in-class materials within one week of your workshop via email.
We don’t think access to education (especially education you’ve paid for) should ever be cut off, so all of our workshop recordings are available indefinitely — you can revisit the content as often as you want, for as long as you need.
YES. We love this for you. If you enroll in a short course within six months, or a bootcamp within one year of your workshop, you can apply what you paid for the workshop toward your course. Talk to an admissions specialist to learn more about this — no strings attached.
Think of free classes as the “sample spoon.” No cost, no commitment, and you can try as many flavors as you want. Free classes are two hours long and hosted in a Zoom webinar where participant audio/video is automatically off, and interaction is contained within Zoom chat and Q&A functions. Workshops, on the other hand, are more like the “single scoop.” It costs a little, but you get a lot more. Workshops are six hours of live instruction hosted in a Zoom meeting room where participants can share audio/video and interact live with instructors and classmates.
1 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.

2 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.
Get Started