91
Downloadable Workbooks & LAB Notes
1.1 Introduction
1.2 Why Excel
1.3 Why Dashboards
1.4 Interactive Dashboards in Excel
2.1 Thinking Outside the Cell
2.2 Why Develop Differently
2.3 Inserting the Camera Tool
2.4 Camera Tool Demo
2.5 Development Principles
3.1 Formula Editing Tips
3.2 Excels Calculation Engine
3.3 Writing Better Formulas
4.1 Lookup Functions
4.2 VLookup
4.3 Index Match
4.4 Combination
4.5 Array Formulas
4.6 Array Formulas Demo
4.7 Array Formula Review
5.1 Introduction to Excel Tables
5.2 Inserting an Excel Table
5.3 Working with Tables
5.4 Excel Table Chart Example
5.5 Excel Table Rules
6.1 Sorting Functions
6.2 Filters and SUMPRODUCT
6.3 Filtering on Excel Tables
6.4 Aggregation with Excel Tables
6.5 Summary
Downloadable Workbooks & LAB Notes
7.1 Installing the Developer Tab
7.2 Excel Controls
7.3 Form Controls Demo
7.4 Form Control Basics
7.5 Scrollable Tables
8.1 Excel Development Styles
8.2 Information-Transformation-Presentation
9.1 Introduction to Interactive Legends
9.2 Setting Up The Interactive Legend
9.3 Perfecting the Interactive Legend
9.4 Maintaining the Interactive Legend
10.1 Introduction
10.2 Setting up the Interactive Toggle
10.3 Formatting the Interactive Toggle
10.4 Maintaining the Interactive Toggle
11.1 Introduction
11.2 Setting Up The Interactive Dashboard
11.3 Formatting the Interactive Dashboard
11.4 Maintaining the Interactive Dashboard
Downloadable Workbooks & LAB Notes
12.1 Visual Peception
12.2 Gestalts Law
12.3 Preattentive Attributes
12.4 The Problem with Pie Charts
12.5 Data Viz vs Infographics
13.1 Introduction
13.2 Dual Axis Banding
13.3 Area Chart Banding
13.4 Limit Charts
14.1 Introduction to Bullet Charts
14.2 Bullet Chart Demo
14.3 Horizontal Bullet Chart Trick
15.1 Introduction to Infographics in Excel
15.2 Progress Meter
15.3 Donut Chart Demo
15.4 Waffle Unit Chart Demo
15.5 Bringing it Together with the Camera Tool - Demo
Downloadable Workbooks
Introduction to the Analysis of Health Systems Dashboard
Problem Description
Form Control Scroll Bar Mechanism
Create The Main Chart Using The LARGE, XLOOKUP, VLOOKUP & REPT Formulas
Drill Down On Your Data With The LEFT, INDEX, REPT Formulas
Create Top & Bottom Charts With The LARGE & XLOOLUP Formulas
Dashboard Maintenance
Downloadable Workbooks
Course Outline
Gannt Chart VBA Dashboard Overview
Rollover pop-ups explained using VBA
Lay out the data with the SUMIFS Formula
Bring the data into the Gannt Chart Dashboard using the INDEX Formula
Lay out the Gannt Chart Dashboard using Conditional Formatting
Create the Legend using Conditional Formatting
Set up the KPI Stacked Column Chart
Design the Rollover pop-up using the INDEX formula and the Camera Tool
Create the Rollover pop-up using VBA & Conditional Formatting
Show the Rollover pop-up using VBA
Test & Modify the Rollover pop-up using VBA
Format the Rollover pop-up using VBA
Unlock your Certificate of Completion

But Don’t Just Take Our Word For It

Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust MyExcelOnline to enhance their professional development and every day.

Some of our course students work at...

Save with our Courses Bundles!

Intro to Excel Bundle

An introduction to Microsoft Excel to get you up to speed and confident using the most common features!

  • Introduction to Excel
  • Formulas
  • Formatting
  • Charts
  • Printing
  • 5 Hours | 56 Lectures | Beginner Level | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Intermediate Excel Bundle

Learn the must know Microsoft Excel features to elevate your Excel level!

  • Formulas
  • Pivot Tables
  • Macros & VBA
  • Data & Analysis
  • Charts
  • 11 Hours | 216 Lectures | Intermediate Level | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Advanced Excel Bundle

Learn the must know Microsoft Excel features to advance your Excel level!

  • Formulas
  • Pivot Tables
  • Macros & VBA
  • Power Query
  • Power Pivot
  • Power BI
  • Excel Dashboards
  • Financial Modeling
  • Charts
  • 40 Hours | 569 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Microsoft Office Bundle

Learn the must know Microsoft Office applications to make you more productive at work!

  • Outlook
  • PowerPoint
  • Word
  • Teams
  • OneNote
  • Access
  • Power Automate
  • Power Apps
  • Project
  • SharePoint
  • Visio
  • Forms
  • 14 Hours | 50 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Frequently Asked Questions

  • You're starting to learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how to get an advantage over your colleagues or peers.
  • You're preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job!
  • You often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck.
  • You spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones.
  • You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training.

Anyone who wants to elevate their Excel knowledge & skills, including…

  • New users, beginners, intermediates and advanced Excel users.
  • Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and reporting.
  • People who want to change careers and apply for a new job that requires knowledge of Microsoft Excel
  • If you want to dramatically reduce repetition, stress, and overtime and exponentially increase your chances of a promotion, pay raise or new job!
  • It doesn’t matter if you are completely new to Excel. No prior Excel knowledge is necessary to participate in this course.


The tutorials were recorded using Excel 2010, 2013, 2016, 2019, 2022 and Microsoft 365.

Most of the concepts taught are compatible with:

  • Excel for Windows: 2007, 2010, 2013, 2016, 2019, 2022 & Microsoft 365
  • Excel for Mac: 2011, 2016, 2019, 2022 & Microsoft 365

No - this isn’t like school - this is self-paced learning - you decide when you start and when you finish.

You get access to all the training materials for life. 

You can access the course site from your work computer, home computer, tablet, smartphone or any other device with an internet connection.

The course site remembers your progress, so you can pick-up right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.

Yes! You will be able to download and keep all the excercise files in each of the courses as well as our PDF Cheat Sheets.

This makes it easy to follow along and practice with our data, whether you are online or offline.

Yes, this course and all the training materials can be accessed on any tablet or smartphone, and it looks beautiful. 

You can watch the course on your iPad, Tablet or mobile phone anywhere and anytime!

Each video has a discussion section. You can use this section to ask questions and see what questions other students have. We will be there helping to answer your questions.


You can also send an email to our dedicated email support if you cannot find your answer.

Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. 

Most companies are willing to invest in making their employees even more awesome at Excel!

We accept all major credit cards like Visa, MasterCard, American Express, Apple Pay and PayPal.

Through our partners like Klarna, Afterpay, and Affirm, we can give you the flexibility of breaking up your purchase into easy installments.

The course fees are shown in USD $

Get in contact with us if you want to pay via bank transfer or check at [email protected]

If you need a Tax Invoice for your records, then this can be emailed to you. We are happy to complete any paperwork your company or government may require.

Yes! Each course comes with lifetime access to all course materials.

There are team packages available at a discounted price!

Each team member will have their own account and be able to track their progress in the course. 

Get a quote by filling in this form here: https://www.myexcelonline.com/corporate-academy-team-packages

Yes! You will receive a Completion Certificate at the end of each course.

You can cancel at any time within the first 30 days and receive a full refund.


Plus, you get to keep all our downloadable course Cheat Sheets and Workbooks!