Microsoft® Excel® 2010: PowerPivot

Course Specifications

Course number: 084606
Course length: 1.0 day(s)

Course Description

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

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

Prerequisites: To ensure your success, we recommend you first take one of the following Element K courses or have equivalent knowledge: Microsoft® Excel® 2010: Level 1, Microsoft® Excel® 2010: Level 2, and Microsoft® Excel® 2010: Level 3.

Hardware Requirements

For this course, you will need one computer for each student and one for the instructor. Each computer will require the following minimum hardware configuration:

Software Requirements

Each computer requires the following software:

Course Objectives

Upon successful completion of this course, students will be able to:

Course Content

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