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 and 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.
The Data Set
The tutorials in the Demographic Dashboard series use the same data set from the US Census Bureau: population data by sex, age and country, years 1996-2050. You can interact with the dashboard selecting a year, a country and a region. Think of “markets” instead of “regions” and “products” instead of “countries” and you get a sales dashboard…
Here is how it works.
I believe that an Excel dashboard should be interactive, should be connected to an external data source (easier to maintain and update), and should be free from all that useless fluff most BI vendors love. If that’s what you want too, here’s what you get:
- A 12-module course that shows you every single step I took to create a sample dashboard. 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.
This is a learning-by-example course. This means that you should watch each video, read the discussion and replicate the steps. Here is one of the videos:
That’s how you’ll learn all those new techniques that you will apply in your own dashboards. Watch this video. It’s your dashboard when you finish the course (this one is slightly different from the latest version, shown in the image above):
Relax, you have lifetime access to your course.
I take online courses from time to time. As soon as I click the pay button the phone rings: a client has a new project that requires full and immediate attention. That’s the first in a string of urgent requests. So, bye-bye, course…
That’s why you get lifetime access to the course. You can take it at your own pace but please do yourself a favor: take the course, don’t just buy it. This is a path, not a pill. You still have to work.
There are many ways to skin a cat. That’s why you need two tutorials…
Excel is very flexible, and there are many ways to achieve the same result. That’s why you get access to the new Lookup Edition of the Demographic Dashboard tutorial when you buy Lifetime access. Since they share the same dataset and the output is similar, you can focus on the design and the set of Excel techniques in each tutorial.
Is this the right course for me?
Let me be honest with you: if you don’t know the difference between “=A1+A2” and “=$A1+$A2” the tutorial is too advanced for you and you should try something simpler.
On a second thought, if you are interested in dashboards with Excel I believe that you already know the difference… So, yes, this is for you.
No, This Is Not a Recurring Payment
I hate small print, don’t you? Lifetime access grants you access to the tutorial as long as this site exists. That’s all. One time payment. No small print.
How Safe Is your Purchase?
Transactions are safely processed through PayPal, so no credit card details are accessed or stored. And I will not spam you or share your e-mail address.
I am sure you’ll love this Excel Dashboard video tutorial and I am doing my best to tell you exactly what you’ll get. However, if this is not what you expect you still have a 30-day, no questions asked, full money-back guarantee. If you feel that the product is not improving your Excel and dashboard skills, you just have to send me a message and I’ll issue a refund immediately.
What users are saying…
Here are some of the comments people are leaving in the blog about the tutorial:
Your dashboard ROCKS!! Just finished the dashboard tutorial and can’t wait to get into creating my own for our data. I have searched for a long time for a good quality tutorial that covers all the essential functions for creating reports and reporting tools. This is the most amazing tool for learning advanced Excel I have come across and is also a shining example of Excel best practices. I wish I had this years ago. You have a great understanding of how to communicate and teach complex information easily and clearly. Thank you.” T.
Jorge – Great work on this. I purchased the training and it has been very helpful to me in setting some things up.” Sam G.
This is great, just what I’ve been looking for. Thanks alot.” Joseph Flowers
“In less than half an hour, I have learned more than I ever imagined with your dashboard, and that is the start. Thanks you so much, and yes, the price is really nothing compared to what you get.” Daniele
“Great job. It has helped me get a dashboard project off the ground in record time. Thanks!” Jeff
“… indeed it is a great work.”- Imran
“I accidentally discovered your site and I am super impressed. I am a data analyst at e-commerce company and am looking to streamline automate reports for executives. I am trying to expand my understanding of excel and building up my repertoire so to speak and I realize that pivot tables and VBA are key. The demographic dashboard is an excellent learning tool for people like me who are looking to learn the “integration” bit by example. And, your example is extremely clean and non-convoluted. So thank you, I am looking forward to learning a lot from your site and tutorials.” Rachana Mukherjee
“The challenge is not so much in the Excel techniques (well, only a little ), but it is more in the creativity and empathy of the dashboard designer. Thanks Jorge, for your brilliant solutions!” Chris Capel
So, let’s get you started!
Look, learning how to make effective dashboards and how to design charts that truly support decision-making are long-term skills that will help you stay competitive in the marketplace. You know that, don’t you? Start today. You can get the tutorial for only $97.00 for a lifetime. If you understand the value of education and life long training you know how ridiculously low this price this is.
Take advantage of the promotional price
Now that the second Demographic Dashboard Excel tutorial is available, you can have them both for only
$97.00 $72.75 [25% Easter discount]. Select one of the options then click the checkout button below (the page will refresh first).
(Two dashboard courses only
$97.00 $72.75 [25% Easter discount]. Lifetime access, 30-day, no questions asked, full money-back guarantee. Pay securely with your Paypal account.)
See you on the other side…
P.S.: If you are in the fence just try it. If you have any questions drop me a note using the contact form below.