I am Corporate Trainer for Microsoft Excel and provides training to various organizations via Excel Online and Onsite. I have done MSOS, MSOE (Excel 2013) and MCT.
I usually follow two rules for making dashboards. 1. CRAP Rule (Contrast, Repetition, Alignment & Proximity) 2. MVC Rule (Model, View, Controller) Using of Shapes, Sparklines and Charts for visualize.
I love specific topics like Visual perception, Gestalt's Law of Grouping, Data viz vs infographics so overall section of "A primer on Data Visualization" plus array formulas and section of "Thinking like a Dashboard Pro". Case studies to be include in the course. Dashboard templates for various industries like Finance, Manufacturing, Hospital and others.
I would love to see some videos on dashboards with PowerPivot. How to organize the database before create any dashboard and also If there is data in Tabular format then how to manage it. More rules on creating Dashboard should be discuss.
Recommend some more books on Dashboard reporting in Excel.
Your data makes no sense ! Unless supported by an Excel Dashboard. This course Exactly teaches you how to convert your data into meaningful insights.
Even if you are new to Excel Dashboards and reporting this course will walk you through step by step from foundation to utilizing the concepts to create your own Dashboard. This course covers a quite variety of topics which really helps to understand deep concepts rather than just learning tips.
I have an Excel website that I run to help train people on how to use Excel to answer and quickly develop solutions to their most common business problems using their data. As for my full time career, I'm a Purchasing / Planning and inventory Control Supervisor. In this role I use Excel all of the time to simplify and develop an understanding of the current state of our business and provide the metrics and information to act on that data.
Many of the strategies and techniques mentioned in the course I've used prior, however the course really trained me to think differently to first of all simplify my dashboards and spreadsheets and to come up with best possible formulas and methods to arrive at a result (all the while keeping the spreadsheet light, quick and easy to use). Jordan outlines how important it is to think about not only the design and how your presenting your information but how you develop and create efficient formulas and calculations to keep the dashboard and spreadsheet running quickly and efficiently.
I would have to say the thing that I liked the best about the course is the small tips and tricks that Jordan reveals throughout the course that will help make your spreadsheets and dashboards clean, effective and just not bloated like you often see in the Excel dashboard world.
I would definitely recommend this course to basically anyone at any Excel experience level. For the more experienced Excel user, the course does a great job at making you rethink how you're currently doing things and also touches upon some theoretical aspects of visualization that could really help in the development of your dashboards. For the beginner and intermediate Excel user, the course covers the basics and also provides some tips and tricks that are handy when it comes to learning how to build and use formulas to create dashboards. The course in general really touches upon the fundamentals and building blocks of how to build simple but yet complex Excel dashboards. You'll learn how to build clean and non-bloated spreadsheets that are easy and effective at providing and displaying a visualization that truly captures and provides the information that the end user is looking for.
My favorite trick I have to say is how to clean up your long formulas in the formula bar so that they are easy to read which makes it simple for any developer to understand what the formula is trying to accomplish.
grad student, blogger, online course creator
I knew not to use 3-D charts and pie graphs from Jordan's previous training and posts, but this course took me beyond those basics. I did a lot of clunky copy-and-paste work. My graphs were static and required lots of maintenance. This course showed me how to make dynamic graphs that are easy to use and maintain.
Jordan is able to teach to all levels -- I have thousands of hours of Excel experience and learned a lot, but at the same time someone brand-new to Excel could have sat with me and followed along as well.
Yes, I would certainly recommend this course. Data visualization of course is in vogue, but few know even the basics. Professionals need to be able to communicate with data. This course will make you an authority in building dashboards and visualizations -- without thousand-dollar tools like Tableau, heck without even using VBA.
I’ve been a regular viewer of Excel TV for some time now so was thrilled to learn about their first online course. It is taught by Excel TV co-host Jordan Goldmeier, an Excel MVP and authority on dashboards and visualization. Jordan is a true innovator in Excel and he shows us some amazing dashboard and visualization techniques in this course. The course will get you thinking, as he says, “outside the cell.” You will learn to think differently about Excel, unlocking even more of its potential. The videos are easy to follow and of the highest quality. Crisp audio and excellent video. This is not another “brain dump” of meaningless Excel tips and tricks. The course walks you through the theory of data visualization and dashboards with Excel applications. I have used Excel for thousands of hours and still found new, helpful tips in this series. The course is also great for newer users of Excel -- it requires absolutely no knowledge of VBA or PivotTables, and Jordan does a great job getting all users comfortable with the tools used in this course. Data visualization and dashboards are powerful techniques for making sense in today’s data deluge. I would recommend this course to those who want to be able to communicate with their data. This is a critical skill for success across roles and industries.
The Excel Dashboard Pro course is a tremendously well thought out video course filled with practical techniques that can be applied a variety of ways in the corporate world. Jordan Goldmeier has always differentiated himself by not only focusing on Excel’s use of crunching numbers but also the ways it can interact and present data to tell a story. This is what analysts seem to struggle with the most and this course will provide you with a bunch of individual techniques that you can apply to fit the specific needs of your company.
Jordan doesn’t just walk you through how to build various modular pieces you can combine to create a full-functioning dashboard. He also shows you ways to maintain your spreadsheets for future changes and how to format them in a way that makes your dashboard feel more like a standalone application as oppose to numbers filling up a spreadsheet.
I thoroughly enjoyed taking this course and highly recommend it to anyone who wants to differentiate themselves from their colleagues.
It is amazing how this course shows you how to create stunning visualizations with simple Excel techniques, NO complex programming in VBA, just excel formulas.
Don’t be fooled by the title and think this is just another Excel course with tricks. If you take it, you will learn how to think differently about Excel development and data visualization. It will show you how to display information appropriately to convey the right message.
I would definitely recommend this course regardless of your Excel expertise.
Financial Reporting, Data Aggregation
Visualization was always one trick learned here, another learned there. Ultimately tricks can only take you so far before you need to know the WHY. Jordan Goldmeier and Excel TV are at the forefront of modern Excel visualization.
Excel Dashboard Pro helped reinforce that I was on the right path to mastery but in certain areas I was taking the long way around. After each lesson a lot of my work was reassessed in favor of the methods presented in the course. Not to give too much away but the section on BOOLEAN logic may change the way you use Excel - I know it did for me.
Yes and No. But not for the reasons you may think. Excel is a personal journey of curiosity, frustration and dedication to the craft. This course is one that users must find when their time is right within the program. For beginners a lot of things may seem foreign but for those stuck in the intermediate plateau this course shatters the glass ceiling and provides a clear path to Excel mastery.
It's certainly not for everyone with some of these advanced topics but I think Excel TV is on the right path with these courses. That market between Intermediate and Advanced is one that I know a lot of people peak around and would be willing to pay to get out of. Keep up the great work and I greatly look forward to the next course.