In this workshop, we will move beyond the basics of spreadsheet creation. Topics will include data manipulation and advanced functions to summarize and analyze data having multiple attributes. We will also introduce using slicers with PivotTables, creating interactive charts and dashboards, and using advanced formulas.
In-class exercises will be utilized to facilitate understanding. The course is designed for students with familiarity of basic features/ functions in Excel (i.e. navigation, layout, basic formulas like SUM/COUNT, etc). Beginner level students should attend GA’s Excel at Excel: Getting Down the Basics course prior to this workshop.
Students will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including:
Agenda (not necessarily taught in this order)
Prereqs & Preparation:
This is an intermediate/advanced class. Please make sure you have attended GA's Excel at Excel: Getting Down the Basics Class or have a strong familiarity with intermediate Excel functions (VLOOKUP, SUMIF, and COUNTIF).
Still have questions? Ask the community.
General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.
What began as a co-working space in...
This school has been carefully vetted by CourseHorse and is a verified LA educator.
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
(This school does not support a scheduled gift delivery date so if you book the class, the recipient will be notified right away.)