Loading Events

« All Events

  • This event has passed.

Public Webinar: Excel Dashboards via Drop-Down Menus

January 20, 2015 @ 12:00 pm - 1:30 pm

| $40

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.


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:

  • The 90-minute live webinar, or a streamed recording
  • 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)


Trying to decide whether this automation process is ideal for your projects? Check out these examples.

Creating data tables for your appendices:

Creating one-page summaries with a mix of charts and text:


Intermediate to advanced spreadsheet and data analysis knowledge. I suggest watching a few of my free tutorials prior to the webinar: www.annkemery.com/excel

Target Audience

Social scientists who need to churn out a series of visual reports, e.g., one snapshot per school, district, program, initiative, grantee, etc.

What People are Saying

“I did get a lot out of the webinar, but the support materials and videos make all the difference.  And it’s smart and generous of you to give us access to the webinar for review. You are offering something very special. I’m feel pretty skilled with analyzing, interpreting, and presenting data, but I’m going to be able to bump my skill set up to a whole new level with your help.”

Purchase the Recording and Accompanying Materials

This webinar has finished, but you can still purchase the recording and materials. Contact me.


January 20, 2015
12:00 pm - 1:30 pm
Event Category:
Event Tags:
, , , , , , , ,




Ann K. Emery
Dana Toto Bo Togel 2D 200rb Togel Bet 100 Toto Macau Toto Togel Togel178 Togel178 Togel178 Togel178 Togel178 Pedetogel Pedetogel Pedetogel Pedetogel Pedetogel Pedetogel Sabatoto Sabatoto Sabatoto Sabatoto Sabatoto Togel279 Togel279 Togel279 Togel279 Togel279 Togel279 Togel279 Togel158 Togel158 Togel158 Togel158 Togel158 Colok178 Colok178 Colok178 Colok178 Colok178 Colok178 Colok178 Colok178 Novaslot88 Novaslot88 Novaslot88 Novaslot88 Novaslot88 Slot Gacor