top of page

Microsoft Excel Power Tools

Learn how to use the set of Power tools for powerful data analysis and data modelling in Microsoft Excel. With PowerPivot, you can mash up large volumes of data from various sources, perform information analysis rapidly and share insights easily. 


Course Modules

The following modules can be covered on the course. Not all features/modules available on all versions of Excel

Course format: one day, max capacity 6

Wireless Computer Accessories

Session Topics


Building Excel Data Models with Power 
Query / Get & Transform

  • Import data from a Variety of Sources

  • Connect, Transform, Combine and 

  • Share Data

  • Share Queries to the Power Bi Data 

  • Catalogue

  • View and manage Queries  


Power Pivot

  • Create Data Models

  • Create Relationships between Tables

  • Add Calculated Columns

  • Create Hierarchies

  • Create Pivot Tables/Charts from Power 

  • Pivot Data

  • Create a measure and KPI

  • Create a Perspective


Data Analysis Expressions (DAX)

  • What is DAX?

  • DAX Syntax

  • DAX Functions

  • DAX Context

  • Creating Dax Expressions


Publishing Power Data

  • Publish to Power Bi

bottom of page