Be The Data Hero

The step-by-step guide to build Pro Excel Dashboards and Visualizations THAT WORK

Excel Dashboard Pro is my complete, step-by-step instruction guide to developing Excel dashboards and data visualizations that will make you the data hero.

Find out what you are going to learn from our 16 Training Modules

Part 1: The Basics
Module 1 -
Dashboard Primer

Duration: 24m


- What are dashboards?
- Why is Excel the best tool to create dashboards in your organization?
- Your first Interactive Dashboard in Excel

Module 2 -
Thinking Like a Dashboard Pro

Duration: 34m

- Thinking outside the cell–what does that mean?
- Unconventional thinking: Why develop differently?
- Development principles to build like a PRO

Module 3 -
Working With Dashboard Formulas

Duration: 32m

- Make complex formulas simple
- Excel’s calculation engine–speed up those spreadsheets!
- Writing better formulas

Module 4 -
Lookup Function & Array Formulas

Duration: 43m

- VLOOKUP secrets

-INDEX/MATCH
- Adding power with array formulas

Module 5 -
Excel Tables

Duration: 27m

- Inserting and working with Excel Tables
- Excel Table Demos
- Rules and tips for working with Excel Tables

Module 6 -
Sorting & Decision Functions with Excel Tables

Duration: 54m

- Sorting Functions for your dashboards
- Filters & SUMPRODUCT
- Filtering on Excel Tables
- Aggregation with Excel Tables

Part 2: Dashboard Development
Module 7 -
Introduction to Form Controls

Duration: 30m

- Installing the developer tab
Excel controls
- Form controls demo
- Form control basics
- Scrollable tables demo

Module 8 -
Formula Driven Development

Duration: 12m

- Excel development styles
- Information-Transformation-Presentation
- Create dashboards that always show real-time data (without the “update” button!)

Modules 9-11 -
Interactive Dashboards withExcel

Duration: 1h 7m

These modules take you through the preparation, development, and maintenance of three interactive dashboards.

- Interactive Chart Legend Dashboard

- Interactive Chart Production Dashboard
- Tornado Dashboard

Part 3: Data Visualization
Module 12 - A Primer on Data Visualization

Duration: 20m

- Visual Perception
- Gestalt’s Law of Grouping
- Preattentive Attributes
- The Problem with Pie Charts
- Data Viz vs Infographics

Module 13 -
Expanding Excel's Chart Library

Duration: 13m

- Dual Axis Banding
- Area Chart Banding
- Limit Charts

Module 14 -
Creating Bullet Charts

Duration: 13m

- Bullet Chart Demo
- Horizontal Bullet Chart Trick

Module 15 -
Infographics in Excel

Duration: 24m

- Progress Meter
- Donut Charts
- Waffle Unit Chart
- Bringing it all together with the Camera Tool

Module 16 -
Summary

Duration: 3m

- Course Review
- Suggested Resources

Here's What You’ll Get

TONS OF INCREDIBLE CONTENT! 
Over 6.5 hours, 16 amazing modules, and 66 lessons. Plus lifetime access!

KEEP YOUR SKILLS CURRENT!
Quizzes, demos, labs, and bonuses keep your sharp. Use what you learn immediately!

LEARN FROM THE BEST!
Get the help you need. Jordan will be there to guide you throughout the course. Leave a question under any video when you need help!

Is this Course Right for You?

This course is not for everybody.

WHO THIS IS FOR

  • You believe you can make better business intelligence and reports faster and quicker if given the right guidance and tools.
  • You are a longtime professional, student or junior employee, or recent career changer looking to get in front of leadership and management.
  • You want to differentiate yourself in your office by having the best skills for the job.
  • You love getting your hands dirty with data and visualizing data for insights.  

WHO THIS IS NOT FOR

    • You are looking for a course with Visual Basic for Applications, macros, or Microsoft Access as a focus.
    • You are looking for a quick guide that does not require time, effort or work.
