Excel Dashboard Pro

  1. Home
  2. Excel-dashboard
  3. Excel Dashboard Pro

Tags: Excel Dashboard

Build Interactive Dashboards and Data Visualizations in Excel without VBA, Pivot Tables or slow Excel spreadsheets.

Last updated 2022-01-10 | 4.8

- Build an Excel Dashboard like a Pro
- Understand the difference between infographics and dashboards
- Master Excel visualization techniques

What you'll learn

Build an Excel Dashboard like a Pro
Understand the difference between infographics and dashboards
Master Excel visualization techniques
Streamline Excel spreadsheet to keep the Excel model sleek and extensible

* Requirements

* Before starting this course
* you should be comfortable with the spreadsheet environment. Mastery is by no means necessary
* but little time will be spent introducing basic concepts. Before starting this course you should be somewhat familiar with Pivot Tables
* Pivot Charts
* formulas like VLOOKUP
* INDEX
* and MATCH
* and features like conditional formatting
* charts
* absolute and relative references
* and advanced filters. Knowing all of these features is less important than feeling comfortable with learning them in a fast-paced learning environment.

Description

Excel Dashboard Pro is an online spreadsheet video course for anyone who works in Excel everyday and wants to make their reports more visual, beautiful, and efficient. The course will teach you how to present data to leaders in a way that that allows them to interact with the data in a manner that is intuitive and leads to more efficient decision making. Highly graphical spreadsheets have a tendency to be slow, error prone and filled with bloat. This course will teach you how to build these visualizations so that they’re always fast, transparent, feature rich, and extensible.

This course will take you step by step through the dashboard building process. Beginning with conceptual dashboard and visualization concepts, and moving through efficient data model design, and ending with interactive visualizations that are both stunning and usable. Ever wonder why your brain (and your dashboard viewer) is drawn to specific designs? This course walks you through all the nuances of our brains and eyes that impact how we process data. The topics are advanced. But there is no need to feel overwhelmed by the content. The instructor has eliminated unnecessary steps. This is a step by step guide to becoming an Excel Dashboard Pro.

The instructor, Jordan Goldmeier, is an Excel MVP, blogger, conference speaker, Excel TV host, and author of two books on Excel Dashboards.

Who this course is for:

  • This is a course aimed squarely at the intermediate-to-advanced Excel user looking to take their skills to the next level.

Course content

16 sections • 78 lectures

Dashboard Primer 5 lectures

Introduction Preview 00:49

Why Excel? Preview 07:35

Why Dashboards? Preview 05:23

Interactive Dashboards in Excel Preview 10:19

Section 1: Quiz 1

Thinking Like a Dashboard Pro 7 lectures

Thinking Outside the Cell Preview 06:47

Why Develop Differently? Preview 03:40

Inserting the Camera Tool Preview 02:57

Camera Tool Demo Preview 07:54

Section 2: Quiz 1

Development Principles Preview 12:50

Section 2: Quiz 2

Working With Formulas 4 lectures

Formula Editing Tips Preview 11:52

Excel's Calculation Engine Preview 09:08

Writing Better Formulas Preview 11:10

Section 3: Quiz 1

Lookup Functions and Array Formulas 9 lectures

Lookup Functions Preview 02:44

VLookup Preview 03:24

Index Match Preview 06:28

Combination Preview 04:24

Array Formulas Preview 02:50

Array Formulas Demo Preview 20:44

Section 4: Quiz 1

Array Formulas Review Preview 02:20

Section 4: Quiz 2

Excel Tables 6 lectures

Introduction to Excel Tables Preview 03:43

Inserting an Excel Table Preview 08:34

Working With Excel Tables Preview 07:29

Excel Table Chart Example Preview 04:34

Excel Table Rules Preview 02:35

Section 5: Quiz 1

Sorting & Decision Functions With Excel Tables 6 lectures

Sorting Functions Preview 19:20

Filters & SUMPRODUCT Preview 01:38

Filtering on Excel Tables Preview 17:26

Aggregation With Excel Tables Preview 13:26

Summary Preview 02:12

Section 6: Quiz 1

Introduction to Form Controls 6 lectures

Installing the Developer Tab Preview 01:32

Excel Controls Preview 03:44

Form Controls Demo Preview 14:55

Form Control Basics Preview 01:59

Scrollable Tables Preview 07:26

Section 7: Quiz 1

Formula Driven Development 3 lectures

Excel Development Styles Preview 05:06

Information-Transformation-Presentation Preview 07:07

Section 8: Quiz 1

Interactive Legends in Excel 4 lectures

Introduction to Interactive Legends Preview 01:50

Setting Up the Interactive Legend Preview 07:18

Perfecting the Interactive Legend Preview 16:50

Maintaining the Interactive Legend Preview 03:11

Interactive Chart Toggle 4 lectures

Introduction to Interactive Chart Toggles Preview 00:38

Setting Up the Interactive Toggle Preview 06:56

Formatting the Interactive Toggle Preview 05:04

Maintaining the Interactive Toggle Preview 02:52

Interactive Dashboards 4 lectures

Introduction Preview 00:41

Setting Up the Interactive Dashboard Preview 15:27

Formatting the Interactive Dashboard Preview 01:49

Maintaining the Interactive Dashboard Preview 02:58

A Primer on Data Visualization 7 lectures

Visual Perception Preview 08:22

Gestalt's Laws of Grouping Preview 04:37

Preattentive Attributes Preview 02:34

Section 12: Quiz 1

The Problem with Pie Charts Preview 01:45

Data Viz vs Infographics Preview 02:01

Section 12: Quiz 2

Expanding the Chart Library 4 lectures

Introduction Preview 00:26

Dual Axis Banding Preview 04:21

Area Chart Banding Preview 04:31

Limit Charts Preview 03:11

Bullet Charts 3 lectures

Introduction to Bullet Charts Preview 01:28

Bullet Charts Demo Preview 07:00

Horizontal Bullet Chart Trick Preview 04:03

Infographics in Excel 5 lectures

Introduction to Infographics in Excel Preview 01:17

Progress Meter Demo Preview 08:45

Donut Chart Demo Preview 06:01

Waffle Unit Chart Demo Preview 05:58

Bringing it Together with the Camera Tool - Demo Preview 02:13

Summary 1 lectures

Review & Resources Preview 02:38