713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

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
  • Learn DAX Functions COUNT, COUNTA, DISTINCTCOUNT and CALCULATE
  • 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

Additional Power BI Courses:



Excel 2016 Training Class Outlines:

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

 

 

 
   
     

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