Excel Bootcamp (Santa Monica)

Los Angeles campuses

GA Los Angeles (DTLA)
360 E. 2nd Street, Suite 400
Los Angeles CA 90012

GA Los Angeles (Santa Monica)
1520 2nd Street
Santa Monica CA 90401

Past Locations for this Class

Excel Bootcamp (Santa Monica)

Los Angeles

Los Angeles campuses

GA Los Angeles (DTLA)
360 E. 2nd Street, Suite 400
Los Angeles CA 90012

GA Los Angeles (Santa Monica)
1520 2nd Street
Santa Monica CA 90401

Past Locations for this Class

About this class

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.

Takeaways

Students will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including:
• Advanced Functions such as INDEX, MATCH, and SUMIFS
• Pivot Tables and Pivot Charts
• Interactive Dashboards

Agenda (not necessarily taught in this order)
• Review of Filtering, Sorting, and Conditional Formatting
• Review of Intermediate Functions (VLOOKUP, SUMIF, COUNTIF)
• Relative and Absolute Cell References within Formulas
• Date and Time Functions
• Logical Functions (IF/NESTED IF statements)
• Data Validation (notably drop-down lists)
• Advanced Functions (INDEX/MATCH, SUMIFS, COUNTIES)
• Charts and Graphs
• PivotTables and PivotCharts (including Slicers)
• Tables and Named Ranges
• Creating Interactive Dashboards

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)

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.