Charting a New Course: Practical Data Visualization in Excel

Posted by emmawilson on January 21st, 2025 Posted in: Blog, Data Analysis, Data Visualization

---

Join us in February and March 2025 for five one-hour training sessions 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 – 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.

All librarians and library staff are welcome to participate, regardless of your library type or experience level. Please note that the example data will be drawn from academic library use cases, but the skills you’ll learn can be applied across various contexts.

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.

 

---

Session 1: Charting a New Course: Practical Data Visualization in Excel

• Register here: Zoom Registration Link
• Date: Tuesday, February 11 , 2025
• Time: 1pm – 2pm CT // 12pm – 1pm MT // 11am – 12pm PT // 2pm – 3 m ET
• Project Workbook: https://doi.org/10.18131/1nan8-mzk41

Agenda: 

1. 1. Excel Essential: Excel Essentials covers a few basic tips on navigating the workbook and basic features needed when working with data.
   2. Basics of Functions: The Basics of Functions in Excel covers some common functions for performing calculations and automating tasks.
   3. Basics of Data Cleaning: Basics of Data Cleaning in Excel covers some tools for identifying incomplete or inaccurate parts of data and replacing, modifying, or improving the data.

 

---

Session 2: Charting a New Course: Practical Data Visualization in Excel

• Register here: Zoom Registration
• Date: Tuesday, February 18, 2025
• Time: 1pm – 2pm CT // 12pm – 1pm MT // 11am – 12pm PT // 2pm – 3 m ET
• Project Workbook: https://doi.org/10.18131/1nan8-mzk41

Agenda:

1. 1. Basics of Data Transformation: The Basics of Data Transformation in Excel covers processes for adjusting data to make it organized and easier to analyze.
   2. Basics of Data Analysis: The Basics of Data Analysis in Excel covers the process of extracting meaningful insights, trends, patterns, and conclusions from data.

 

---

Session 3: Charting a New Course: Practical Data Visualization in Excel

• Register here: Zoom Registration
• Date: Tuesday, February 25, 2025
• Time: 1pm – 2pm CT // 12pm – 1pm MT // 11am – 12pm PT // 2pm – 3 m ET
• Project Workbook: https://doi.org/10.18131/1nan8-mzk41

Agenda

1. 1. Using Excel’s Power Query Tool: 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.

 

---

Session 4: Charting a New Course: Practical Data Visualization in Excel

• Register here: Zoom Registration 
• Date: Tuesday, March 4, 2025
• Time: 1pm – 2pm CT // 12pm – 1pm MT // 11am – 12pm PT // 2pm – 3 m ET
• Project Workbook: https://doi.org/10.18131/1nan8-mzk41

Agenda:

1. 1. Creating Basic Charts: Creating Basic Charts in Excel provides step-by-step instructions for creating a variety of chart types.
   2. Formatting Charts: Formatting in Excel covers options for enhancing a chart’s design to convey insights and have a polished and professional appearance.

 

---

Session 5: Charting a New Course: Practical Data Visualization in Excel

• Register here: Zoom Registration
• Date: Tuesday, March 11, 2025
• Time: 1pm – 2pm CT // 12pm – 1pm MT // 11am – 12pm PT // 2pm – 3 m ET
• Project Workbook: https://doi.org/10.18131/1nan8-mzk41

Agenda:

1. 1. Creating Advanced Charts: Creating Advanced Charts in Excel provides step-by-step ideas and creative strategies for crafting advanced charts.