In this unique guide, two collection development experts have tailored proven Excel[registered] formulas to translate circulation and collection data into meaningful reports for making strategic decisions. Step-by-step instructions, along with screen shots, allow anyone to set up a simple library-focused Excel[registered] program. ""Analyzing Library Collection Use with Excel[registered]"" gives library collection analysts in public, school, academic, and special libraries the ready tools to: process raw data into usable information; understand and identify the most relevant types of analysis; build on the strengths identified in the collection analysis and address weaknesses; illustrate circulation issues using charts and graphs; and, maximize return with Excel[registered] program tips and recommendations. Featuring examples and how-to based on the three most popular integrated library systems, this hands-on guide shows how to set up customized spreadsheets, receive data dumps from your existing integrated library system, and process all data into usable summaries.
Tony Greiner, librarian at Portland (OR) Community College, works on collection development, reference, and bibliographic instruction.. He holds his MLS from Emporia State University SLIS. Robert Cooper has fourteen years of collection development experience in public and special libraries, including ten years' work with Microsoft's Office Suite (including Excel[registered]). He holds his MLS from the University of Denver.