If your organization is looking for a powerful manipulative data analysis tool, Excel's Pivot Table may be the answer.  A Pivot Table uses two dimensional data to produce a three dimensional table based on multiple conditions that have intersecting points. They allow you to manipulate row and column headings around central data so you can view the data in different ways. A Pivot Table report is also a great way to summarize large amounts of data in a small amount of space by using a few simple steps.       Pivot Tables and Pivot Charts are "interactive" which allow you to change how you look at the data by simply dragging and dropping one field into another position.  Pivot Tables can also perform numerous calculations without you ever having to type in a formula.   A Pivot Table is organized into fields and items. Fields are the rows or columns of data; items are the specific entries within a field. At the intersection of the column and row is a field that contains numeric data which can be summarized any way you wish (i.e. summed, averaged, counted, standard deviation, etc).  For example, if you want to summarize sales data broken down by month, by sales rep; each month becomes a line item on the left side of the table, each sales rep becomes a line item across the top of the table, and the sales figures become the summary data at each intersecting point.  Thus, at a glance you are able to see a break down summary of each product line sold by each sales rep during a specific timeframe. You also have the ability filter the items based upon specific criteria using a page field.  A page field causes the pivot table to display only the data that matches the precise value.  It is a quick way to see the data you want based upon the criteria you use.  You can choose to view the data in a detail or summary format.     If you need to transform numbers into graphics, you can choose the Pivot Chart, which when selected, also creates a corresponding table. The Pivot Chart provides you with an interactive graph that is easy to manipulate.   If you are interested in learning more about Pivot Tables and Pivot Charts in Excel, this topic is covered in our Excel Mod IV or a 3-hour charting focus session. Please contact Cindy Prindle if you have any questions or Sarah Loeffelholz if you would like to register for this class. You can contact us by e-mail at cprindle@habco.com, or sloeffelholz@habco.com, or by phone at (608) 784-7737.  You can also check our calendar and register for any of our in-house and on-line classes on our website at www.habco.com, (point to The Training Center on the menu bar).  We welcome the opportunity to provide you, our client the competitive edge by helping the employees of your organization become more efficient with your software.