Today’s author, Monica Poinescu, a Software Developer in Test on the Excel team, discusses two different approaches to analyzing data in Excel. 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. To better illustrate the two alternatives I’ll consider
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/03/23/analyzing-data-functions-of-pivottables.aspx
Posted
Mar 23 2009, 03:27 PM
by
Microsoft Excel