Microsoft® Excel® 2013: Data Analysis with PowerPivot

Microsoft® Excel® 2013:
Data Analysis with PowerPivot

< Back to Course Catalog

Duration:

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