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.
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: Conditional Stat Functions
- Class 3: Charts and Sparklines
- Class 4: Tables, Structured References, and Data Validation
- Class 5: Pivot Tables
- Class 6: Lookup Functions
- Class 7: Importing Data, String Functions, and Goal Seek
Class Requirements:
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
Class 5: Pivot Tables
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