Sunday 11 October 2009

Excel Pivot Tables

Pivot Tables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spread sheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the Pivot Table to provide alternate views of the data. Read on to find out how to create your own pivot table in Excel.Found this neat article which illustrates 3 examples.

Sunday 4 October 2009