Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

by
Bruce Whiteauthor

Bruce White is copyright and open access advisor at Massey University, New Zealand. He has worked in both public and university libraries.

Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

20210111

Libraries Unlimited

Pages 316
Topics Accounting and Financial Analysis;Bibliometric Studies;Collection Management;Data Migration;Library Use Studies;Patron Roll Management;Research Data Management;Staff Management;Statistical Analysis;Information Systems and Technology: Database and Other Retrieval Systems

Cite this eBook

  • eBook

    9781440869327

Description
Table of Contents

Table of Contents

Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

Author(s): White, Bruce;
Contributors: White, Bruce;
Abstract:

Work smarter and save time with the librarian's guide to the hidden-in-plain-sight secrets of Excel, Sheets, and other types of spreadsheets.

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.


  • Illustrates spreadsheet techniques that are immediately applicable in a wide variety of library contexts
  • Explains the potential of readily available data as a means to enhance individual and institutional performance in the library and information sector
  • Helps librarians think like data and information specialists
  • Showcases skills that are portable and independent of more narrowly-focused software packages
  • Shows how to communicate more effectively with IT specialists

SortTitle: spreadsheets for librarians: getting results with excel and google sheets
Keyword(s): Accounting and Financial Analysis; Bibliometric Studies; Collection Management; Data Migration; Library Use Studies; Patron Roll Management; Research Data Management; Staff Management; Statistical Analysis; Information Systems and Technology: Database and Other Retrieval Systems
Author Info:
Bruce Whiteauthor

Bruce White is copyright and open access advisor at Massey University, New Zealand. He has worked in both public and university libraries.

eISBN-13: 9781440869327
Cover Image URL: ~~FreeAttachments/9781440869327.jpg
Print ISBN-13: 9781440869310
Imprint: Libraries Unlimited
Pages: 316
Publication Date: 20210111