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