This session is part of the Microsoft 365 for SEFLIN Libraries Series, an 8-week professional development program for SEFLIN librarians, educators, and library staff. Designed to enhance productivity and service delivery, each 60-minute session combines direct instruction with hands-on practice.
Week 6: Excel for Intermediates:
- Focus: Data analysis and visualization for library reporting.
- Tables: Converting ranges into Tables.
- Sorting and Filtering: Using multi-level sorting and advanced filtering.
- Visualization: Creating charts and sparklines.
- Logic and Formatting: Conditional Formatting and Data Validation.
- Practice (15 mins): Convert a list of books into a Table and highlight overdue dates.
About the Microsoft 365 for SEFLIN Libraries Series
The Microsoft 365 for SEFLIN Libraries Series is an 8-week professional development program designed specifically for library staff looking to build confidence and efficiency with the Microsoft applications they use every day. Each 60-minute session combines practical instruction with hands-on activities focused on real-world library workflows.
Whether you're creating presentations, managing email, analyzing data, or producing professional documents, you'll leave each session with skills you can immediately apply in your work.
Skills Developed Across the Series:
- Creating effective presentations with PowerPoint
- Managing email and calendars in Outlook
- Creating Slides: Choosing between blank presentations and templates or themes to establish a professional look.
- Organizing and analyzing data in Excel
- Creating polished documents in Word
- Improving workplace productivity and collaboration
You are welcome to register for one, several, or all eight sessions—each workshop stands on its own, and no prior attendance is required.
Presenter:
Jonathan Gordon is an educator, author, instructional designer, and professional development trainer specializing in digital design, creative technology, artificial intelligence, and workforce readiness. With a career spanning classroom teaching, curriculum development, and international training, he has helped thousands of students and educators develop practical skills in Adobe Creative Cloud, Microsoft Office, web design, digital marketing, and emerging technologies.
As the author of Learn Adobe InDesign CC, Jonathan has long been recognized for his expertise in design and publishing workflows. He has taught courses in graphic design, web development, business applications, communication skills, and digital literacy, while creating certification-aligned curriculum and project-based learning experiences.
Jonathan has delivered workshops and training sessions throughout the United States and internationally, helping educators integrate technology in meaningful ways while preparing students for college, careers, and industry certifications.
A self-described "font snob" and lifelong learner, Jonathan is passionate about making complex technology accessible, engaging, and relevant through hands-on learning and real-world applications.
Register to attend
Hosted by SEFLIN