by Ann Kaste
Quick Summary
This series of four one-hour sessions will provide library workers the opportunity to learn and apply essential Microsoft Excel skills.
Session Descriptions and Registration
Led by Nat Gustafson-Sundell, Collections Librarian and Professor at Minnesota State University Mankato, each session will focus on a practical library project or set of tasks. The series will not provide a comprehensive overview of Excel functionality, but will focus on selected practical skills as applied to real projects. The projects will build in difficulty from session to session.
The series will progress from novice to intermediate skills, with a mix of skills used with each project. For example, in the first session, while reviewing a sample set of purchase orders to project budgets, novice skills like sorting and filtering will be covered, but Excel functions will also be used. In subsequent sessions, you will continue using the skills learned in earlier sessions, while also adding new skills. The sessions will be focused on specific projects, but the skills will be applicable to many other kinds of projects and tasks, so even if one doesn’t perform exactly this kind of library work, the skills should be useful in other contexts.
Each session will be recorded. Handouts and sample datasets will be provided, so that participants can complete the projects on their own, between sessions. During each session, the example project will be demonstrated live. There will not be time for questions during the demonstrations, but after each session, Nat will stay in the same Zoom room for another hour to answer questions. Weekly office-hours will also be provided, so that students can ask questions and get help one-on-one.
