Microsoft Excel 2010: PowerPivot

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

SKU	084606SEB
Weight	0.0000
Coming Soon	N/A
Days of Training	.5
Audience	Student
Product Family	Select
Product Type	Digital Courseware
Electronic	Yes
ISBN	No
Language	English
Page Count	No
Curriculum Library	Excel
Year	2010
Manufacturer's Product Code	N/A

Current Revision	1
Revision Notes	No Revision Information Available
Original Publication Date	2011-12-13 00:00:00