Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Microsoft Excel Power Pivot

Version 2010 • 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

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

 

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 PowerPivot

  • 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
  • TOTALYTD

 

 

Creating Power Pivot Reports

  • Create a PivotTable
  • Flattened PivotTables
  • The PowerPivot 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

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

 

Investment

Public Class

$325 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$1400 flat fee for up to 8 students
$1600 flat fee for up to 12 students
$100 per additional student

Conducted at Softek’s Facility

$1550 flat fee for up to 8 students
$1750 flat fee for up to 12 students
$100 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Why choose Softek?

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