You are here

Excel spreadsheets can help you handle a wide range of library activities. Do you ever need to

  • Keep track of volunteers and their hours?
  • Allocate materials funds by department?
  • Manage and sort lists of items?
  • Create sign-off sheets to track staff work on ongoing tasks such as shelf reading?
  • Arrange desk/duty schedules?
  • Count and project Internet use by per day/week/month?

If you'd like to learn how to manage these or similar tasks in a format that can be easily saved, printed, and emailed, this basic Excel class is for you.

And if you have been reluctant to tackle Excel, come and give it a try. You will be surprised what a basic understanding of the program will enable you to accomplish. The skills you learn in this workshop will help you do your job more efficiently with just a little effort.

Workshop Description: In this all-day hands-on workshop, students will learn how to create basic Excel worksheets and charts. Through library-oriented exercises you will learn how to format, enter data into, save, and print a worksheet in Excel. You will also learn how to create formulas and to perform simple calculations in Excel, and to manage lists of items. The instructor will also provide an Excel vocabulary list and cheat sheets, as well as practical, useful tips that can be applied immediately.

Preliminary Course Outline:

  • Creating a Worksheet in Excel
    • Enter information into the worksheet
    • Format the worksheet
    • Move around within the worksheet
    • Alphabetize within the worksheet
    • Use AutoSum
  • Working with Formulas
    • What is a formula?
    • Why do worksheets need to use formulas?
    • How to construct a simple formula
  • Creating Charts and Graphs
    • Managing Data in a List
    • Printing and Saving Worksheets

Workshop Instructor: Sandy Lamoureux