Formula vs PivotTable Reports

Sample Excel File: <a href="https://www.excel-university.com/wp-content/uploads/SUMIFS-vs-PivotTables1.xlsx">SUMIFS vs PivotTables
Free PivotTable Course: <a href="http://store.excel-university.com/product?catalog=EUV3C03OD1" target="_blank">PivotTable Basics
Book: Excel University Volume 3
Related JofA article: <a href="http://www.journalofaccountancy.com/Issues/2014/Apr/Excel-mapping-20138815.htm" target="_blank">The Power of Mapping
Blog: <a title="Excel University Blog" href="https://www.excel-university.com/blog" target="_blank">Excel University Blog
Connect on LinkedIn: <a title="Jeff Lenning" href="https://www.linkedin.com/in/jefflenning" target="_blank">Jeff Lenning

Article Overview

Formula-Based Report

PivotTable Report

This article explores the differences between formula-based and PivotTable reports. It is an adaptation of Excel University Volume 3, Chapter 11.

Article Title: Formula vs PivotTable Reports

Publication: Journal of Accountancy

By: Jeff Lenning CPA CITP

Article Resources