Sold Out

Excel Genius Class 4: Pivot Tables

Event Information

Share this event

Date and Time

Location

Location

Hudson Park Library

66 Leroy Street

New York, NY 10014

View Map

Friends Who Are Going
Event description

Description

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data. We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements.

Skills required:

  • Know how to navigate menu options in Excel

  • Understand formatting and conditional formatting

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application. Each class will cover a topic in depth and then give students exercises that apply that knowledge to real world situations.

While we recommend that students take the classes in order, there are no attendance requirements, and students are welcome to repeat or skip classes as they choose.

  • Class 1: Logic Functions
  • Class 2: Charts and Sparklines
  • Class 3: Tables, Structured References, and Data Validation
  • Class 4: Pivot Tables
  • Class 5: Lookup Functions
  • Class 6: Importing Data, String Functions, and Goal Seek

Each Class will have its own set of specific requirements, but all classes will use the following skills:

  • Data Entry

  • Selecting Cells

  • Copy and Paste

  • Formatting Cells

Share with friends

Date and Time

Location

Hudson Park Library

66 Leroy Street

New York, NY 10014

View Map

Save This Event

Event Saved