<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / Excel / Interactive Dashboards with Excel

Interactive Dashboards with Excel

Master Interactive Dashboards with Excel! Ideal for data analysts, spreadsheet developers, managers. Enable quick decision-making with effective data presentation. Learn data visualization, building feature-rich spreadsheets.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

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.

Course Outline ( Free Preview)

Interactive Dashboards with Excel - What you need to get started

Module 01A - Introduction to Interactive Dashboards with Excel (Why Excel)

Module 01B - Introduction to Interactive Dashboards with Excel (Why Dashboards)

Module 01C - Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo) 10 min.

Module 02A - Thinking Outside the Cell (Introduction) 6 min.

Module 02B - Thinking Outside the Cell (Why Develop Differently) 3 min.

Module 02C - Thinking Outside the Cell (Inserting the Camera Tool) 3 min.

Module 02D - Thinking Outside the Cell (Using the Camera Tool) 7 min.

Module 02E - Thinking Outside the Cell (Development Principles) 13 min.

Module 03A - Working with Formulas (Formula Editing Tips) 11 min.

Module 03B - Working with Formulas (Excel's Calculation Engine) 8 min.

Module 03C - Working with Formulas (Writing Better Formulas) 10 min.

Module 04A - Lookup Functions (Introduction) 3 min.

Module 04B - Lookup Functions (VLOOKUP, INDEX, MATCH) 13 min.

Module 04C - Lookup Functions (Array Formulas) 21 min.

Module 04D - Lookup Functions (Array Formulas Review) 2 min.

Module 05A - Excel Tables (Introduction) 4 min.

Module 05B - Excel Tables (Inserting an Excel Table) 8 min.

Module 05C - Excel Tables (Working with Tables) 7 min.

Module 05D - Excel Tables (Excel Table Chart) 4 min.

Module 05E - Excel Tables (Excel Table Rules) 2 min.

Module 06A - Sorting and Decision Function with Excel Tables (Sorting Functions) 16 min.

Module 06B - Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT) 2 min.

Module 06C - Sorting and Decision Function with Excel Tables (Filtering on Excel Tables) 15 min.

Module 06D - Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables) 11 min.

Module 06E - Sorting and Decision Function with Excel Tables (Summary) 2 min.

Module 07A - Introduction to Form Controls (Enabling the Developer Tab) 2 min.

Module 07B - Introduction to Form Controls (Excel Controls) 13 min.

Module 07C - Introduction to Form Controls (Form Control Basics) 9 min.

Module 08A - Formula Driven Development (Introduction) 5 min.

Module 08B - Formula Driven Development (Information-Transformation-Presentation) 7 min.

Module 09A - Interactive Legends in Excel (Setting Up the Interactive Legend) 8 min.

Module 09B - Interactive Legends in Excel (Perfecting the Interactive Legend) 18 min.

Module 10A - Interactive Chart Toggle (Setup) 7 min.

Module 10B - Interactive Chart Toggle (Formatting) 5 min.

Module 10C - Interactive Chart Toggle (Maintenance) 3 min.

Module 11A - Interactive Dashboards (Setup) 14 min.

Module 11B - Interactive Dashboards (Formatting) 2 min.

Module 11C - Interactive Dashboards (Maintenance) 3 min.

Module 12A - Primer on Data Visualizations (Visual Perception) 8 min.

Module 12B - Primer on Data Visualizations (Gestalt Laws of Grouping) 4 min.

Module 12C - Primer on Data Visualizations (Preattentive Attributes) 2 min.

Module 12D - Primer on Data Visualizations (The Problem with Pie Charts) 2 min.

Module 12E - Primer on Data Visualizations (Data Vis vs Infographics) 2 min.

Module 13A - Expanding the Chart Library (Dual Axis Banding) 4 min.

Module 13B - Expanding the Chart Library (Area Chart Banding) 4 min.

Module 13C - Expanding the Chart Library (Limit Charts) 3 min.

Module 14A - Bullet Charts in Excel (Building the Chart) 7 min.

Module 14B - Bullet Charts in Excel (Horizontal Bullet Chart Trick) 3 min.

Module 15A - Infographics (Introduction) 1 min.

Module 15B - Infographics (Progress Meter) 8 min.

Module 15C - Infographics (Donut Chart) 5 min.

Module 15D - Infographics (Waffle Chart) 5 min.

Module 15E - Infographics (Bringing it Together with the Camera) 2 min.

Module 16 - Summary 2 min.

This course includes:

  • 5+ hours of training
  • 55 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing