Prerequisites
To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.
Goals
Master everything related to Pivot Tables. Create Reports and deal with PT problems.
Excel Pivot Tables Topics
- Understanding Pivot Tables
- Source data for Pivot Table reports
- Creating Worksheet Lists
- Using a Name in a Formula
- Creating Names for a Multiple Rows or Columns
- Creating Names for a Value or Formula
- Creating a Pivot Table
- Pivot Table Field List
- Pivot Table Tools
- Rearranging the Pivot Table
- Changing the Report Field Titles
- Formatting Data Fields
- Using the Report Filter
- Displaying Filtered Fields on Separate Worksheets
- Formatting the Pivot Table
- Sorting Data
- Using Formulas Functions
- Create a Calculated Field
- Add or remove subtotals in a Pivot Table report
- Display or Hide Details
- Working with Multiple Data Ranges
- Setting up the source data
- Creating Pivot Charts
- Using Pivot Table Data Outside the Pivot Table Report
- Create relationships between data from different sources
- Creating a Pivot Table from a Database
