Analyzing Data: Functions or Pivot Tables
Link:
Excel Blog Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, discusses two different approaches to analyzing data in Excel.
Edit: I've attached a file at the bottom of this blog that contains spreadsheets of the examples discussed in this post.
My earlier blog on the new Excel 2007 function SUMIFS spawned a very interesting discussion (thanks to everyone who posted comments there): when trying to analyze/aggregate data in a table, how do we decide whether to use functions versus PivotTables?
This blog outlines reasons to use one option or another.
