Analyzing Library Collection Use with Excel

Includes Excel[registered] formulas to translate circulation and collection data into meaningful reports for making strategic decisions. This work gives the ready tools to: process raw data into usable information; understand and identify the relevant types of analysis; build on the strengths identified in the collection analysis; and more.

---

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.