Microsoft Excel 2013 PowerPivot Training Course Beginners

Beginners Microsoft Excel 2013 PowerPivot Course 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 Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

Complete 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

Have a look at our range of Excel Training Courses

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