Training: Excel – PowerPivot

Ref. MOE-44

Download PDF

Duration:

2

days

Exam:

Not certifying

Level:

Expert

Funding:

Eligible

Home > Trainings > Office Automation > Spreadsheet > Excel – PowerPivot

Description

This course teaches how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports.

Participant Profiles

Advanced Excel users
Users that want to gain familiarity with PowerPivot to build compelling reports

Objectives

Explore every aspect of using Microsoft PowerPivot

Prerequisites

General Excel and Report building skills
To have the equivalent knowledge or to have followed the trainings: Excel – Preparing for data analysis and Excel – Analyze your data

Course Content

Module 1: Introduction to PowerPivot

Adding the PowerPivot Add-In to Excel
Introduction to PowerPivot

Module 2: PowerPivot Data Sources

Importing Excel and Access files
Importing CSV files

Module 3: Creating Reports with PowerPivot

Creating Pivot Tables
Modifying the Pivot Table Structure
Setting up row, column, page and data fields
Creating grouping criteria
Creating calculated fields
Automatic sorting and filtering
Using segments
Formatting the pivot table
Pivot charts

Module 4: Performance Indicators (KPI)

Creating a calculated field
Creating a KPI
Modifying a KPI
Use in pivot tables

Module 5: Advanced DAX functions

Using DATE and TIME functions
Using STATISTICAL functions
Using VALUE functions
Using LOGICAL and INFORMATION functions
Using TEXT functions

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Explore all our Microsoft Office courses by clicking here