This is the most amazing tool for learning advanced Excel I have come across and is also a shining example of Excel best practices.T., a user of the Excel Dashboard Tutorial
Excel dashboards you can be proud of
Get lifetime 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, the tool we love to hate ! And you also get access a growing number of bonus files that you can explore and use to improve your Excel skills. Take a look at what’s waiting for you in the members area:
Excel Dashboard Lookup
Confuse (and delight) your managers with an Excel dashboard that doesn’t look like an Excel dashboard. This course shows you how to use advanced Excel functions to aggregate data and make an interactive dashboard. And you can even display your data in a basic map! Click here to know more…
Excel Dashboard VBA
VBA? No way! Wait. If you want a more powerful Excel dashboard there are two things that you can’t avoid: pivot tables and recorded macros. In this tutorial you’ll learn how to make advanced pivot tables. If you haven’t used them yet you’ll be amazed of how powerful they are. Then you’ll need a few recorded macros to synchronize them. Record your actions and assign the macro to a button. It’s simple, really. Click here to know more…
Watch a sample video(Sample video: click bottom right button for full-screen video)
Test your Knowledge
There is no tutorial for for this one. This is bonus version that you should download, study and figure out how it was done.
Another Bonus File
(click to see the animation) What you see here is the growth of Walmart: each store, each county, total population covered within a given radius. You can apply the same principles and techniques to your own list of stores.
Better Data Visualization
These dashboards are free from 3D pie charts, speedometers and other stupid and useless effects. If you want to know why they are bad for business please read the blog, you’ll find many reasons. A good chart can dramatically improve the way you use and make sense of your data. Always apply the best practices and visualization principles when designing your dashboards.
(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.)