Microsoft Excel 2013 PowerPivot Training Course Beginners

Microsoft Excel 2013 PowerPivot Overview

In this Excel PowerPivot training course you will make use of the PowerPivot add-on to import data from various sources and create a dynamic report. You will become familiar with the PowerPivot application and import data as well as learning how to manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data and use DAX functions in PowerPivot. Lastly distribute PowerPivot data.

You will also learn how you no longer need to create measures to use the DAX (Data Analysis Expression) functions.

Other Excel training courses

Course Duration: 1 Day

Course Prerequisites:

A working knowledge of Excel especially with regard to Pivot Tables and an understanding of the following:

• Tables
• Slicers

Course Outline

Getting Started with Microsoft Excel 2013 PowerPivot

• Explore the PowerPivot 2013 Application
• Import Data from Various Data Sources
• Refresh Data from a Data Source
• Create Linked Tables

Manipulating PowerPivot Data

• Organize and Format Tables
• Create Calculated Columns
• Sort and Filter PowerPivot Data
• Create and Manage Table Relationships

Creating PowerPivot Reports

• Create a PivotTable
• Create PivotCharts
• Filter Data Using Slicers
• Present PivotTable Data Visually
• Creating Hierarchies

Using DAX Functions in PowerPivot

• Manipulate PowerPivot Data using DAX Functions
• Extract Data from Tables Using Functions
• Work with Time Dependent Data

Distributing PowerPivot Data

• Protect Reports
• Save Reports in Different File Formats

Live Online Instructor Led Training

1 - 8 Students

£250 + VAT - 3hrs (bespoke)

£500 + VAT - 6hrs (full day*)

* Full training days can be split into 2 sessions

Classroom based Beginners PowerPivot Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the the following form to calculate how much.

Other Microsoft Excel training days you may be interested in:

Microsoft Excel 2013 PowerPivot Training Course - Intermediate Advanced

Microsoft Excel 2013 Training Course - Advanced

Microsoft Excel 2010 PowerPivot Training Course

Microsoft Excel 2010 Training Course - Advanced

Microsoft Excel 2010 VBA Training Course