How To Take This Class

Course Overview

PowerPivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel 2016 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.

Course Prerequisites

For the best experience, students should have some experience using Excel, including creating and using formulas and some exposure to PivotTables.

Course Audience

This course is for students with a sound working knowledge of Microsoft Excel 2016 and general computing proficiency, including those who will be using Excel to make business decisions.

What You'll Learn

Upon successful completion of this course, students will be able to:
  • Become familiar with the PowerPivot application and import data
  • 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

Course Duration

1 Day

Course Outline

  1. Getting Started with PowerPivot
    • Enable and Navigate
    • Import Data from Various Data Sources
    • Refresh Data from a Data Source
    • Create Linked Tables
  2. Manipulating PowerPivot Data
    • Organize and Format Tables
    • Create Calculated Columns
    • Sort and Filter PowerPivot Data
    • Create and Manage Table Relationships
  3. Creating PowerPivot Reports
    • Create PivotTables
    • Create PivotCharts
    • Create Power Views
    • Filter Data Using Slicers
    • Present PivotTable Data Visually
  4. Using DAX Functions in PowerPivot
    • Manipulate PowerPivot Data Using DAX Functions
    • Extract Data from Tables Using Functions
    • Work with Time Dependent Data
  5. Distributing PowerPivot Data
    • Protect Reports
    • Save Reports in Different File Formats

What Students Receive

Each student will receive:
  • A printed courseware manual with samples and hands-on exercises for use during and after class.
  • Sample course files and solutions
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2016 PowerPivot Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2016 PowerPivot Training course