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: 
•	A PC with a Pentium® processor, at least 300 MHz.
•	10 GB of hard disk space or larger. You should have at least 1 GB of free hard disk space available for Office installation. 
•	A minimum of 64 MB of RAM with 1 GB of free hard disk space.
•	A CD-ROM drive.
•	Keyboard and mouse or other pointing device.
•	1024 x 768 resolution monitor is recommended.
•	Network cards and cabling for local network access.
•	Internet access (contact your local network administrator).
•	A printer (optional) or an installed printer driver.
•	A projection system to display the instructor’s computer screen. 
Software Requirements
Each computer requires the following software:
•	Microsoft® Office Professional Plus 2010 Edition
•	Microsoft® Windows 7 (Professional Edition)
•	PowerPivot for Excel
•	Adobe® Reader®
Course Objectives
Upon successful completion of this course, students will be able to: 
•	become familiar with the PowerPivot application and import data. 
•	manipulate data in a PowerPivot worksheet.
•	create reports using PowerPivot data.
•	use DAX functions in PowerPivot.
•	distribute PowerPivot Data.
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