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!
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.
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.
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…
Overview and Goals for This Module Let’s say you are designing a dashboard that allows the user to select a market and, within that market, select a product. Depending on…
Overview and Goals for This Module Now it’s time to get the actual population data. We start by making a new connection to a different table in the external source….
Overview and Goals for This Module A population pyramid is an icon of population studies. To create a population pyramid in Excel you just need population by sex and age…
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)….
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…
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…
Overview and Goals for This Module The world is moving from high Young dependency ratios (many children, when compared to the adult population) to high Old dependency ratios (many elderly…
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…
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…
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…