# PowerPivot Fundamentals

Canonical URL: <https://training-nyc.com/courses/powerpivot-fundamentals>

## Overview

This PowerPivot group class concentrates on how to create powerful Pivot Tables through multiple table relationships.

By the end of the Excel PowerPivot training course, you will feel confident setting up relationships, creating and displaying complex Pivot Tables and using Calculated DAX columns.

This class is perfect for those that have a fundamental understanding of Excel and using Excel Pivot tables and want to see more correlation between data. Those in the financial, real-estate or data analysis field will especially find this class enjoyable.

## What you'll learn

- Benefits of PowerPivot    
- Creating Relationships
- Creating 4 or more related pivot tables
- Asymmetrical Reports

## Curriculum

#### Why PowerPivot?

#### Benefits of PowerPivot

#### Installing PowerPivot

#### Overview of PowerPivot Ribbon

#### Working with Different Data Sources

#### Importing Data

#### Creating Relationships

#### Linking Tables

#### Calculated Columns

#### Difference Between Excel's Compact Pivot Tables and Power Pivot's Flat File Tables

#### Using Slicers

#### Creating 4 or More Related Pivot Tables

#### Available Functions and Their Power

#### Advanced Filtering

#### Asymmetrical Reports

#### Other PowerPivot Capabilities

## Pricing

**Tuition:** $299