Advanced Excel: Beyond the Basics
22

Wednesday, 22 May

6:30 9:30 pm EDT

GA Boston

125 Summer Street 13th Floor
Boston, MA 02110
$60 USD
Regular Ticket
$60 USD
Total

Questions? Read our FAQs

Advanced Excel: Beyond the Basics

22

Wednesday, 22 May

6:30 9:30 pm EDT

GA Boston

125 Summer Street 13th Floor
Boston, MA 02110
$60 USD
Regular Ticket
$60 USD
Total

Questions? Read our FAQs

About This Class

In this class, we will move beyond the basics of spreadsheet creation. Topics will include data manipulation/troubleshooting 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 writing basic macros. Class exercises will be utilized to facilitate understanding.

Interested in seeing this class held privately at your organization?
Email us at bospartnerships@ga.co to request more info.

Takeaways

Participants will learn how to effectively streamline and analyze data using some of the more advanced features of Excel including:

  • Data Validation
  • Advanced Functions such as INDEX, MATCH, and SUMIFS
  • Pivot Tables and Pivot Charts

Prospective Topic List:

  • Review of intermediate functions (VLOOKUP, SUMIF, COUNTIF)
  • Date and Time
  • Data Validation (notably drop-down lists)
  • Advanced Functions (INDEX/MATCH, SUMIFS, COUNTIFS)
  • Array formulas
  • Using Slicers with PivotTables and PivotCharts
  • Creating a Dashboard
  • Introduction to Macros

Preparation

This is an 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 functions (VLOOKUP).

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.

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.