Interactive Dashboards with Excel

$95.00

What Will You Learn?

  • How to save time in Excel
  • To understand design patterns and strategies for building dashboards in Excel
  • To understand how to use the Formulas and Functions for the purpose of designing dashboards

Description

Interactive Dashboards with Excel is an online video course for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers. This course will teach you how to present data to leadership, so they can ask questions of the data and make decisions quickly. In addition, this course covers theoretical concepts like data visualization and how to build spreadsheets, so they’re always fast, transparent, feature-rich, and extensible. By the end of this course, you will feel confident knowing the best chart to use to present based on the data you have, and you’ll be able to turn around dashboards and charts more quickly than before. While the topics in this course may seem advanced, they’ll be presented to you in a friendly manner—and lessons are designed such that you’ll be able to apply the material immediately to your own work before finishing the course.

Instructor

JORDAN GOLDMEIERJORDAN GOLDMEIER

Data Science/Analytics Professional and Visualization Expert
Jordan is an internationally recognized data science/analytics professional and visualization expert, author, and speaker. He is the owner of Cambia Factor, a data consulting agency and the author of “Advanced Excel Essentials” (Apress 2014) and Dashboards for Excel (Apress 2015). He has consulted with and provided training for NATO, the Pentagon, and Financial Times, among others. His work has been cited by and quoted in the Associated Press, Bloomberg Businessweek, Dice News, and American Express OPEN Forum. He has also held the prestigious MVP award from Microsoft since 2013.

 

What to Know Before the Class

A basic understanding of working with Excel is recommended, but not mandatory.


Duration: 5:42:51
The Interactive Dashboards with Excel course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers. This course will teach you how to present data to leadership so they can ask questions of the data and make decisions quickly. In addition, this course covers theoretical concepts like data visualization and how to build spreadsheets so they’re always fast, transparent, feature rich, and extensible. By the end of this course, you will feel confident knowing which chart to use to present based on the data you have and you’ll be able to turn around dashboards and charts more quickly than before. While the topics in this course may seem advanced, they’ll be presented to you in a friendly manner—and lessons are designed such that you’ll be able to apply the material immediately to your own work before finishing the course.
Interactive Dashboards with Excel - What you need to get started
Module 01A - Introduction to Interactive Dashboards with Excel (Why Excel)
07:44
Module 01B - Introduction to Interactive Dashboards with Excel (Why Dashboards)
05:00
Module 01C - Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo)
09:37
Module 02A - Thinking Outside the Cell (Introduction)
06:14
Module 02B - Thinking Outside the Cell (Why Develop Differently)
03:29
Module 02C - Thinking Outside the Cell (Inserting the Camera Tool)
02:48
Module 02D - Thinking Outside the Cell (Using the Camera Tool)
07:15
Module 02E - Thinking Outside the Cell (Development Principles)
12:35
Module 03A - Working with Formulas (Formula Editing Tips)
11:06
Module 03B - Working with Formulas (Excel's Calculation Engine)
08:26
Module 03C - Working with Formulas (Writing Better Formulas)
10:16
Module 04A - Lookup Functions (Introduction)
02:30
Module 04B - Lookup Functions (VLOOKUP, INDEX, MATCH)
12:30
Module 04C - Lookup Functions (Array Formulas)
21:06
Module 04D - Lookup Functions (Array Formulas Review)
02:08
Module 05A - Excel Tables (Introduction)
03:31
Module 05B - Excel Tables (Inserting an Excel Table)
07:43
Module 05C - Excel Tables (Working with Tables)
06:41
Module 05D - Excel Tables (Excel Table Chart)
04:12
Module 05E - Excel Tables (Excel Table Rules)
02:23
Module 06A - Sorting and Decision Function with Excel Tables (Sorting Functions)
15:57
Module 06B - Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT)
01:34
Module 06C - Sorting and Decision Function with Excel Tables (Filtering on Excel Tables)
15:26
Module 06D - Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables)
11:22
Module 06E - Sorting and Decision Function with Excel Tables (Summary)
02:05
Module 07A - Introduction to Form Controls (Enabling the Developer Tab)
01:35
Module 07B - Introduction to Form Controls (Excel Controls)
13:20
Module 07C - Introduction to Form Controls (Form Control Basics)
08:55
Module 08A - Formula Driven Development (Introduction)
04:53
Module 08B - Formula Driven Development (Information-Transformation-Presentation)
Module 09A - Interactive Legends in Excel (Setting Up the Interactive Legend)
08:23
Module 09B - Interactive Legends in Excel (Perfecting the Interactive Legend)
17:30
Module 10A - Interactive Chart Toggle (Setup)
06:51
Module 10B - Interactive Chart Toggle (Formatting)
04:33
Module 10C - Interactive Chart Toggle (Maintenance)
02:31
Module 11A - Interactive Dashboards (Setup)
13:33
Module 11B - Interactive Dashboards (Formatting)
01:41
Module 11C - Interactive Dashboards (Maintenance)
02:32
Module 12A - Primer on Data Visualizations (Visual Perception)
07:49
Module 12B - Primer on Data Visualizations (Gestalt Laws of Grouping)
04:26
Module 12C - Primer on Data Visualizations (Preattentive Attributes)
02:28
Module 12D - Primer on Data Visualizations (The Problem with Pie Charts)
01:35
Module 12E - Primer on Data Visualizations (Data Vis vs Infographics)
01:57
Module 13A - Expanding the Chart Library (Dual Axis Banding)
03:41
Module 13B - Expanding the Chart Library (Area Chart Banding)
04:01
Module 13C - Expanding the Chart Library (Limit Charts)
02:56
Module 14A - Bullet Charts in Excel (Building the Chart)
07:10
Module 14B - Bullet Charts in Excel (Horizontal Bullet Chart Trick)
03:19
Module 15A - Infographics (Introduction)
01:18
Module 15B - Infographics (Progress Meter)
07:38
Module 15C - Infographics (Donut Chart)
05:09
Module 15D - Infographics (Waffle Chart)
05:10
Module 15E - Infographics (Bringing it Together with the Camera)
01:52
Module 16 - Summary
02:27
Class Survey

System Requirements

  • Windows, 7, 8 or 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 5 GB of free hard drive space
  • Microsoft Excel 2010 but Excel 2013 is preferred