Login / Register

MOS Microsoft Office Excel 2010 PowerPivot

You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.
Course Prerequisites:
To ensure your success, we recommend you first take one of the following CTU courses or have equivalent knowle... Show More
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.


1 Day

Course Content

MOS: Microsoft Office Excel 2010 PowerPivot

1 Day
Lesson 1: Getting Started with PowerPivot
Topic 1A: Explore the PowerPivot Application
Topic 1B: Import Data from Various Data Sources
Topic 1C: Refresh Data from a Data Source
Topic 1D: Create Linked Tables

Lesson 2: Manipulating PowerPivot Data
Topic 2A: Organize and Format Tables
Topic 2B: Create Calculated Columns
Topic 2C: Sort and Filter PowerPivot Data
Topic 2D: Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports
Topic 3A: Create a PivotTable
Topic 3B: Create PivotCharts
Topic 3C: Filter Data Using Slicers
Topic 3D: Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot
Topic 4A: Manipulate PowerPivot Data Using DAX Functions
Topic 4B: Extract Data from Tables Using Functions
Topic 4C: Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data
Topic 5A: Protect Reports
Topic 5B: Save Reports in Different File Formats

CTU Training Solutions , Updated: April 24th, 2018

Share with friends

Request a Quote

Your Name

Your Surname

Contact Number

Your Email


Which campus would you like to study at?

Your job title

Will your training be sponsored?


The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

Join the CTU community

Join the CTU Community Portal and gain access to superior resources.

Join for Free

Thank you for printing this page.
0861 100 395
[email protected]


Call me Back

Leave your details and we'll contact you back!

Your Name:

Your Email:

Contact Number:

Choose a campus