713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas

>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

Microsoft® Office Excel: PowerPivot

Available Courses:


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

Training Course Content (3.5 hours)

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 Level 3, 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.

  • Excel 2016, 2013 and 2010 users: Please note that our standard class is currently taught using version 2013 due to the similarities between versions.

Lesson 1: Getting Started with PowerPivot

  • Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables

Lesson 2: Manipulating PowerPivot Data

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

Lesson 3: Creating 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

  • Using Calculated Columns with Measures
  • Manipulate PowerPivot Data Using DAX Measures

Lesson 5: Distributing PowerPivot Data

  • Protect Reports
  • Save Reports in Different File Format

Excel In-Depth:
PowerPivot DAX Measures and Calculations (PowerPivot Part 2)

Training Course Content (3.5 hours)

Course Objective: In this course, students will build on the skills learned in PowerPivot Part 1 by using calculations and measures to enhance PowerPivot reporting.

Prerequisites: PowerPivot Part 1 or equivalent knowledge is required prior to enrolling in class, as well as having a strong understanding of PivotTables, PivotCharts, Tables and the use of intermediate to advanced Excel functions.

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

  • Excel 2016, 2013 and 2010 users: Please note that our standard class is currently taught using version 2013 due to the similarities between versions.

Lesson 1: Introducing DAX Calculations for PowerPivot

  • Creating Calculated Columns, Calculated Fields and Measures
  • Understanding DAX Formulas and Syntax
  • Working with Common DAX Functions

Lesson 2: Performing Date and Time Sensitive Calculation in PowerPivot

  • Creating a Calendar Table
  • Working with Time Dependent Data
  • Handling Fiscal and Calendar Periods
  • Using Common Time Intelligence Functions
  • Bonus: Students will be provided with an Excel Calendar Table creation tool for after class use.

Lesson 3: Advanced DAX Functions

  • Handling Errors in DAX
  • Understanding How Drop Zones Affect Measures
  • Respecting and Ignoring the Filters
  • Working with Advanced DAX Functions
  • Extracting Data from Tables Using Functions

Upcoming Courses:

  • Introduction to Excel Power View
  • Introduction to Excel Power Map
  • Introduction to Excel Power Query

Excel 2010 Training Class Outlines:

Excel 2010 Level 1: Fundamentals of Excel
Excel 2010 Level 2: Intermediate Functions and Features
Excel 2010 Level 3: Advanced Tools and Collaboration Features
Excel 2010 Level 4: Advanced Formulas and Functions
Excel 2010 Level 5: Introduction To VBA Macros
Excel 2010 Level 6: Advanced VBA Macros

 

 

 
   
     

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