Relationship and Analysis in Excel:  Power BI Prep Course
Hands-On Instructor Led – 3-hour Session


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


By the end of this course participants will deeper understanding of Advanced Excel tools and prepared for Power BI Fundamentals if required. They will be able to create multiple levels of nested functions, as well as being able to select the proper functions in building and entire project.

Topics will include:

Creating and Formatting basic Charts as well as Chart terminology

  • Creating a chart
  • Formatting a chart
  • Working with Charts

In-Cell Charts and Formatting

  • What is Conditional Formatting
  • How to highlight duplicates
  • How to add colour scales
  • How to add data bars
  • How to add icon sets
  • How to view/edit conditional formatting
  • How to create an in-cell progress bar
  • How to highlight every other row using a formula
  • How to highlight cells based on range

Intermediate Functions

  • Index
  • Match
  • Vlookup

Basic Pivot Table Functionality

  • Sum function
  • Count function
  • Average function
  • Max function
  • Min function
  • Format the results