We Stand Behind our course!

When you buy this course, you get the Excel.TV Guarantee. We guarantee you'll immediately learn to build awesome Pivot Tables and deliver insightful Business Intelligence to your managers and stakeholders.


We're so confident in our product, we're happy to guarantee its success. If you don't find immediate value within the first thirty days, we promise to give your money back. And we don't play games.

That's right, it's our no-questions-asked policy. Let us know within 30 days of your purchase you'd like a refund. IT'S THAT SIMPLE.

Enroll now and get these bonuses!

These bonuses are just for this product launch! We can't promise to offer the same in the future!

Webinar Q&A Session with Jordan

(Value - $1,000)

I’ll be your data concierge.


This is only available for a limited time for the people who have signed up for early access. Submit your course and Excel questions for two, live Q&A webinars. Can’t make the webinar? That’s OK, we’ll provide recorded versions only available to course takers.

+

Lifetime Access

(Value - Priceless)


That’s right. We’re giving you lifetime access.


This material changed my life and we’re confident it will change yours.  Learning is lifelong, and we believe you should have access to this material for as long as you’d like.

+

Labs & Companion Files

(Value - $395)

Along with step-by-step video instruction, you’ll receive all available companion files plus labs to reinforce learning. We’ll also include periodic quizzes to your mastery of the material.


The best part is, you can use the course files for your own work! Download, edit, and then use them however you see fit.

+

Building Better Spreadsheets Presentation

(Value - $3,000 to watch this presentation LIVE)


You’ll get access to my Building Better Spreadsheets Webinar. This presentation has been given to conferences around the country, which organizations often spend thousands of dollars to send their attendees to. You’ll receive it for free. 

+

You'll have access to thousands of hours of free content

(Value - Priceless)

As part of the Excel.TV community, you’ll have access to our Excel.TV Show archive featuring thousands of hours of free interviews with developers, Excel tips, challenges, and articles. Everything you need to get inspired!


You’ll be part of a large community at the heart of business analytics and Microsoft Excel. You’ll also be among the first to hear about exciting new courses, promotions, and more.

+

Excel TV Courseware & Community

Join the Excel.TV community, which includes of a growing knowledgebase of free video content, special discounts to course members, and exclusive deals not available to the general public.

You also get access to our awesome courseware! When you purchase this course, you can begin immediately. Because we host everything ourselves, there are no third parties! You deal with us directly!

Start Today! Choose Your Plan Below

Invest in your career.

Investment
$297

  • Over 6.5 Hours of Content
  • Exclusive Q&A Webinar with Ken, free copy of M is for (Data) Monkey, and no-questions-asked, money back guarentee
  • Lifetime access

Value
$87/4 Payments

  • Lifetime access to Building BI with Pivot Tables and bonuses!
  • Pay $87 today, get instant access
  • Try it out with our 30-day, no-questions-asked money back guarentee

Data Master Package
$497

  • Life time access to Building BI with Pivot Tables and bonuses!
  • Lifetime access to Excel Dashboard Pro and bonuses (6.5 hours)
  • BEST DEAL: Save on both courses!

FAQ

Here are answers to some frequently asked questions:

Can I access the class from anywhere? Can I download the videos?

I'm not an Excel expert and don't know macros or VBA, is this course for me?

When does this course start? When does it end?

Once purchased, how long will this course be available?

How long does it take to complete this course?

Will course materials be available for download?

Can I watch lessons using my mobile device?

I need help! Who can I contact?!

Do you offer in-person, hands-on training in addition to these courses?

What version of Excel do I need?  Can I use Excel for Mac?

What payment methods do you accept?

Do you offer corporate discounts?

Do you offer in person training?

Will your books Dashboards for Excel or Advanced Excel Essential come free with the course?

Can my employer pay for this course?

Be a Data Hero!
Get Excel Dashboard Pro Today!