
- 316 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
About this book
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.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
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