Become the Dashboard Master in your organization.
Take your dashboards to the next level with advanced lookup and aggregate functions!
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.
This is the Demographic Dashboard - Lookup Edition. Unlike the VBA Edition, this do not require you to write code or record macros. By the end of this course you should be able to create interactive dashboards using a combination of lookup functions.
We'll see how to copy a table from Access and a simple way to identify some elements from a larger range given a parameter. We'll use that to populate a range. Finally, we'll create our active region range using the OFFSET() and the MAX() functions.
We'll see how to create a list using Data Validation, then we'll use a formula to change a list based on user input and finally we'll adde that list to a cell using Data Validation again. Now the user can select a region and a country that belongs to that region.
We'll create our population pyramid. This is a simple but interesting chart, for several reasons. First, it uses lines instead of the traditional columns, improving readability. Then it shows that you can use scatter plots to make line charts. It also shows how to display data to the left and to the right of the y-axis.