ComputerImages
Course Descriptions

Excel Power Pivot Class

What You Will Learn

This class shows you how to use Excel’s Power Query and Pivot features combines the data handling power of a relational database with the analytical capability of Pivot Tables. Class discussion and exercises cover —

  • What the Power Query and Power Pivot tools do and how to make sure they are available on your copy of Excel,
  • Using Power Query to access data, both in Excel and external sources, for analysis in Excel,
  • Creating, editing and reusing queries,
  • Using Power Query to prepare data for analysis by adding calculated columns, parsing data into several columns (for example splitting city, state and zip code that are in a single column, and combine data from several tables into one,
  • How relationships enable one to use data from several tables together without merging them, for example wage rates in one table and hours worked in another,
  • How to begin a new Data Model and decide what information it should contain and what its structure should be,
  • Adding tables to the Data Model,
  • Building relationships between tables and how relationships are different from and better than VLOOKUPs,
  • Defining and managing data measures and KPI,
  • Using DAX functions, which are similar to regular Excel formula functions, but include special function that are useful in data analysis, such as functions that automatically make period-to-period comparisons, such as month this year versus last year,
  • Building Pivot Tables and Pivot Charts from a Data Model.

6 hours, $260 (available for Windows only)

Training Format

  • Live trainer in room — not on-line or remote learning,
  • Exercise-based, hands-on classroom instruction,
  • Emphasis on questions and student participation,
  • Small size (limited to 8), personal attention.

Class Location

Dates and Registration

Prerequisites

A working knowledge of Excel, especially how to create and edit formulas, use functions and build basic Pivot Tables.

Related Classes

Classes: Excel, Advanced Excel, Excel Dashboards, Excel Macros and Excel Pivot Tables.

We also offer consulting, private classes and one-on-one training. See Excel Services page for more information.

Mailing List and Further Information

Monthly newsletter and schedule: join our Mailing List.
For more information, please contact us.

Class Schedule · ComputerImages Excel Resources · Excel Support Links · Excel Tips

© Copyright 2019, ComputerImages. All rights reserved.
URL: www.computerimages.com /course_descriptions / excel-power-pivot-training-class.html
Excel Power Pivot Course Outline, Updated July 31, 2019.