The Winter Sale is going on now!

Take an additional 25% off using coupon code 25OFF

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Perfect for analysts who work in finance and accounting, business intelligence, research and information technology.

The Advanced XL Dashboards Bundle includes everything you need to save time, visualize data, and drive business decisions in your role.

  • Save on 7 Advanced Excel Modules! Formulas, Data Visualization, Pivot tables, Power Query, Power BI, DAX, and Dashboards! (Sold separately at $147 each - save by bundling over 50% in this bundle)

  • That's... 31 Excel & Power BI Training Modules, 7+ hours of content

  • 24+ Plug-n-Play Worksheets  -- walk through the training videos with me, then use what you've learned immediately! 

  • 12 Step-by-Step  Guides -- showing you exactly what to do 

  • 4 Industry Guides: The Principles of Data Visualization, Table & Chart Design Guide, the Power Query Action Reference, and Commonly Used DAX Functions Reference

Pricing options

Choose the pricing option that works best for you.

What others are saying...


"ONE OF THE BEST AND UNIQUE LEARNING EXPERIENCES!"

I work as a CFO in a large FMCG. A part of my job is to provide regular insights and analysis to the management regarding different functions and areas in the organization.

One of the great things about the courses taught here is that they are unique and teach you to work differently and think outside the box. The methods explain are fairly simple and yet so powerful it almost seems unreal.

I love the way how Jordan explains different topics while bringing the students up to speed with what he is trying to explain. His method is very engaging and simple. I like how he takes time to go into detail explaining different ideas.

ABDUL HASEEB, CFO

"WE CANNOT THANK JORDAN ENOUGH FOR THE COURSE HE PROVIDED!"
Working in the fashion retail company as part of the support office to our stores, we are working with a heavy focus especially using excel.

He strategically helped us navigate all of the potential that excel has to offer to take our analysis and worksheets to the next level!
The group loved how Jordan kept them engage.

I would recommend this class a million times over to anyone looking to really pushing themselves to learn what is possible with excel.
I would recommend this course to those who want to be able to communicate with their data.


Thank you Jordan!

NICOLE SISTO, Office Manager, H&M 


Do I have to start on a certain day?

This is a self-paced course. You can start whenever you'd like. This course is designed to be completed over the course of 12 weeks. But I recommend you learn at your own pace. 


