Register Now      202-747-5000

Introduction to Microsoft Excel Power Pivot

365 | 2019 | 2016
1 Day, 9:00-4:00

Course Overview

This course shows you how to use Power Pivot (an Excel add-in) to connect to your enterprise databases, import data from various sources, analyze data, and create dynamic reports in Excel. This course is for students with a sound working knowledge of Microsoft Excel and general computing proficiency, including those who will be using Excel to make business decisions.

Course Objectives

  • Become familiar with the Power Pivot application and import data
  • Manipulate data in a Power Pivot worksheet
  • Use DAX functions in Power Pivot
  • Create reports using Power Pivot data
  • Distribute Power Pivot Data

Course Outline

Getting Started with Power Pivot

  • Explore the Power Pivot Application
  • The Power Pivot Window and Ribbon
  • Power Pivot Worksheets
  • Import Data from Various Data Sources
  • The Table Import Wizard
  • Data Types
  • Importing Data from a Text File, Excel, and Access
  • Refresh Data from a Data Source
  • Refreshable Tables

Manipulating Power Pivot Data

  • Organize and Format Tables
  • Sort and Filter Power Pivot Data
  • Create Calculated Columns
  • Create and Manage Table Relationships
  • Table Relationships
  • Types of Relationships
  • Create Hierarchy

Using DAX Functions in Power Pivot

  • Manipulate Power Pivot Data Using DAX Functions
  • Measures: Implicit and Explicit
  • DAX Functions
  • Extract Data from Tables Using the Related function
  • Work with Time Intelligence Functions
  • TOTALMTD

Creating Power Pivot Reports

  • Create a PivotTable
  • Flattened PivotTables
  • The Power Pivot Field List Pane
  • Create PivotCharts
  • Filter Data Using Slicers
  • Present PivotTable Data Visually
  • Sparklines
  • Key Performance Indicators

Distributing Power Pivot Data

  • Protect Reports
  • Workbook Protection
  • Worksheet Protection
  • Secure a PivotTable
  • Save Reports in Different File Formats
  • TOTALYTD

 

Cost and Delivery Format Options

We offer the above listed class on our public schedule and as a private group class in the following delivery formats:

Public Class: Live Virtual or at Softek
Per student $325
Private Group Class: Live Virtual
1-4 students $950
5-8 students $1400
9-12 students* $1600
*$100 per additional student
Private Group Class: At Your Location or Softek
1-4 students $1100
5-8 students $1550
9-12 students* $1750
*$100 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $125 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person and virtual training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee