Excel Dashboards via Drop-Down Menus
Webinar Details $219
- Rated:
- Webinar Length: 100 Minutes
- Guest Speaker: Ann Emery
- Topic: Business Administration, Finance, Human Resources, Taxation and Accounting
- Credit: ATAAA 1.5, ATATX 1.5, ATAOP 1.5
-
Need to churn out dozens of matching visual reports — one per company, school, program, city, etc — but don’t have the time or energy to copy and paste back and forth a million times between Excel and Word? First, I’ll give you a quick overview of the technique. Next, I’ll build a snapshot from scratch so that you’ll know what to do first, second, and third.
Agenda:
Introduction to Dashboards
- What is a dashboard?
- Types
- Value of automation process
Overview of 7-Step Automation Process
- Designing the dashboard
- Setting up the spreadsheet
- Building drop-down menus
- Building the data table
- Building charts
- Finalizing alignment
- Printing or PDFing
Live Demo of Automation Process Attendees will receive:
- A 3-page guide that spells out the automation process in more detail
- The primary dataset used during the webinar (population statistics for Virginia counties)
- A secondary dataset that you can explore on your own (an organization’s social media statistics)
