Maintenance Alert: Saturday, October 21st, 7:00am-6:00pm CT. During this time, the shopping cart and information requests will be unavailable.

Excel® Dashboard 201: Designing Dynamic Dashboards

Design Excel VBA dashboards and impress your boss and coworkers

One Hour Webinar

loading gif


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.

What You'll Learn

  • 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

Who Will Benefit

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!

Bring this topic or 200+ other training opportunities to your location-
in-person or online.

Request Onsite Training

Train 24/7 with 5,000+ Online Courses via Pryor+

Pryor+ offers a true blended learning approach that includes more than 15,000 learning opportunities for live and online learning.