Microsoft Excel 2013 PowerPivot Training

How To Take This Class

Live Instructor-Led Online Class

Cost: $325.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

1 Day

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 2013 PowerPivot Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2013 PowerPivot Training course

Course Description

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 2013 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 Objectives

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 Audience

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

Course Prerequisites

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

Course Syllabus

  1. Introduction to PowerPivot 2013
    • Review PowerPivot 2013
      • Exercise 1-1 Enable PowerPivot
    • Explore the PowerPivot Workspace
      • Manage Data Model Button
      • Calculations Group
      • Calculated Fields
      • KPIs
      • Slicer Alignment Group
      • Tables
      • Detect Relationships
      • Settings
    • Compare Excel and PowerPivot
  2. Building Data Models
    • Review Data Models
    • Create Data Models
      • Manage Data Model
        • Clipboard
        • Get External Data
        • Refresh
        • PivotTable
        • Formatting
        • Sort and Filter
        • Find
        • Calculations
        • View
      • Exercise 2-1 Import Data from Access
      • Exercise 2-2 Import Data Using Copy and Paste
      • Exercise 2-3 Import Data Using a Text file
      • Exercise 2-4 Import Data Using an Excel File
      • Exercise 2-5 Explore Manage Data Model Tab
      • Exercise 2-6 – Refresh the Data
  3. Create a PivotTable and PivotChart
    • Determine Chart or Table?
    • Create a PivotTable
      • PivotTable Fields
      • Exercise 3-1 Create your First PivotTable
    • Analyze
      • PivotTable
      • Active Field
      • Group
      • Filter
      • Data
      • Actions
      • Calculations
      • Relationships
      • Tools
      • Show
      • Exercise 3-2 Use the Analyze tab to change your PivotTable
    • Design
      • Layout
      • PivotTable Style Options
      • PivotTable Styles
      • Exercise 3-3 Use the Design tab to change your PivotTable
    • Create a PivotChart
      • PivotChart Fields
      • Exercise 3-4 Create your first PivotChart
    • Analyze
      • PivotChart
      • Active Field
      • Filter
      • Data
      • Actions
      • Calculations
      • Show/Hide
      • Exercise 3-5 Use the Analyze tab to change your PivotChart
    • Design
      • Chart Layouts
      • Chart Styles
      • Data
      • Type
      • Location
      • Exercise 3-6 Use the Design tab to change your PivotChart
    • Format
      • Current Selection
      • Insert Shapes
      • Shape Styles
      • WordArt Styles
      • Arrange
      • Size
      • Exercise 3-7 Use the Format tab to change your PivotChart
  4. Use DAX in PowerPivot
    • Review DAX
      • DAX Operators
      • Functions
      • Text Functions
      • Date and Time Functions
      • Logical Functions
      • Statistical Functions
      • Informational Functions
      • Math and Trigonometric Functions
      • Filter Functions
      • Time Intelligence Functions
    • Context in DAX Formulas
    • Define Calculated Columns
      • Exercise 4-1 Create a calculated column with data in the same table.
      • Exercise 4-2 Create calculated columns with data from different tables.
    • Define Calculated Fields
      • Implicit Calculated Field
      • Explicit Calculated Field
      • Exercise 4-3 Create calculated fields.
  5. Enhance PivotTables and PivotCharts
    • Define Key Performance Indicators (KPIs)
      • Exercise 5-1 Create a KPI and use in a PivotTable.
    • Define Slicers
      • Slicer Tools Options
      • Exercise 5-2 Create Slicers.
    • Define Hierarchies
      • Exercise 5-3 Create Hierarchies