Using Microsoft Excel for the State Report

Using Microsoft Excel for the State Report

Does the thought of the CT State Library report fill you with fear? Do you spend days trying to make your statistics add up?  Then sign up for this fun class with Excel-lover Caitlin Augusta and approach your data collection with new confidence. The class will begin with an informal Q&A discussion about the State Report with Tom Newman, State Library Data Coordinator. Then, we'll discuss how to use Excel to track your library's statistics all year long, saving you time and stress. Master basic functions, linked sheets, and simple graphics. A basic understanding of Excel, the State Library report, and a fearless attitude is helpful.


  • To learn Excel functions that make data collection less tedious.
  • To learn conditional formatting and sheet references that will further automate library statistical analysis.
  • To create basic graphs from existing Excel data for in-house reports and community outreach.
Thursday, September 21, 2017
9:00am - 12:00pm
Caitlin Augusta and Tom Newman
Middletown Library Service Center, 786 South Main St., Middletown
DLD Workshop
Registration has closed.

To register for a DLD workshop or webinar, you must be a current staff member, Friend, or Board Member/Trustee of a library in CT. If you are an unemployed librarian in CT, please contact Steve Cauffman (  or 860-704-2223) to register.

Cancellation Policy

If you cannot attend a workshop you have registered for, please remember to cancel at least 3 days in advance so we can give your spot to someone else. You can cancel via the link in your confirmation email, or by contacting Steve Cauffman | (860) 704-2223.

Those who miss (without cancelling) 3 events within a 6-month period will be placed on the waiting list when registering for future events. Be sure to sign in when you arrive for any workshop.

Inclement Weather Policy

For all in-person workshops offered by the CT State Library, Division of Library Development:

If the public schools in the town where the workshop is to be held close due to weather, the workshop will be canceled. If the schools have a delay, the workshop will go on as scheduled.

For the most up-to-date information, call us at 860-704-2200.

IMLS logo
Continuing Education workshops and the professional development collection are funded in part by the Institute of Museum and Library Services under the provisions of the Library Services and Technology Act, administered by the Connecticut State Library.