Skip to Main Content
University of Mississippi Libraries
Library Guides
Microsoft Excel Workshops
Excel Workshops (Summer 2025)
Search this Guide
Search
Microsoft Excel Workshops: Excel Workshops (Summer 2025)
Data Visualization (Fall 2022)
Pivot Tables (Spring 2023)
Pivot Tables (Fall 2023)
Excel Workshops (Spring 2024)
Excel Workshops (Spring 2025)
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
Excecl Basics Presentation
Excel Data Visualization Presentation
Excel LOOKUP Fuctions Presentation
Excel Pivot Tables Presentation
Handouts
Scatterplot Handout
Pivot Chart Handout
Calculated Fields Handout
Pivot Tables Handout
Chart Formatting Handout
This handout is associated with the Data Visualization Workbook (Summer 2025) [Dummy Data tab].
<<
Previous:
Excel Workshops (Spring 2025)