Demographic Dashboard VBA Edition

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-dashboardThere 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.

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.

(Two dashboard courses only $97.00. 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 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.

00 Course Overview [VBA]

Welcome! Glad you are here. This is a journey that takes us from an empty Excel file to a fully functional dashboard. We’ll start by linking the file to an…

04 Calculating Dependency Ratios [VBA]

Overview and Goals for This Module In population studies, we can learn a lot about the population by measuring the relative proportions of each age group (Young, Adult and Old)….

05 The Evolution of Age Groups [VBA]

Overview and Goals for This Module If you are an advanced Excel user, you know how to create dynamic named ranges for your charts. These ranges automatically expand when you…

06 Population Growth [VBA]

Overview and Goals for This Module This is probably the most complex chart in the dashboard. It is a line chart with six predefined series. The users can select which…

08 Designing the Dashboard [VBA]

Overview and Goals for This Module When you start actually working on your Excel file you should already know how the basic layout will look like (what data will be…

09 Recording and Adding Macros [VBA]

Overview and Goals for This Module The dashboard is almost ready! Now we just need to record some macros to process users input and to synchronize the pivot tables. Let’s…

10 Final Touches [VBA]

Overview and Goals for This Module Well, we now have a working dashboard. But, is it really working? Well, no, I’m afraid it isn’t. There are many errors and issues…