Document Type

Article

Publication Date

2014

Keywords

Excel® PivotTables, Excel® PivotCharts, pivot tables, pivot charts, library data analysis, library data 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.

Comments

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.

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.

DOI for the article

10.1080/01930826.2014.903365

Department

Libraries

Share

COinS