City of St. Catharines Learning & Development

To take this course you must know how to create basic charts and have intermediate-level knowledge of formulas and functions.

Learn how to build interactive dashboards in Excel using form controls and smart design techniques. This course walks you through practical steps—from using combo boxes and checkboxes to shaping your data with formulas and charts—so you can create dashboards that are dynamic, user-friendly, and easy to maintain.

Using Form Controls

• Combo Boxes
• List Boxes
• Scroll Bars
• Option Buttons
• Check Boxes

Data Preparation

• Dynamic Array Formulas to Summarize Data
• Build Charts

Creating a Dashboard

• Interactive Charts with Form Controls
• Data Selection Form Controls
• Text Boxes with Linked Formulas
• Create Scrolling Tables
• Design & Format the Final Dashboard
• Hide and Lock Raw Data & Formulas