Course curriculum

  • 1

    Advanced Formulas 000 - Introduction

    • Advanced Formulas 001 - What You'll Learn

    • Advanced Formulas 002 - Class Files

  • 2

    Advanced Formulas 100 - Lookup Functions

    • Advanced Formulas 101 - Lookup Functions File

    • Advanced Formulas 102 - VLOOKUP Explained

    • Advanced Formulas 103 - XLOOKUP Explained

    • Advanced Formulas 104 - INDEX/MATCH Explained

    • Advanced Formulas 105 - XLOOKUP Chart Demo

  • 3

    Advanced Formulas 200 - Decisions functions

    • Advanced Formulas 201 - Decision Functions File

    • Advanced Formulas 202 - What Are Conditional Booleans?

    • Advanced Formulas 203 - IF Explained

    • Advanced Formulas 204 - IFS Explained

    • Advanced Formulas 205 - CHOOSE Explained

    • Advanced Formulas 206 - SWITCH Explained

    • Advanced Formulas 207 - SUMIF & COUNTIF Explained

    • Advanced Formulas 208 - Facebook Chart Demo

  • 4

    Advanced Formulas 300 - New Excel Functions

    • Advanced Formulas 301 - New Functions File

    • Advanced Formulas 302 - UNIQUE Explained

    • Advanced Formulas 303 - FILTER Explained

    • Advanced Formulas 304 - TEXTJOIN Explained

    • Advanced Formulas 305 - LET Explained

  • 5

    Advanced Formulas 400 - Advanced Formula Tools

    • Advanced Formulas 401 - Named Ranges Explained

    • Advanced Formulas 402 - What To Know About Named Ranges

    • Advanced Formulas 403 - Using Named Ranges

    • Advanced Formulas 404 - Excel Tables Explained

    • Advanced Formulas 405 - Table Advanced Filters

    • Advanced Formulas 406 - Advanced Formula Tools File

  • 6

    Advanced Formulas 500 - Wrap Up

    • Advanced Formulas 501 - Wrap-up

  • 7

    Data Visualization 100 - Course Introduction

    • Data Visualization 101 - Welcome!

  • 8

    Data Visualization 200 - Introduction To Data Visualization

    • Data Visualization 201 - Data Visualization Presentation + Guides

    • Data Visualization 202 - Data Visualization Principles

    • Data Visualization 203 - Data Graphics & Info Graphics

    • Data Visualization 204 - Design Guidelines For Tables & Charts

  • 9

    Data Visualization 300 - Set Up Excel For This Class

    • Data Visualization 301 - Enabling The Developer Tab & Camera Tool

  • 10

    Data Visualization 400 - Applied Data Visualization In Excel

    • Data Visualization 401 - File For Sparklines And Heatmaps

    • Data Visualization 402 - Sparklines Explained

    • Data Visualization 403 - Implementing Heatmaps

    • Data Visualization 404 - File For KPI Charts

    • Data Visualization 405 - Visualizing KPIs - Chart 1

    • Data Visualization 406 - Visualizing KPIs - Chart 2

    • Data Visualization 407 - Visualizing KPIs - Chart 3

    • Data Visualization 408 - File For Infographics

    • Data Visualization 409 - Infographics in Excel

  • 11

    Data Visualization 500 - Interactive Data And Decision Support In Excel

    • Data Visualization 501 - File For Check Box Dashboard

    • Data Visualization 502 - Implementing the Checkbox Dashboard

    • Data Visualization 503 - File For Tornado Dashboard

    • Data Visualization 504 - Implementing the Tornado Drilldown Dashboard

  • 12

    Pivot Tables 000 - Introduction To Pivot Tables

    • Pivot Tables 001 - Welcome!

  • 13

    Pivot Tables 100 - Working with Pivot Tables

    • Pivot Tables 101 - Intro To Pivot Table File

    • Pivot Tables 102 - Pivot Tables Explained

    • Pivot Tables 103 - Working With Pivot Tables File

    • Pivot Tables 104 - Counting With a Pivot Table

    • Pivot Tables 105 - Averaging With a Pivot Table

    • Pivot Tables 106 - Sum By Quarter

    • Pivot Tables 107 - Running Totals

    • Pivot Tables 108 - Month over Month Analysis

  • 14

    Pivot Tables 200 - Pivot Table Tips & Tricks

    • Pivot Tables 201 - Pivot Table Tips & Tricks File

    • Pivot Tables 202 - Pivot Table Tips

    • Pivot Tables 203 - Slicers

    • Pivot Tables 204 - Timelines

    • Pivot Tables 205 - Pivot Charts

  • 15

    Pivot Tables 300 - Pivot Table Data Model Dashboard

    • Pivot Tables 301 - Data Model Dashboard Files

    • Pivot Tables 302 - What Is The Data Model

    • Pivot Tables 303 - Creating the Pivot Table Dashboard using the Data Model

  • 16

    Power Query 000 - Intro To Power Query

    • Power Query 001 - Introduction

    • Power Query 002 - A short history of Power Query

  • 17

    Power Query 100 - Power Query Tour

    • Power Query 101 - Problem Description

    • Power Query 102 - Download Step-By-Step Guide And Data

    • Power Query 103 - Data Wrangling Steps

    • Power Query 104 - Applied Steps

    • Power Query 105 - What Is M Code And Where To Find It

    • Power Query 106 - Tour Of Power Query Features

    • Power Query 107 - Using Column From Example

    • Power Query 108 - Sending Feedback To Microsoft

    • Power Query 109 - BONUS: Power Query Feature Guide

  • 18

    Power Query 200 - Merging Data

    • Power Query 201 - Intro To Merging Data Case Study

    • Power Query 202 - Download Step-By-Step Guide And Data

    • Power Query 203 - Merge Query

  • 19

    Power Query 300 - File From Folder

    • Power Query 301 - File From Folder

    • Power Query 302 - Required Files, Data And Guide

    • Power Query 303 - Description Of Case Study

    • Power Query 304 - Editing The Sample File

  • 20

    Power BI 000 - Introduction

    • Power BI 001 - What is Power BI?

  • 21

    Power BI 100 - NYC - Link Cameras

    • Power BI 101 - Introduction - Problem Description

    • Power BI 102 - Dashboard File, Data & Guide

    • Power BI 103 - Connecting To Data Set (Web)

    • Power BI 104 - Connecting to Dataset (csv)

    • Power BI 105 - Using Power Query in Power BI

    • Power BI 106 - Adding Visuals to the Report Tab

  • 22

    Power BI 200 - Retail Database Example

    • Power BI 201 - Introduction - Problem Description

    • Power BI 202 - Dashboard Files, Data & Guide

    • Power BI 203 - Using Power Query to gather the Data

    • Power BI 204 - Connecting Datasets + Filter Context

  • 23

    Power BI 300 - Visuals

    • Power BI 301 - Introduction

    • Power BI 302 - File For Visualization Tour

    • Power BI 303 - Map Visual Explained

    • Power BI 304 - Table Visual Explained

    • Power BI 305 - Matrix Visual Explained

    • Power BI 306 - Treemap Visual Explained

    • Power BI 307 - Bar & Column Chart Visuals Explained

    • Power BI 308 - Line & Area Charts Visuals Explained

    • Power BI 309 - Cards & Multirow Card Visuals Explained

    • Power BI 310 - Slicers Explained

    • Power BI 311 - Drilldowns Explained

    • Power BI 312 - AppSource Marketplace

    • Power BI 313 - Question & Answer Visual

  • 24

    DAX 000 - Introduction to DAX

    • DAX 001 - Introduction to DAX

    • DAX 002 - BONUS: DAX Reference Guide

  • 25

    DAX 100 - Calculated Columns

    • DAX 101- Calculated Column Example

    • DAX 102 - Download Lesson Dashboard, Data And Guides

    • DAX 103 - VAR RETURN Explained

    • DAX 104 - Implied Vs Explicit Measures

  • 26

    DAX 200 - Measures

    • DAX 201 - Filter Context And VertiPaq

    • DAX 202 - Download Lesson Dashboard, Data And Guides

    • DAX 203 - Calculated Columns Comparison

    • DAX 204 - CALCULATE Explained

    • DAX 205 - Staying Organized with Measures

  • 27

    DAX 300 - Time Intelligence

    • DAX 301 - Download Lesson Dashboard, Data And Guides

    • DAX 302 - Using SAME PERIOD LAST YEAR

    • DAX 303 - Conditional Formatting Explained

  • 28

    DAX 400 - Parameters

    • DAX 401 - Parameters Introduction

    • DAX 402 - Download Lesson Dashboard, Data And Guides

    • DAX 403 - What-If Parameters

    • DAX 404 - Query Parameters

  • 29

    Excel Dashboards 100 - A Powerful Analysis Of Alternatives Using Only Form Controls And Formulas

    • Excel Dashboards 101 - Introduction + Key Points

    • Excel Dashboards 102 - File Download

    • Excel Dashboards 103 - Problem Description

    • Excel Dashboards 104 - Implementing The Weighted Average With Scroll Bars

    • Excel Dashboards 105 - Creating The Main Chart

    • Excel Dashboards 106 - Creating The Chart Drilldown Mechanism

    • Excel Dashboards 107 - Creating Top/Bottom N Rankings

    • Excel Dashboards 108 - Maintenance + Wrap Up

  • 30

    Excel Dashboards 200 - Pivot Table Dashboard

    • Excel Dashboards 201 - Problem Description

    • Excel Dashboards 202 - File Download

    • Excel Dashboards 203 - Setting Up The Excel Tables

    • Excel Dashboards 204 - Creating The Data Model

    • Excel Dashboards 205 - Adding Additional Pivot Tables

    • Excel Dashboards 206 - Adding Pivot Charts

    • Excel Dashboards 207 - Formatting The Charts

    • Excel Dashboards 208 - Adding Slicers + Wrap up

  • 31

    Excel Dashboards 300 - Manage Projects With This Dashboard Using VBA, Rollovers And Data Visualization