Title
Introduction to Using Excel® Pivot Tables and Pivot Charts to Increase Efficiency in Library Data Analysis and Illustration
Abstract
Excel® offers powerful features that can spare its users countless hours of tedious and unnecessary effort. Pivot tables and pivot charts are robust tools that can streamline the work of analyzing library data, making it nearly instantaneous, visually engaging, and efficient. Although electronic resource usage statistics will be used for illustrative purposes, countless types of data in a tabular format are suited to the application of pivot tables and pivot charts. This article will discuss background and approaches for using these tools, followed by a companion article that will demonstrate essential techniques and applications.
Department(s)
MSU Libraries
Document Type
Article
DOI
https://doi.org/10.1080/01930826.2014.903365
Rights Information
This is an electronic postprint version of an article published in Journal of Library Administration 54, no. 2 (2014): 94-106. Journal of Library Administration is available online at: http://www.tandfonline.com/doi/abs/10.1080/01930826.2014.903365.
Keywords
Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data illustration
Publication Date
2014
Recommended Citation
Miller, Andrea. "Introduction to using Excel® pivot tables and pivot charts to increase efficiency in library data analysis and illustration." Journal of Library Administration 54, no. 2 (2014): 94-106.
Journal Title
Journal of Library Administration
Additional Information
This is an electronic postprint version of an article published in Journal of Library Administration 54, no. 2 (2014): 94-106. Journal of Library Administration is available online at: http://www.tandfonline.com/doi/abs/10.1080/01930826.2014.903365.