{"id":3625,"date":"2015-12-11T12:11:03","date_gmt":"2015-12-11T20:11:03","guid":{"rendered":"http:\/\/nnlm.gov\/evaluation\/blog\/?p=3625"},"modified":"2019-09-24T10:13:29","modified_gmt":"2019-09-24T17:13:29","slug":"excel-dashboards-at-chandoo-org","status":"publish","type":"post","link":"https:\/\/news.nnlm.gov\/nec\/2015\/12\/11\/excel-dashboards-at-chandoo-org\/","title":{"rendered":"Excel Dashboards at Chandoo.org"},"content":{"rendered":"

Chandoo.org<\/a> is a website that excels at Excel.\u00a0 More specifically, it provides an extensive collection of resources to help the rest of us use Excel effectively. \u00a0There\u2019s something for everyone at this website, whether you\u2019re a basic or advanced user. Today, however. I want to specifically talk about Chandoo.org\u2019s resources on building data dashboards with Excel.<\/p>\n

Data dashboards are THE cool new data tools. A dashboard is a reporting format that allows stakeholders to view and interact with program or organizational data, exploring their own questions and interests. When the OERC offered a basic data dashboard webinar several years ago, we hit our class limit within hours of opening registration. If you are unfamiliar with data dashboards, here are slides from a presentation<\/a> by Buhler, Lewellen, and Murphy that describe and provide samples of data dashboards. .<\/p>\n

Tableau seems to have grabbed the limelight as the go-to software for data dashboard development. Yet it may not be accessible to many of our blog readers. \u00a0It\u2019s expensive and, unless you are a data analyst savant, Tableau may require a fair amount of training.<\/p>\n

The good news is that Excel software is a perfectly fine tool for creating data dashboards. Some of the best known data visualization folks in the American Evaluation Association (AEA) are primarily Excel users. Stephanie Evergreen of\u00a0Evergreen Data <\/a>\u00a0and Ann Emery<\/a>\u00a0write popular blogs about data visualizations built from Excel. At the AEA\u2019s annual conference in November, I attended a presentation by Miranda Lee<\/a>\u00a0of EvaluATE\u00a0on creating dashboards with Excel. \u00a0She has some how-to dashboarding videos in the works that will be available to the public in the near future. (We\u2019ll let our blog readers know when they become available.)<\/p>\n

\"Hand<\/a><\/p>\n

There are free resources all over the Internet if you are good at do-it-yourself training.\u00a0 However, for a modest fee, Chandoo.org offers a more systematic class <\/a>on how to design a data dashboard with Excel. Depending on how many resources you want to take away from the class, the cost is between $97 (online viewing only) and $247 (downloads and extra modules). I have not taken the class yet, but I have heard positive feedback about Chandoo.org\u2019s other courses and have plans to take this class in the near future.<\/p>\n

If you are an Excel user but don\u2019t see dashboard-building in your future, you still may find a wealth of useful tips and resources about Excel at Chandoo.org. My favorite is this list of 100+ Excel tips<\/a>.\u00a0I attended several data dashboard sessions at the AEA conference last month. The word on the street is that Microsoft is rising to the challenge to develop its data visualization capabilities.\u00a0 Apparently, each new release is better than the last.\u00a0 It may be getting easier to work dashboard magic with Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"

Chandoo.org is a website that excels at Excel.\u00a0 More specifically, it provides an extensive collection of resources to help the rest of us use Excel effectively. \u00a0There\u2019s something for everyone at this website, whether you\u2019re a basic or advanced user. Today, however. I want to specifically talk about Chandoo.org\u2019s resources on building data dashboards with… Read More »<\/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-3625","post","type-post","status-publish","format-standard","hentry","category-data-visualization"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p8ICUo-Wt","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/3625","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=3625"}],"version-history":[{"count":1,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/3625\/revisions"}],"predecessor-version":[{"id":6575,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/3625\/revisions\/6575"}],"wp:attachment":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/media?parent=3625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/categories?post=3625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/tags?post=3625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}