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
microsoft-excel-seeklogo.com.png

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