{"id":2187,"date":"2015-02-06T11:41:40","date_gmt":"2015-02-06T19:41:40","guid":{"rendered":"http:\/\/nnlm.gov\/evaluation\/blog\/?p=2187"},"modified":"2019-09-24T10:15:48","modified_gmt":"2019-09-24T17:15:48","slug":"evaltemplates","status":"publish","type":"post","link":"https:\/\/news.nnlm.gov\/nec\/2015\/02\/06\/evaltemplates\/","title":{"rendered":"Another Coffee Break: Word and Excel Templates"},"content":{"rendered":"<p><a href=\"\/neo\/wp-content\/uploads\/sites\/3\/2015\/01\/aeacoffee.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2191 size-thumbnail\" src=\"\/neo\/wp-content\/uploads\/sites\/3\/2015\/01\/aeacoffee-150x150.jpg\" alt=\"AEA Coffee\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p>Here at the Outreach Evaluation Resource Center (<a href=\"http:\/\/nnlm.gov\/evaluation\/\">OERC<\/a>) we began 2015 blogging about the <a href=\"http:\/\/nnlm.gov\/evaluation\/blog\/2015\/01\/02\/evaluation-soundbites-from-the-cdc\/\">CDC Coffee Breaks.<\/a> For February we&#8217;re offering a refill by featuring some notes from a recent American Evaluation Association (<a href=\"http:\/\/www.eval.org\/\">AEA<\/a>) coffee break webcast. Unlike the CDC, the 20 minute AEA coffee break webcasts are not freely available to the public but are an included benefit of AEA membership. The webcast briefly covered best practices in data visualization using two commonly available resources (Microsoft Word and Excel) and how to automate use of them by creating templates for report format consistency and easier workflow.<\/p>\n<p>Some great resources to learn more how to do this and bookmark for future reference include<\/p>\n<ul>\n<li>Stephanie Evergreen&#8217;s Data Visualization Checklist\u00a0 &#8211; tips for both Word and Excel at <a href=\"http:\/\/stephanieevergreen.com\/wp-content\/uploads\/2014\/05\/DataVizChecklist_May2014.pdf\">http:\/\/stephanieevergreen.com\/wp-content\/uploads\/2014\/05\/DataVizChecklist_May2014.pdf<\/a><\/li>\n<\/ul>\n<p>Specific for Word<\/p>\n<ul>\n<li>Step by step instructions for creating, modifying, and saving templates (called Quick Style Sets) &#8211; <a href=\"https:\/\/support.office.com\/en-US\/Article\/Make-changes-to-a-Quick-Style-set-cd6ec7b6-d4db-42bf-816a-fb7ae5171b46?ui=en-US&amp;rs=en-US&amp;ad=US\">https:\/\/support.office.com\/en-US\/Article\/Make-changes-to-a-Quick-Style-set-cd6ec7b6-d4db-42bf-816a-fb7ae5171b46?ui=en-US&amp;rs=en-US&amp;ad=US<\/a><\/li>\n<li>Video demonstrating how to save table styles in Word 2010 &#8211;\u00a0 <a href=\"http:\/\/www.knowledgewave.com\/blog\/msoffice\/word\/word-2010-save-a-table-style-for-greater-efficiency.html\">http:\/\/www.knowledgewave.com\/blog\/msoffice\/word\/word-2010-save-a-table-style-for-greater-efficiency.html<\/a><\/li>\n<\/ul>\n<p>Specific for Excel<\/p>\n<ul>\n<li>Step by step instructions for saving charts as templates and applying the template to future charts &#8211; <a href=\"https:\/\/support.office.com\/en-US\/Article\/Reuse-a-favorite-chart-by-using-a-chart-template-505ba53b-41b1-49af-9886-5179640a14ae\">https:\/\/support.office.com\/en-US\/Article\/Reuse-a-favorite-chart-by-using-a-chart-template-505ba53b-41b1-49af-9886-5179640a14ae<\/a><\/li>\n<li>Working with Excel 2010 charts &#8211; <a href=\"http:\/\/www.dummies.com\/how-to\/content\/the-essentials-of-working-with-excel-2010-charts.html\">http:\/\/www.dummies.com\/how-to\/content\/the-essentials-of-working-with-excel-2010-charts.html<\/a><\/li>\n<li>Excel Dashboards and Reports &#8211; <a href=\"http:\/\/www.dummies.com\/how-to\/computers-software\/ms-office\/Excel\/Excel-Dashboards-and-Reports-For-Dummies-Extras.html\">http:\/\/www.dummies.com\/how-to\/computers-software\/ms-office\/Excel\/Excel-Dashboards-and-Reports-For-Dummies-Extras.html<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here at the Outreach Evaluation Resource Center (OERC) we began 2015 blogging about the CDC Coffee Breaks. For February we&#8217;re offering a refill by featuring some notes from a recent American Evaluation Association (AEA) coffee break webcast. Unlike the CDC, the 20 minute AEA coffee break webcasts are not freely available to the public but&#8230; <a href=\"https:\/\/news.nnlm.gov\/nec\/2015\/02\/06\/evaltemplates\/\">Read More &raquo;<\/a><\/p>\n","protected":false},"author":2959,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-2187","post","type-post","status-publish","format-standard","hentry","category-data-visualization"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p8ICUo-zh","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/2187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/users\/2959"}],"replies":[{"embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/comments?post=2187"}],"version-history":[{"count":1,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/2187\/revisions"}],"predecessor-version":[{"id":6603,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/2187\/revisions\/6603"}],"wp:attachment":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/media?parent=2187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/categories?post=2187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/tags?post=2187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}