Using Excel & AI to Strengthen Data-Driven SUD Prevention, Treatment, and Recovery Services
Downloadable materials for presentation at ASADS Conference on March 24, 2026.
#1: Download the Dataset: The following dataset is available for your use to learn how to use the tools and follow along with the videos. Enjoy!
#2: Take the Scorecard: The following scorecard is a diagnostic for behavioral and public health leaders seeking to demonstrate impact and secure state and federal funding. This tool offers a structured way to assess whether your strategy, measurement systems, and funding positioning are aligned, or whether gaps may be creating unnecessary risk.
#3 Extra Resources: The following YouTube videos provide an example of some of the strategies used in the presentation on a different dataset. They may provide useful context/background to reference after the presentation.
Video 1: How to Set Up and Organize Data in Excel
In this video, you’ll learn the basics of setting up a clean, well-organized dataset in Excel for program evaluation. I’ll show you best practices for entering data, naming variables, and structuring your spreadsheet to prepare for analysis.
Video 2: How to Clean Data and Use Formulas in Excel
This video covers simple but essential Excel skills for cleaning your data and using basic formulas like COUNT, COUNTA, SUM, and AVERAGE. You’ll also learn tips for spotting errors, inconsistencies, and missing data.
Video 3: How to Use Pivot Tables and Create Charts in Excel
Pivot tables are a powerful tool in Excel for summarizing data quickly. In this video, you’ll learn how to create pivot tables, use filters, and generate charts to visualize your data in ways that are accessible to stakeholders.
Video 4: How to Explore Frequencies, Percents, and Measures of Central Tendency in Excel
In this video, you’ll learn how to calculate frequencies and percentages for categorical variables like gender or race/ethnicity, and how to calculate the mean, median, and mode for continuous variables like age or outcome scores.
Video 5: How to Run a Chi-Square Test in Excel
Chi-square is a test used to explore relationships between two categorical variables. In this video, you’ll learn how to use Excel’s CHISQ.TEST function to determine whether differences between groups are statistically significant.
Video 6: How to Run a T-Test and ANOVA in Excel
In this final video, I’ll walk you through how to use Excel to run a paired-samples t-test (comparing pre- and post-test scores) and a single-factor ANOVA (comparing means across three or more groups). I’ll also talk about how to interpret p-values and what these tests tell us in the context of social work evaluation.