You're a Data Hero.
Show OFF YOUR DATA SKILLS with my step-by-step course.
Build INTERACTIVE Excel Dashboards and Visualizations THAT WORK.
Excel Dashboard Pro is my complete, step-by-step online course to developing Excel Dashboards and Data Visualizations.
I show you everything you need to be a success.
You're already a data hero.
Learn to show off your skills.
DELIVER INSIGHTS THAT CHANGE MINDS.
Learn how to build awesome, interactive dashboards that leadership will remember. I show the secrets of Excel, how to deliver the best insight to the right people.
BUILD IN MINUTES. NOT DAYS.
Forget the VBA, Macro coding, BI mumbo jumbo, and complicated add-ins. I show you how to build dashboards quickly with just formulas and charts. Anyone can learn.
CREATE ONCE. USE RIGHT AWAY.
Every lesson in this course is based around my real world, hard won experience. The examples you build can be used immediately after the lesson in your business. Plug these examples into your own work. Then watch your coworkers be jealous.
LEARN FROM THE BEST!
I personally developed this course with you in mind. Whether you're an analyst, accountant, new graduate, veteran, or someone looking to switch into the data field, this course will work for you. I've written two books on Excel developed, Dashboards for Excel and Advanced Excel Essentials, have held the Microsoft MVP designation for over five years, and speak extensively on using data within the organization. And I share what I've learned with you.
Learn from 16 Modules packed with examples, hands-on demos, and labs.
Part 1: Dashboards Basics
Module 1 Dashboard Primer
- 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
- 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
- Make complex formulas simple
- Excel’s calculation engine–speed up those spreadsheets!
- Writing better formulas
Module 4 Lookup Function & Array Formulas
- VLOOKUP secrets
- Adding power with array formulas
Module 5 Excel Tables
- 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
- 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
- Installing the developer tab Excel controls
- Form controls demo
- Form control basics
- Scrollable tables demo
Module 8 Formula Driven Development
- Excel development styles
- Create dashboards that always show real-time data (without the “update” button!)
Part 3: Data Visualization
Module 12 A Primer on Data Visualization
- 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
- Dual Axis Banding
- Area Chart Banding
- Limit Charts
Module 14 Creating Bullet Charts
- Bullet Chart Demo
- Horizontal Bullet Chart Trick
odule 15 Infographics in Excel
- Progress Meter
- Donut Charts
- Waffle Unit Chart
- Bringing it all together with the Camera Tool
Module 16 Summary
- Course Review & Next Steps
- Suggested Resources to Keep Learning
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 want to learn how to build fast, interactive dashboards to change minds in your organization.
- You are a longtime professional, student or junior employee, or recent career changer looking to get a raise, promotion, or the ear (and eyes) of leader.
- You believe in yourself, and know all that's needed to do a good job are the right tools, skills, and the thirst to learn.
- 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 course that teaches Pivot Tables, Microsoft BI or Sharepoint.
- 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 Excel Dashboards and Data Visualizations.
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 a 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!
Here are answers to some frequently asked questions:
Can I access the class from anywhere? Can I download the videos?
You can watch these videos on any device! That means you can learn Excel from the comfort of your desktop and on the go on your phone.
No internet? No problem! Every video can be downloaded and enjoyed offline.
I'm not an Excel expert and don't know macros or VBA, is this course for me?
Absolutely! In fact, there is no coding in this course at all! I’ll show you how to build amazing interactive dashboards without writing a single line of code. How does that sound?
When does this course start? When does it end?
This course starts immediately upon registration and payment. You will have lifetime access to the course and can rewatch videos as many times as you’d like.
Once purchased, how long will this course be available?
FOREVER. This course comes with lifetime access. There is no time limit to complete this course. Learning is life long process, so you should have access to this course for as long as you’d like.
How long does it take to complete this course?
There is about 6.5 hours of video-based course material available. This number does not include labs or quizzes.
The course is self-paced and there is no correct amount of time it should take. We encourage you to spend time with the material until you fully understand it, whether that’s simply watching a video once or multiple times, or implementing what you’ve learned at work.
Will course materials be available for download?
Yes, all associated course materials can be found within their associated lessons. We strongly encourage you to supplement your learning by following along with the course files, taking quizzes, and completing labs.
Can I watch lessons using my mobile device?
Absolutely! Our video delivery system works across all desktop and mobile platforms. Enjoy at home, at work, and on the go.
I need help! Who can I contact?!
Do you offer in-person, hands-on training in addition to these courses?
Absolutely! We can help your team and organization realize its full potential. Please email [email protected] for more details.
What version of Excel do I need? Can I use Excel for Mac?
I Excel 2016 for this course. However, the vast majority of users can get by with Excel 2010 and later. In two instances, very small features I present will only be available to Excel 2013 and later–and I make those clear in the lessons. Neither instance however is a deal breaker that would prevent you from producing great work.
Excel 2007 and earlier are not supported. You may be able to follow along with Excel for Mac. However, some key strokes and the locations of certain features will be different. That said, I’ve helped many Macintosh users in my one-on-one courses, so it’s possible. But you’ll save yourself significant headache by using a Windows version.
What payment methods do you accept?
We accept all major credit cards including American Express, Master Card, Visa and Discover. We also accept PayPal.
Do you offer corporate discounts?
We offer corporate discounts for group purchases. Please inquire with Rick Grantham by emailing [email protected] to find out more.
Do you offer in person training?
Absolutely! We can help your team and organization realize its full potential. To get started, select the right plan for you from the available options. Next, we’ll contact you to get the details. If you have questions, contact Rick Grantham by emailing [email protected] to help us craft the perfect learning experience for you and your organization.
Will your books Dashboards for Excel or Advanced Excel Essential come free with the course?
I WISH! Unfortunately, the ability to distribute books online is restricted by my contract with my book publisher. That being said, we are working with the publisher to see if we can get attendees a really awesome discount code for signing up to the course.
Can my employer pay for this course?
Absolutely. You’ll have to talk to your employer to see what specifics are required. We suggest using a corporate credit card or PayPal account if available. Otherwise, you’ll receive a receipt immediately upon payment authorization that you can supply to your employer for reimbursement.