Spreadsheets for Librarians: Getting Results with Excel and Google Sheets
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 turban 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.

1134938842
Spreadsheets for Librarians: Getting Results with Excel and Google Sheets
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 turban 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.

41.49 In Stock
Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

by Bruce White
Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

Spreadsheets for Librarians: Getting Results with Excel and Google Sheets

by Bruce White

eBook

$41.49  $55.00 Save 25% Current price is $41.49, Original price is $55. You Save 25%.

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers

LEND ME® See Details

Overview

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 turban 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.


Product Details

ISBN-13: 9781440869327
Publisher: ABC-CLIO, Incorporated
Publication date: 01/11/2021
Sold by: Barnes & Noble
Format: eBook
Pages: 305
File size: 52 MB
Note: This product may take a few minutes to download.

About the Author

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

Table of Contents

Preface vii

Chapter 1 Spreadsheets Are for You 1

Chapter 2 The Basics 19

Chapter 3 Starting With Formulas 51

Chapter 4 Moving Forward With Formulas 72

Chapter 5 Working With Words 85

Chapter 6 Conditional Functions 117

Chapter 7 Lookups and Matches 144

Chapter 8 The Power of Pivot Tables 170

Chapter 9 Looking at Graphs and Charts 238

Chapter 10 Flat Files and Data Imports 5 252

Chapter 11 Multiple Spreadsheets and Data Ecosystems 275

Chapter 12 Conclusion 294

Suggested Readings 297

Index 301

What People are Saying About This

Tony Greiner

"Experienced users of Excel and other spreadsheets will find this book useful in going to the next level."

Anne Goulding

"In this instructive and accessible text, Bruce White enthusiastically champions the use of Excel by librarians, focusing on how they can use this powerful application to help make many of their day-to-day processes more efficient and their decision-making better informed. Illustrated by well-worked and relevant examples from a range of types of library and information services, White walks readers step-by-step through the basics of navigating around and setting up spreadsheets, through using formulas, on to pivot tables and beyond. For both new and more experienced users, this book will be of great support to librarians in their use of spreadsheets for a wide variety of data management, analysis, and visualization purposes."

From the B&N Reads Blog

Customer Reviews