Peer-2-Peer Workshop: Excel Demystified

A special 3-hour Excel workshop designed specifically for library managers. This session will blend practical demonstrations, hands-on practice, and time to work on your own real-world projects. Whether you’re new to Excel or looking to sharpen your skills, you’ll leave with tools you can immediately apply to your daily work.

Workshop Overview

Hour 1 – Everyday Tricks & Quick Wins

Building the Basics! Discover simple Excel shortcuts and formatting tips that save time and make your spreadsheets cleaner and easier to read. Learn how to create interactive tables, highlight key data, and use basic formulas to summarize information.

Hour 2 – Data Mastery & Automation

Dive into more advanced tools for cleaning and analyzing data. Explore functions to split or combine text, work with dates, create dropdown lists, and apply conditional logic to automate calculations.