Managing Data with Formulas Function and Summarize with Pivot Table

Course Objectives

• Become familiar with the PowerPivot application.
• Develop data model while importing data from multiple sources.
• Manipulate data in a PowerPivot worksheet.
• Create reports using PowerPivot data.
• Use DAX functions in PowerPivot.
• Define KPIs (Key Performance Indicators).
• Use slicers to enhance data visualization.

Target Audience

This course is intended for students with a sound working knowledge of Microsoft Excel 2013 and general computing proficiency, including those who will be using Excel to make business decisions.
Before attending this course, students must have:

• Some experience using Excel, including creating and using formulas and some exposure to PivotTables

Course Modules

Module 1: Introduction to PowerPivot 2013
Module 2: Building Data Models
Module 3: Create a PivotTable and PivotChart
Module 4: Use DAX in PowerPivot
Module 5: Enhance PivotTables and PivotCharts