Design Excel VBA dashboards and impress your boss and coworkers
Like people, dashboards come in all shapes and sizes, from the most basic bar graph to interactive, user-friendly reporting structures. Both types of dashboards can display almost identical information and yet users prefer the more visually-appealing option. The success of a dashboard is entirely based on how efficiently it allows users to make decisions, or more specifically, how quickly users can find (and interpret) what they are looking for.
Let’s start out with a few questions:
- Do you have fundamental dashboard skills and are looking to take them to the next level?
- Have you already created a dashboard with basic graphs and tables and are looking for a way to “push the envelope”?
- Have you been tasked with developing a “locked down” dashboard for stakeholder distribution?
If you answered yes to any of these questions, then this course is for you. Learn the fundamentals of interactive dashboard design to increase user functionality with our newest installment in the Excel Dashboard series.
Design Excel VBA dashboards and impress your boss and coworkers
Like people, dashboards come in all shapes and sizes, from the most basic bar graph to interactive, user-friendly reporting structures. Both types of dashboards can display almost identical information and yet users prefer the more visually-appealing option. The success of a dashboard is entirely based on how efficiently it allows users to make decisions, or more specifically, how quickly users can find (and interpret) what they are looking for.
- What is Visual Basic for Applications (VBA)
- How to move through a dashboard using VBA and form buttons
- How to lock a worksheet while still allowing copy/paste
- How to group or ungroup rows on a locked worksheet
- How to secure workbook structure
Are you looking for the next step after checking out our Excel Dashboard 101 class? Experienced Excel users in Sales, Human Resources, Operations, Business Intelligence, Finance or anyone excited about seeing what an Excel dashboard is really capable of should check out Excel Dashboards 201!