Houston, Texas

San Antonio, Texas

Course Links

training schedule
  •  Houston
  •  San Antonio
training schedule
training schedule


training schedule
training schedule
training schedule




Excel In-Depth:
Introduction to PowerPivot (PowerPivot Part 1)

Training Course Content (1 Day)

Course Objective: In this course, students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Prerequisites: To ensure your success, we recommend that you first take Excel Level 1, Level 2, and Excel PivotTables, or have equivalent knowledge and skills - such as a strong understanding of PivotTable, PivotCharts, Tables and the use of intermediate to advanced Excel functions.

Contact us to discuss if this class is right for you.

Lesson 1: Get Started with PowerPivot

  • Explore the PowerPivot Application
  • Import Data from Various Data Sources like Excel, Access or a Text file
  • Refresh Data from a Data Source
  • Create Refreshable Tables

Lesson 2: Manipulate PowerPivot Data

  • Organize and Format Tables
  • Create Calculated Columns
  • Sort and Filter PowerPivot Data
  • Work with Table Relationships and the Data Model

Lesson 3: Create PowerPivot Reports

  • Create PivotTables from PowerPivot
  • Create PivotCharts from PowerPivot
  • Filter Data Using Slicers
  • Present PivotTable Data Visually

Lesson 4: Introduction to DAX Measures in PowerPivot

  • Differences between Calculated Columns and DAX Measures
  • Create and Manage Measures
  • Manipulate PowerPivot Data Using DAX Measures

Lesson 5: Perform Date and Time Sensitive Calculation in PowerPivot

  • Create a Date Table
  • Work with Time Dependent Data
  • Handle Fiscal and Calendar Periods
  • Use Time Intelligence Functions DATESYTD, DATESQTD, DATESMTD and DATEADD

Lesson 6: Distributing PowerPivot Data

  • Load Data Model to Power BI
  • Load Excel File to Power BI

Excel 365 Training Course Outlines

Excel 365 Core Features & Functions:

Excel 365 LV 1: Fundamentals of Excel
Excel 365 LV 2: Intermediate Functions & Features
Excel 365 LV 3: Advanced Tools &
Collaboration Features

Excel 365 LV 4: Advanced Functions

Excel 365 New Functions & Features:

Excel 365: New Functions & Formulas
Excel 365: New Features

Excel VBA Macros:

Excel 365 LV 5: Introduction To VBA Macros
Excel 365 LV 6: Advanced VBA Macros

Excel In-Depth Essentials:

Excel In-Depth: Charting Essentials
Excel In-Depth: PivotTable Essentials
Excel In-Depth: Advanced Excel Keyboarding

Excel Power Tools:

Excel Get & Transform (PowerQuery)
Excel PowerPivot Part 1
Excel PowerPivot Part 2




                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |