you will be introduced to flat and relational files, best practices, the Data Model, the OLAP and other key OLAP functions of the Pivot Table.

These new capabilities improve performance and reduces users’ time when preparing data for further analysis work or reports from a single or multiple data sources.

• create, manage and operate the Pivot Table on flat files and across files in relational databases. 

You will also acquire a working understanding of the Excel Data Model and the difference between conventional Pivot Table functions from the OLAP Pivot Table.

Module 1: The Excel Table
What is a flat file?
Overview of the Excel Table
Creating the Table
Filtering & sorting the Table
The Table Ribbon
Naming & resizing the Table
Table styles
Inserting slicers
Inserting formulas in the Table
Best practices on maintaining good data

Module 2: Introduction to the Pivot Table
Creating the Pivot Table
Populating Rows, Values, Columns & Filters
Formatting values in the Pivot Table
Pivot Table subtotals & grand totals
Pivot Table Report Layout & Styles
Components in Pivot Table Options
Renaming the Pivot Table
Drilling down into data

Module 3: Filtering & Sorting
Date filters, Label filters & Value filters
Sorting items in Pivot Table in an ascending or descending order
Slicers & Timeline
Filter Connections
Module 4: Calculated Fields & Items
How to insert a Calculated Field
Calculated Field behavior

Module 5: Pivot Charts
What is a Pivot Chart?
Creating a Pivot Chart
Pivot Chart rules and design
Managing the underlying data, adding layers and altering structure
Dynamic Charts

Module 6: Retrieving & summarizing data from the Pivot Table
Introduction to the GETPIVOTDATA Function
Drop-down lists & variance analysis

Module 7: Managing Changes in Your Source Data
Dynamic Named Ranges
Dealing with zeroes

Module 8: Business Intelligence overview
What is BI
The OLAP & relational databases
What is the OLAP Pivot Table
The Data Model

Module 9: The OLAP Pivot Table
Introduction to the CUBEVALUE & CUBEMEMBER Function
Pivot Table relationships
Pivot Table Sets

Module 10: Creating and Managing Sets
Creating & managing sets based on row or column items

Hands-on, step-by-step application on Pivot Table using contrived data.