POWERPIVOT FOR EXCEL – ONE DAY WORKSHOP

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Advanced Level.

Goals

Combining data from multiple sources and files into one single data model. Create relationships, hierarchies and DAX functions.

Excel PowerPivot Topics

  1. Explore the PowerPivot Application
  2. Accessing the PowerPivot add-in
  3. Navigating the interface
  4. Working with Data
  5. Import Data from Various Data Sources
  6. Refresh Data from a Data Source
  7. Manage Data Model
  8. Create Relationships
  9. Manipulating PowerPivot Data
  10. Sort and Filter PowerPivot Data
  11. Working with Tables
  12. Create Linked Tables
  13. Organize and Format Tables
  14. Create Calculated Columns
  15. Extract Data from Tables Using Functions
  16. Create and Manage Table Relationships
  17. Creating PowerPivot Reports
  18. Using DAX Functions in PowerPivot
  19. Manipulate PowerPivot Data Using DAX Function
  20. Key Performance Indicators (KPI)
Share This Post
Have your say!
1 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>