Excel Dashboard Pro

Excel TV Academy
Excel Dashboard Pro

ONLY FOR MEMBERS

Intermediate

Video/Text

Data Visualization

67 Lessons

0% Not started

This is our flagship course. With over 67 lessons, 6.5 hours of content, labs quizzes and more!

Checkout this course to take your Excel skills to the next level. In this course, we bring together data visualization, formulas, charts, and more to create interactive reports and models. Your bosses will be shocked by the stuff you’ll learn to create. After this course, you’ll never use Excel the old way again.

Ready?

Excel Dashboard Pro

Dashboard Primer

4 Lessons

ONLY FOR MEMBERS

Course Introduction

ONLY FOR MEMBERS

Why Excel?

ONLY FOR MEMBERS

Why Dashboards?

ONLY FOR MEMBERS

Interactive Dashboards in Excel

Thinking Like A Dashboard Pro

5 Lessons

ONLY FOR MEMBERS

Thinking Outside the Cell

ONLY FOR MEMBERS

Why Develop Differently?

ONLY FOR MEMBERS

Inserting the Camera Tool

ONLY FOR MEMBERS

Camera Tool Demo

Get the DownloadsLAB: Camera Tool DemoFile: Camera Tool Download

ONLY FOR MEMBERS

Development Principles

Working With Formulas

3 Lessons

ONLY FOR MEMBERS

Formula Editing Tips

ONLY FOR MEMBERS

Excel's Calculation Engine

ONLY FOR MEMBERS

Writing Better Formulas

Lookup Functions And Array Formulas

7 Lessons

ONLY FOR MEMBERS

Lookup Functions

ONLY FOR MEMBERS

VLookup

ONLY FOR MEMBERS

Index Match

ONLY FOR MEMBERS

Combination

ONLY FOR MEMBERS

Array Formulas

ONLY FOR MEMBERS

Array Formulas DEMO

ONLY FOR MEMBERS

Array Formulas Review

Excel Tables

5 Lessons

ONLY FOR MEMBERS

Introduction to Excel Tables

ONLY FOR MEMBERS

Inserting an Excel Table

ONLY FOR MEMBERS

Working with Excel Tables

ONLY FOR MEMBERS

Excel Table Chart Example

ONLY FOR MEMBERS

Excel Table Rules

Sorting & Decision Functions With Excel

5 Lessons

ONLY FOR MEMBERS

Sorting Functions

ONLY FOR MEMBERS

Filters & SUMPRODUCT

ONLY FOR MEMBERS

Filtering on Excel Tables

ONLY FOR MEMBERS

Aggregation with Excel Tables

ONLY FOR MEMBERS

Summary of Sorting Decision Functions

Introduction to Form Controls

5 Lessons

ONLY FOR MEMBERS

Installing the Developer Tab

ONLY FOR MEMBERS

Excel Controls

ONLY FOR MEMBERS

Form Controls DEMO

ONLY FOR MEMBERS

Form Control BASICS

ONLY FOR MEMBERS

Scrollable Tables

Formula Driven Development

2 Lessons

ONLY FOR MEMBERS

Excel Development Styles

ONLY FOR MEMBERS

Information-Transformation-Presentation

Interactive Legends in Excel

4 Lessons

ONLY FOR MEMBERS

Introduction to Interactive Legends in Excel

ONLY FOR MEMBERS

Setting Up the Interactive Legend

ONLY FOR MEMBERS

Perfecting the Interactive Legend

ONLY FOR MEMBERS

Maintaining the Interactive Legend

Interactive Chart Toggle

4 Lessons

ONLY FOR MEMBERS

Introduction to Interactive Chart Toggle

ONLY FOR MEMBERS

Setting Up the Interactive Toggle

ONLY FOR MEMBERS

Formatting the Interactive Toggle

ONLY FOR MEMBERS

Maintaining the Interactive Toggle

Interactive Dashboards

4 Lessons

ONLY FOR MEMBERS

Introduction to Interactive Dashboards

ONLY FOR MEMBERS

Setting Up the Interactive Dashboard

ONLY FOR MEMBERS

Formatting the Interactive Dashboard

ONLY FOR MEMBERS

Maintaining the Interactive Dashboard

Data Visualization Primer

5 Lessons

ONLY FOR MEMBERS

Visual Perception

ONLY FOR MEMBERS

Gestalt Laws of Grouping

ONLY FOR MEMBERS

Preattentive Attributes

ONLY FOR MEMBERS

The Problem with Pie Charts

ONLY FOR MEMBERS

Data Visualization vs Infographics

Expanding the Chart Library

4 Lessons

ONLY FOR MEMBERS

Introduction to Advanced Charts

ONLY FOR MEMBERS

Dual Axis Banding

ONLY FOR MEMBERS

Area Chart Banding

ONLY FOR MEMBERS

Limit Charts

Bullet Charts

3 Lessons

ONLY FOR MEMBERS

Introduction to Bullet Charts

ONLY FOR MEMBERS

Bullet Charts DEMO

ONLY FOR MEMBERS

Horizontal Bullet Chart Trick

Infographics in Excel

5 Lessons

ONLY FOR MEMBERS

Introduction to Infographics in Excel

ONLY FOR MEMBERS

Progress Meter DEMO

ONLY FOR MEMBERS

Donut Chart DEMO

ONLY FOR MEMBERS

Waffle Unit Chart DEMO

ONLY FOR MEMBERS

Bringing It All Together with the Camera Tool

Summary

1 Lesson

ONLY FOR MEMBERS

Review & Resources

Get The Downloads

1 Lesson

ONLY FOR MEMBERS

Get All the Labs and Files

Follow

About the teacher

Jordan Goldmeier

Jordan is an Excel MVP and author of several books including 'Becoming a Data Head', 'Dashboards for Excel, and 'Advanced Excel Essentials'