In this session, we explore the power of Excel to create meaningful data visualizations for prevention professionals. Participants are guided through real-life examples of applying the 4-step visualization process using Excel to create a meaningful data story for a prevention audience. Excel is a practical and accessible tool for creating data visualizations for prevention professionals who may not have access to expensive software packages. This is a beginner's guide to using Excel for visualization.
Select the View Resource button above to watch the recording. Here is the PowerPoint for this webinar.
If you would like to follow along to create a data visualization during the recording, open the companion materials below. The Creating Data Visualization Instructions document outlines the steps. When the Data Excel File link is selected, it will download the Excel file to your computer.
For more training and resources, check out the Ditching the Discomfort to Data Series. Part 5, Communicating and Visualizing Data explores methods for prevention professionals to effectively disseminate data-related information.
Sheila Boswell is a highly experienced project coordinator that serves as the assistant evaluator for the South Southwest Prevention Technology Transfer Center (SSW PTTC). She writes, designs, and analyzes data for training and technical assistance (T/TA) reports, as well as helps publicize services to optimize client relationships, engagement, and success with the center's grant opportunities and T/TA. Her work plays a vital role in providing high-impact services to the prevention workforce, emerging prevention professionals, organizations, and community prevention stakeholders.
During her eight years at the University of Oklahoma, Sheila has worked as an evaluator for state and federal programs concentrating on mental health and substance misuse prevention. She communicates evaluation findings using graphics and data visualizations to inform decision-making. Through collaboration with her SSW PTTC team and partners, she focuses on creating deliverables that include the principles of diversity, equity, and inclusion with a positive message to achieve successful program outcomes.