During this 60-minute webinar, I’ll demonstrate how to create Excel-based dashboards through drop-down menus. 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. Finally, you’ll get to download and keep several Excel templates so that you can try this technique on your own.
How This Technique Can Be Used
Example 1: To create data tables for your appendices – one table per school/program/grantee
Example 2: To create one-page summaries with a mix of charts and text – one summary per school/program/grantee
Intermediate to advanced Excel knowledge. I suggest watching any and all of my tutorials prior to the webinar: annkemery.com/excel
Social scientists who need to churn out a series of visual reports.
Purchase the Recording and Accompanying Materials
This webinar has finished, but you can still purchase the recording and accompanying materials. Contact me.
Ann K. Emery equips organizations to visualize data more effectively. Within the past year alone, she has led more than 60 professional development trainings for more than 2,800 participants around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making data-heavy reports easier to digest for non-technical audiences. Recent clients include the United Nations, Centers for Disease Control, National Institutes of Health, and dozens of professional societies, associations, foundations, and nonprofits.