Microsoft Office Excel 2016: Data Analysis with Power Pivot

Microsoft Office Excel 2016: Data Analysis with Power Pivot

Course Length: 1 day
Delivery Methods: Available as private class only
Course Benefits
  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.
Course Overview

In this Data Analysis with Power Pivot training class, students will learn to use Power Pivot to organize, manipulate, and report on data in the best way possible.

This course is intended for experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

This is class is 4 hours of instruction.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

Microsoft Silver Certified Partner
Course Outline
  1. Getting Started with Power Pivot
    1. Enable and Navigate Power Pivot
    2. Manage Data Relationships
  2. Visualizing Power Pivot Data
    1. Create a Power Pivot Report
    2. Create Calculations in Power Pivot
  3. Working with Advanced Functionality in Power Pivot
    1. Create a Key Performance Indicator
    2. Work with Dates and Time in Power Pivot
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Office class:

  • Experience working with Excel 2016 and PivotTables.
  • Understanding of spreadsheet concepts and comfort creating basic PivotTables.