Microsoft® Excel® 2013:
Data Analysis with PowerPivot
1 Day (6.5 instructional hours)
Course Number: 091027
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.
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.
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