SEMINAR ALERT: All seminars through the end of April are transitioning to live online seminar format. Existing registrations will be transferred. Click here for more information.

Digital Download

Recording from event on 05/08/2019

Item #: ED200702DL

$99 Buy Now


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!

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.