Become the Dashboard Master in your organization.

Take your dashboards to the next level with advanced lookup and aggregate functions!

Excel dashboard

Is this an Excel dashboard?!

I know what you are thinking: “that’s not an Excel dashboard”. Well, it is an Excel dashboard, and if you follow this tutorial you will learn how to replicate it. Then you can use that knowledge to design an even better looking dashboard: your own.

The Lookup Edition of the Demographic Dashboard is a step-by-step video tutorial that takes you from a blank sheet to a fully functional dashboard. You will learn how to use advanced Excel formulas like OFFSET() or DSUM() and, unlike the VBA Edition tutorial, you do not have to leave the familiar Excel environment and you do not have to write a single line of code.

How it works.

A 14-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 use an Excel database;
  • Dynamic charts that change when the data changes (based on user selections);
  • Advanced Excel functions like OFFSET() and INDIRECT() or DSUM();
  • 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 Lookup Tutorial

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