Microsoft® Excel® 2013:
Data Analysis with PowerPivot

< Back to Course Catalog

1 Day (6.5 instructional hours)

Excel 2013
Course Number: 091027

Course Objective: You will learn PowerPivot to help you organize, manipulate, and report data.

Target Student: This course is meant for those who are experienced Excel users that are seeking to advance their data analysis capabilities by using PowerPivot.

Course Objective: To ensure success, students will need to be familiar with using or have equivalent knowledge of Microsoft® Office Excel® 2010: Levels 1 & 2, and Microsoft® Office Excel® 2013: Data Analysis with PivotTables.

Course Outline

Lesson 1: Getting Started with PowerPivot

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Lesson 2: Visualizing PowerPivot Data

Topic A: Create a PowerPivot Report

Topic B: Create Calculations in PowerPivot

Lesson 3: Working with Advanced Functionality in PowerPivot

Topic A: Create a Key Performance Indicator

Topic B: Work with Dates and Time in PowerPivot

Ready for training on other Microsoft Office products? Contact ExcelHelp at (800) 682-0882 or visit us online at www.ExcelHelp.com

< Back to Course Catalog