|
![]() |
|||
|
||||
OverviewWork 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. Full Product DetailsAuthor: Bruce WhitePublisher: Bloomsbury Publishing Plc Imprint: Libraries Unlimited Inc Weight: 0.510kg ISBN: 9781440869310ISBN 10: 1440869316 Pages: 316 Publication Date: 11 January 2021 Recommended Age: From 7 to 17 years Audience: Professional and scholarly , College/higher education , Professional & Vocational , Tertiary & Higher Education Format: Paperback Publisher's Status: Active Availability: Manufactured on demand ![]() We will order this item for you from a manufactured on demand supplier. Table of ContentsPrefacevii Chapter 1Spreadsheets Are for You Chapter 2The Basics Chapter 3Starting With Formulas Chapter 4Moving Forward With Formulas Chapter 5Working With Words Chapter 6Conditional Functions Chapter 7Lookups and Matches Chapter 8The Power of Pivot Tables Chapter 9Looking at Graphs and Charts Chapter 10Flat Files and Data Imports Chapter 11Multiple Spreadsheets and Data Ecosystems Chapter 12Conclusion Suggested Readings297 Index301ReviewsWhite's writing style brings clarity and humor to the dry, technical task of mastering spreadsheets. Despite the library-specific examples, this offering will also appeal to other professionals looking for strategies to increase efficiency in their work. - Library Journal With clear explanations and library-work relevance, this perennially insightful guide will be especially helpful to those working remotely. - American Libraries Conversational in tone but still authoritative, this is a must-have guide for librarians in a wide range of roles who want to work smarter. - Booklist Online """White’s writing style brings clarity and humor to the dry, technical task of mastering spreadsheets. Despite the library-specific examples, this offering will also appeal to other professionals looking for strategies to increase efficiency in their work."" - Library Journal ""With clear explanations and library-work relevance, this perennially insightful guide will be especially helpful to those working remotely."" - American Libraries ""Conversational in tone but still authoritative, this is a must-have guide for librarians in a wide range of roles who want to work smarter."" - Booklist Online" Author InformationBruce White is copyright and open access advisor at Massey University, New Zealand. He has worked in both public and university libraries. Tab Content 6Author Website:Countries AvailableAll regions |