Introduction to Using Excel® Pivot Tables and Pivot Charts to Increase Efficiency in Library Data Analysis and Illustration
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.
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.
Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data illustration
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 of Library Administration