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