Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

✍ Scribed by Bruce White

• Publisher: Libraries Unlimited
• Year: 2021
• Tongue: English
• Leaves: 317
• Category: Library

✦ Synopsis

While some librarians have become very skilled at using the full power of Excel and Sheets to turn data into useful and valuable information, for many librarians the relevance of spreadsheets―and how to use them―is not necessarily obvious.

This book demystifies Excel and other spreadsheets. Starting from basic concepts, the book progresses to advanced implementations important to librarians in such areas as collection management, including evaluation and benchmarking; research assessment through the creation of sophisticated bibliometric measures; and library design based on an analysis of patron behavior or the creation of a keyword map of physical collections. Real-life examples highlight a variety of techniques and shortcuts that can be immediately applied to libraries of all kinds.

Spreadsheets for Librarians is a book for the desk, not only the library shelves. No prior knowledge of spreadsheets is needed, and readers can expect to learn skills that will enhance their reputation as information and data professionals.

✦ Table of Contents

Cover
Title Page
Copyright
Contents
Preface
Chapter 1. Spreadsheets Are for You
Chapter 2. The Basics
Chapter 3. Starting With Formulas
Chapter 4. Moving Forward With Formulas
Chapter 5. Working With Words
Chapter 6. Conditional Functions
Chapter 7. Lookups and Matches
Chapter 8. The Power of Pivot Tables
Chapter 9. Looking at Graphs and Charts
Chapter 10. Flat Files and Data Imports
Chapter 11. Multiple Spreadsheets and Data Ecosystems
Chapter 12. Conclusion
Suggested Readings
Index