EXCEL POWER USER QUICK GUIDES
by Szilvia Juhasz
"Laminate Worthy" Quick Guides for the Excel Power User. Includes:
- Shortcuts & Timesavers for the Power User
- Quick Reference Guide for Lookups and Conditional Calculations
- FINALLY -
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.
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 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.
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.
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 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".
Don't worry, your email address will be safe.
Don't worry, your email address will be safe.