{"id":6940,"date":"2023-12-13T16:05:26","date_gmt":"2023-12-14T00:05:26","guid":{"rendered":"https:\/\/news.nnlm.gov\/nec\/?p=6940"},"modified":"2024-01-03T18:49:58","modified_gmt":"2024-01-04T02:49:58","slug":"charting-a-new-course-practical-data-visualization-for-librarians-2","status":"publish","type":"post","link":"https:\/\/news.nnlm.gov\/nec\/2023\/12\/13\/charting-a-new-course-practical-data-visualization-for-librarians-2\/","title":{"rendered":"Charting a New Course: Practical Data Visualization for Librarians\u202f\u00a0"},"content":{"rendered":"<p><span data-contrast=\"none\">J<\/span><span data-contrast=\"auto\">oin us in January and February for five NEC Micro Trainings designed to equip you with essential skills in creating compelling visualizations using Microsoft Excel. This comprehensive series covers every facet of data management in Excel \u2014 from cleaning and transforming to analyzing and visualizing both qualitative and quantitative data. While not all topics can be fully covered within each session, attendees can up-vote the most crucial topics for in-depth exploration. To enhance your learning journey, attendees receive an excel workbook, allowing you to reinforce concepts and practice skills at your own pace. Each session is self-contained. Attendees are encouraged to choose specific sessions based on their needs and familiarity with the subject matter. <a href=\"https:\/\/redcap.link\/PracticalDataVisualization\">Registration required<\/a><\/span><\/p>\n<p><b><span data-contrast=\"auto\">Thursday, January 18, 1-2 p.m.<\/span><\/b><strong> CT (2-3 p.m. ET \u2014 11 a.m.-12 p.m. PT)<\/strong><\/p>\n<ul>\n<li>Excel Essential:<span data-contrast=\"auto\"> Excel Essentials covers a few basic tips on navigating the workbook and basic features needed when working with data.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li>Basics of Functions<span data-contrast=\"auto\">: The Basics of Functions in Excel covers some common functions for performing calculations and automating tasks.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li>Basics of Data Cleaning:<span data-contrast=\"auto\"> Basics of Data Cleaning in Excel covers some tools for identifying incomplete or inaccurate parts of data and replacing, modifying, or improving the data.<\/span><\/li>\n<li><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><a href=\"https:\/\/redcap.link\/PracticalDataVisualization\">Registration required<\/a>\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">Thursday, February 1, 12-1 p.m.<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"> <strong>CT (1-2 p.m. ET \u2014 10 a.m.-11 a.m. PT)<\/strong><\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\">Basics of Data Transformation<span data-contrast=\"auto\">: The Basics of Data Transformation in Excel covers processes for adjusting data to make it organized and easier to analyze.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"1\">Basics of Data Analysis<span data-contrast=\"auto\">: The Basics of Data Analysis in Excel covers the process of extracting meaningful insights, trends, patterns, and conclusions from data.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\"><a href=\"https:\/\/redcap.link\/PracticalDataVisualization\">Registration required<\/a><\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">Thursday, February 8, 1-2 p.m.<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"> <strong>CT (2-3 p.m. ET \u2014 11 a.m.-12 p.m. PT)<\/strong><\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"6\" data-aria-level=\"1\">Using Excel\u2019s Power Query Tool<span data-contrast=\"auto\">: The Power Query Tool in Excel session covers how to import, transform, and clean data from diverse sources, gaining essential skills to streamline your data preparation and analysis workflow.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"6\" data-aria-level=\"1\"><span data-contrast=\"auto\"><a href=\"https:\/\/redcap.link\/PracticalDataVisualization\">Registration required<\/a><\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">Thursday, February 15, 1-2 p.m.<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"> <strong>CT (2-3 p.m. ET \u2014 11 a.m.-12 p.m. PT)<\/strong><\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"7\" data-aria-level=\"1\">Creating Basic Charts<span data-contrast=\"auto\">: Creating Basic Charts in Excel provides step-by-step instructions for creating a variety of chart types.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"8\" data-aria-level=\"1\">Formatting Charts:<span data-contrast=\"auto\"> Formatting in Excel covers options for enhancing a chart&#8217;s design to convey insights and have a polished and professional appearance.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"8\" data-aria-level=\"1\"><span data-contrast=\"auto\"><a href=\"https:\/\/redcap.link\/PracticalDataVisualization\">Registration required<\/a><\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">Thursday, February 22, 1-2 p.m.<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"> <strong>CT (2-3 p.m. ET \u2014 11 a.m.-12 p.m. PT)<\/strong><\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"9\" data-aria-level=\"1\">Creating Advanced Charts<span data-contrast=\"auto\">: Creating Advanced Charts in Excel provides step-by-step ideas and creative strategies for crafting advanced charts.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"9\" data-aria-level=\"1\"><span data-contrast=\"auto\"><a href=\"https:\/\/redcap.link\/PracticalDataVisualization\">Registration required<\/a><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Join us in January and February for five NEC Micro Trainings designed to equip you with essential skills in creating compelling visualizations using Microsoft Excel. This comprehensive series covers every facet of data management in Excel \u2014 from cleaning and transforming to analyzing and visualizing both qualitative and quantitative data. While not all topics can&#8230; <a href=\"https:\/\/news.nnlm.gov\/nec\/2023\/12\/13\/charting-a-new-course-practical-data-visualization-for-librarians-2\/\">Read More &raquo;<\/a><\/p>\n","protected":false},"author":2981,"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-6940","post","type-post","status-publish","format-standard","hentry","category-data-visualization"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p8ICUo-1NW","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/6940","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\/2981"}],"replies":[{"embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/comments?post=6940"}],"version-history":[{"count":8,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/6940\/revisions"}],"predecessor-version":[{"id":6950,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/posts\/6940\/revisions\/6950"}],"wp:attachment":[{"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/media?parent=6940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/categories?post=6940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/news.nnlm.gov\/nec\/wp-json\/wp\/v2\/tags?post=6940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}