Skip to Main Content

Microsoft Excel Workshops: Excel Workshops (Summer 2025)

Workbooks

Pivot Tables Workshop
Includes example of messy data, data set for pivot tables, and example of drop down dependency (using data validation)

Link: Workbook Link
Data Cleaning Workbook
Workbook includes tabs for TRIM(), CONCATENATE(), Data Validation, Conditional Formatting, XLOOKUP(), Duplicate Data, and Pivot Tables
Data Visualization Workbook (Summer 2025)

Presentations

Handouts

Pivot Tables Handout
Chart Formatting Handout
This handout is associated with the Data Visualization Workbook (Summer 2025) [Dummy Data tab].