Excel Bootcamp: Working with Functions & PivotTables

Chicago campuses

GA Chicago @ Rent 24
444 N Wabash Avenue, 5th Floor
Chicago IL 60611

GA Chicago @ 150 N Wacker
150 N Wacker, Suite 2600
Chicago IL 60606

Past Locations for this Workshop

Excel Bootcamp: Working with Functions & PivotTables | Chicago

14
Attend the next event on Saturday, 14 December.

Chicago campuses

GA Chicago @ Rent 24
444 N Wabash Avenue, 5th Floor
Chicago IL 60611

GA Chicago @ 150 N Wacker
150 N Wacker, Suite 2600
Chicago IL 60606

Past Locations for this Workshop

About this workshop

In this one day bootcamp, we will move beyond the basics of spreadsheet creation. We will dive into data manipulation and advanced functions to summarize and analyze data with multiple attributes. We will also introduce using slicers with PivotTables, creating interactive reports, and using advanced formulas. Interactive in-class exercises will be utilized to facilitate understanding.

Agenda

  • Review of Intermediate Functions (VLOOKUP, SUMIF, COUNTIF)
  • Relative and Absolute Cell References within Formulas
  • Date and Time Functions
  • Logical Functions (IF/NESTED IF statements)
  • Advanced Functions (SUMIFS, COUNTIFS)
  • PivotTables and PivotCharts (including Slicers)
  • Named Ranges

Takeaways

Participants will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including: • Advanced Functions • Pivot Tables and Pivot Charts

Prereqs & Preparation

This bootcamp is designed for participants with familiarity of basic features/functions in Excel (i.e. navigation, layout, basic formulas like SUM/COUNT, etc).

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.