# Microsoft Excel PowerPivot

Canonical URL: <https://www.careercenters.com/courses/powerpivot-fundamentals>

## Overview

You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

This course is for students with a sound working knowledge of Microsoft Excel and general computing proficiency, including those who will be using Excel to make business decisions.

## What you'll learn

- Become familiar with the PowerPivot application and import data.
- Manipulate data in a PowerPivot worksheet.
- Create reports using PowerPivot data.
- Use DAX functions in PowerPivot.
- Distribute PowerPivot Data.

## 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