Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 32 Minute(s)
Language
English
Taught by
Excel Yourself
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Build Interactive Dashboards and Data Visualizations in Excel without VBA, Pivot Tables or slow Excel spreadsheets.
Excel Dashboard Pro is an online spreadsheet video course for anyone who works in Excel everyday and wants to make their reports more visual, beautiful, and efficient. The course will teach you how to present data to leaders in a way that that allows them to interact with the data in a manner that is intuitive and leads to more efficient decision making. Highly graphical spreadsheets have a tendency to be slow, error prone and filled with bloat. This course will teach you how to build these visualizations so that they’re always fast, transparent, feature rich, and extensible.
This course will take you step by step through the dashboard building process. Beginning with conceptual dashboard and visualization concepts, and moving through efficient data model design, and ending with interactive visualizations that are both stunning and usable. Ever wonder why your brain (and your dashboard viewer) is drawn to specific designs? This course walks you through all the nuances of our brains and eyes that impact how we process data. The topics are advanced. But there is no need to feel overwhelmed by the content. The instructor has eliminated unnecessary steps. This is a step by step guide to becoming an Excel Dashboard Pro.
The instructor, Jordan Goldmeier, is an Excel MVP, blogger, conference speaker, Excel TV host, and author of two books on Excel Dashboards.
Course Content
- 16 section(s)
- 66 lecture(s)
- Section 1 Dashboard Primer
- Section 2 Thinking Like a Dashboard Pro
- Section 3 Working With Formulas
- Section 4 Lookup Functions and Array Formulas
- Section 5 Excel Tables
- Section 6 Sorting & Decision Functions With Excel Tables
- Section 7 Introduction to Form Controls
- Section 8 Formula Driven Development
- Section 9 Interactive Legends in Excel
- Section 10 Interactive Chart Toggle
- Section 11 Interactive Dashboards
- Section 12 A Primer on Data Visualization
- Section 13 Expanding the Chart Library
- Section 14 Bullet Charts
- Section 15 Infographics in Excel
- Section 16 Summary
What You’ll Learn
- Build an Excel Dashboard like a Pro
- Understand the difference between infographics and dashboards
- Master Excel visualization techniques
- Streamline Excel spreadsheet to keep the Excel model sleek and extensible
Skills covered in this course
Reviews
-
CClement Chung
I like the pace and pitch at which Jordan speaks, just the right amount of description and focused elaboration. He's clearly applied these skills himself, and the resources allow you to follow his workings in the videos. The mini-quizzes are a good way of reinforcing some of the key messages, although I'd have preferred if the the correct answer isn't always the first one (too easy to guess if you haven't been paying full attention!).
-
SStuart Maunder
Found the course to be well structured with a good balance of theory and practical demonstrations. A great alternative to using pivot tables for everything as most other courses I've seen of this type recommend.
-
CClint Nisbet
Great course packed full of tips and tricks to enhance your Dashboards and make them more dynamic and user friendly. Thanks Clint
-
MMuhammad Umer Ali
Lots of material that you don't see in common tutorials but make your life really easy in Excel without having to learn totally new stuff. I really miss the fact that when creating compound structures (e.g. the bullet charts), the instructor never mentions the Grouping feature of Excel that always helps with dealing such things.
