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/Investment

Public Course at Softek Private Course at Your Office Private Course at Softek
$325 per student $1400 flat fee up to 8 students $1550 flat fee up to 8 students
or 1 voucher $1600 flat fee up to 12 students $1750 flat fee up to 12 students
10% discount when 3+ attend $100 per additional student $100 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

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 training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee