Use What You Have: Automated Visual Displays Using MS Word and Excel

Coffee Break Webinar
for the American Evaluation Association
December 2011

As evaluators, we frequently face the challenge of accurately and efficiently producing large numbers of near-identical reports. During this webinar, Agata Jose-Ivanina and I demonstrated how to automate production of dashboards and reports complete with graphs, tables, and text using only Microsoft Word and Excel. We provided VBA code and demonstrated how to use it to populate a dashboard template.

Members of the American Evaluation Association can view the webinar recording here (login required).

• Creating Automated Visual Displays
• All
• Creating and Automating Dashboards