Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data illustration
Exce® pivot tables and pivot charts are ideal tools for increasing efficiency in previously time-consuming tasks involved in the analysis of library data, such as electronic resource usage statistics. Building upon the background presented in an introductory article, this companion article continues with information concerning essential techniques and applications. Data must be properly formatted in preparation for its use with pivot tables and pivot charts. Steps in the creation of both pivot tables and pivot charts are detailed along with potential pitfalls. Best practices are covered with specific tips for ensuring accurate results.
Miller, Andrea. "Application of Excel® Pivot Tables and Pivot Charts for Efficient Library Data Analysis and Illustration." Journal of Library Administration 54, no. 3 (2014): 169-186.
DOI for the article