Introduction to Using Excel^® Pivot Tables and Pivot Charts to Increase Efficiency in Library Data Analysis and Illustration

REFERENCES

• Aitken, P. (2007). Excel® 2007 PivotTables and PivotCharts. Indianapolis, IN: Wiley Publishing, Inc.
   Google Scholar
• Alexander, M., & Walkenbach, J. (2010). Excel® dashboards and reports. Hoboken, NJ: Wiley.
   Google Scholar
• Aloisio, J.J., & Winterfeldt, C.G. (2010). Rethinking traditional staffing models. Radiology Management, 32(6), 32–38.
   PubMedGoogle Scholar
• Altom, T. (2011, May 23). Time digging into Excel ‘goodies’ will pay off. Indianapolis Business Journal, p. 25A.
   Google Scholar
• Chen, J. (2007). Analyzing business data with PivotTable report. The Business Review, Cambridge, 9(1), 23–28.
   Google Scholar
• Conmy, C., Hazlett, B., Jelen, B., & Soucy, A. (2006). Excel for teachers. Uniontown, OH: Holy Macro! Books.
   Google Scholar
• Convery, S.P., & Swaney, A.M. (2012). Analyzing business issues–with Excel: The case of Superior Log Cabins, Inc. Issues in Accounting Education, 27(1), 141–156.
   Google Scholar
• Curtis, D., Scheschy, V.M., & Tarango, A.R. (2000). Developing and managing electronic journal collections: A how-to-do-it manual for librarians. New York, NY: Neal-Schuman Publishers, Inc.
   Google Scholar
• Dalgleish, D. (2007a). Beginning pivot tables in Excel 2007. Berkeley, CA: Apress.
   Google Scholar
• Dalgleish, D. (2007b). Excel 2007 PivotTables recipes: A problem-solution approach. Berkeley, CA: Apress.
   Google Scholar
• Dodge, M., & Stinson, C. (2011). Microsoft® Excel® 2010 inside out. Redmond, WA: Microsoft Press.
   Google Scholar
• Eckert, C. (2005). Creating a company report card: Pivot tables allow you to analyze your numbers any way you want. Here's how to build one. The Journal of Light Construction, 23(6), 135–144.
   Google Scholar
• Efstathiou, J., & Golby, P. (2001). Application of a simple method of counting for product demand and operation sequence. Integrated Manufacturing Systems, 12(4), 246–257.
   Google Scholar
• Frye, C. (2010). Microsoft® Excel® 2010 step by step. Redmond, WA: Microsoft Press.
   Google Scholar
• Fuller, L.U., Fulton, J., Hayes, D., & Riley, J.A. (2011). Picture yourself learning Microsoft® Excel® 2010. Boston, MA: Course Technology.
   Google Scholar
• Green, K. (2008). Pivot tables can turn your record keeping around. Mathematics Teacher, 101(9), 678–681.
   Google Scholar
• Greiner, T., & Cooper, B. (2007). Analyzing library collection use with Excel®. Chicago, IL: American Library Association.
   Google Scholar
• Hamming, R.W. (1962). Numerical methods for scientists and engineers. New York, NY: McGraw-Hill Book Company, Inc.
   Google Scholar
• Harvey, G. (2010). Excel® 2010 for dummies®. Hoboken, NJ: Wiley.
   Google Scholar
• Huber, J. (2005). Ask Mr. Technology. Library Media Connection, 23(4), 61.
   Google Scholar
• Hunstad, M. (2010). Paradise by the dashboard. AFP Exchange, 30(9), 47–50.
   Google Scholar
• Jelen, B. (2010a). Microsoft® Excel® 2010 in depth. Indianapolis, IN: Que.
   Google Scholar
• Jelen, B. (2010b). Reporting a count of records by geography. Strategic Finance, 91(9), 54–55.
   Google Scholar
• Jelen, B. (2010c). Troubleshooting row labels in pivot tables. Strategic Finance, 92(4), 60–61.
   Google Scholar
• Jelen, B. (2010d). Year-over-year analysis using Excel. Strategic Finance, 91(7), 54–55.
   Google Scholar
• Jelen, B. (2011a). Charts and graphs: Microsoft® Excel® 2010. Indianapolis, IN: Que.
   Google Scholar
• Jelen, B. (2011b). Frequency distribution. Strategic Finance, 93(1), 52–53.
   Google Scholar
• Jelen, B. (2011c). Ranking values in a pivot table. Strategic Finance, 92(11), 60–61.
   Google Scholar
• Jelen, B. (2012). Counting values within a range. Strategic Finance, 93(8), 54–55.
   Google Scholar
• Jelen, B., & Alexander, M. (2007). Pivot table data crunching for Microsoft® Office Excel® 2007. Indianapolis, IN: Que.
   Google Scholar
• Jelen, B., & Alexander, M. (2011). Pivot table data crunching: Microsoft® Excel® 2010. Indianapolis, IN: Que.
   Google Scholar
• Jones, J.L. (2011). Using library swipe-card data to inform decision making. Georgia Library Quarterly, 48(2), 11–13.
   Google Scholar
• Lehman, M.W., Lehman, C.M., & Feazell, J. (2011). Dashboard your scorecard. Journal of Accountancy, 211(2), 20–27.
   Google Scholar
• MacDonald, M. (2010). Excel 2010: The missing manual. Sebastopol, CA: O’Reilly Media, Inc.
   Google Scholar
• Matthews, T.E. (2009). Improving usage statistics processing for a library consortium: The Virtual Library of Virginia's Experience. Journal of Electronic Resources Librarianship, 21(1), 37–47.
   Google Scholar
• McFedries, P. (2010a). Excel® PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets. Indianapolis, IN: Wiley Publishing, Inc.
   Google Scholar
• McFedries, P. (2010b). Formulas and functions: Microsoft® Excel 2010. Indianapolis, IN: Que.
   Google Scholar
• Microsoft® Excel® (2010) [Computer software]. Redmond, WA: Microsoft®.
   Google Scholar
• Mills, L. (2006). Transforming data into knowledge. Principal Leadership (High School Ed.), 7(2), 44–48.
   Google Scholar
• Montondon, L., & Marsh, T. (2006). Pivot tables: A means to quick, accurate trial balances. The CPA Journal, 76(4), 68–70.
   Google Scholar
• Ting, P., Pan, S., & Chou, S. (2010). Finding ideal menu items assortments: An empirical application of market basket analysis. Cornell Hospitality Quarterly, 51(4), 492–501. doi: 10.1177/1938965510378254
   Web of Science ®Google Scholar
• Walkenbach, J. (2010a). Excel® 2010 bible. Indianapolis, IN: Wiley.
   Google Scholar
• Walkenbach, J. (2010b). Excel® 2010 formulas. Hoboken, NJ: Wiley.
   Google Scholar
• Wesley, D., & Cox, H.F. (2007). Pivot tables for mortality analysis, or who needs life tables anyway? Journal of Insurance Medicine, 39(3), 167–173.
   PubMedGoogle Scholar