Become the Dashboard Master in your organization.

Take your dashboards to the next level, making them faster and more powerful with simple recorded macros.
No programming experience required!

ddvba-excel-dashboard

A fast Excel dashboard

There are many ways to skin a cat, and many ways to make dashboards in Excel. The best way is always task-dependent, but a few recorded macros can replace hundreds of formulas, improve calculations and make your dashboard more reliable. You can go a long way with lookup formulas, but macros will open up a whole new world. And chances are, whatever your problem is you’ll find a macro online that solves it.

Create powerful dynamic dashboards that make your business data come to life and establishes you as the dashboard expert in your organization. With these tutorials you’ll see how to go from a blank page to a fully functional dashboard, step-by-step. This example dashboard uses many different techniques that you can use in your own projects.

How it works.

A 12-module course that shows you every single step I took to create the dashboard above. This dashboard contains:

  • Forms that allow the users to interact with the data;
  • How to connect your dashboard to an external data source;
  • Dynamic charts that change when the data changes (based on user selections);
  • Advanced Excel functions like OFFSET() and INDIRECT() ;
  • Advanced pivot tables;
  • Recorded macros;
  • More than two hours of video;
  • The Excel dashboard itself;
  • The external data source.

Get my book for free!

Now, while you learn how to make Excel charts like a pro, you can apply these best practices to your dashboards. Get access to two dashboard tutorials, more than three hours of step-by-step videos that will help you unleash your creativity and create great dashboards using Excel. And you also get access a growing number of bonus files that you can explore and use to improve your Excel skills.

I’m and updating the dashboard tutorials to better reflect what I wrote in my data visualization book and to take advantage of Excel 2013 and 2016. To mark this I’m giving the Kindle version of my book away to new users. Hurry! Grab one of the remaining digital copies! Kidding, but this campaign will not last for long. Seriously.

(Two dashboard courses only $97.00 and a free electronic copy of my book. 24-month access to the tutorials, 30-day, no questions asked, full money-back guarantee. Pay securely with your Paypal account. You’ll get a message from Amazon with a link to your gift a few hours after your purchase.)

 

The course is right below, let’s get started!

The Demographic Dashboard VBA Tutorial

Each of the images below links to the page modules. If you need to login first, use the form in the page footer.