WEBINAR
Crash Data Analysis: What Your Fleet’s History is Telling You
Wednesday, June 17th | 1-2 PM CST
Unlock the full potential of Microsoft Excel in this essential webinar with SMSC Safety Consultant Barry Wertz. We'll guide you through essential features that turn raw data into actionable insights—including PivotTables for dynamic summarization, Power Query for automated data cleaning and combining large data sets, and the Data Analysis ToolPak for statistical analysis, forecasting, and regression.
You'll also discover how Charts, Sparklines, and Conditional Formatting can help you communicate trends instantly. Join us to build practical Excel skills that make your data analysis faster, more accurate, and more efficient.

June 17, 2026


1:00 PM

VIRTUAL
Learning Objectives
By attending this webinar, you will be able to...
Select the right data for meaningful loss analysis, understanding what variables and data points matter most when building a strong, reliable data set.
Use Excel's built-in tools to efficiently organize, sort, and analyze loss data in a way that surfaces patterns and trends you can act on.
Interpret what your data is telling you, moving beyond the numbers to draw actionable conclusions that inform smarter risk management decisions.
Present your findings clearly and confidently using charts and tables that communicate the full story behind the data to stakeholders at any level.
Your Host

Barry Wertz
Safety Consultant, SMSC
Upcoming Events

WEBINAR SERIES
September 24, 2026
Open Enrollment – Renewal Checklist

WEBINAR
June 16th, 2026
Preparing for the Future of Care: Why Employers Are Prioritizing Long-Term Care Benefits

WEBINAR
August 20, 2026
HSAs vs. FSAs
vs. HRAs

IN-PERSON
July 22, 2026
Healthcare Costs Panel Discussion / Peoria, IL

WEBINAR
July 16, 2026
Mid-Year Regulatory Update

IN-PERSON