Thursday, February 3, 2011

Excel table or PivotTable?

In Excel, there are tables and pivot tables. You'll wonder why you would need to create a table when the entire worksheet already looks like one. And did you hear about pivot tables and complex as they are. To be able to work effectively, it helps to know what each one does and when to use one or the other.

An Excel table is simply a set of rows and columns in a worksheet that contains data related and is displayed in a table format. If you have a large list of data, it is often useful to display the data in that table. Not only as a guide to related data table is to organize, is also useful for calculating values and totals and grand totals.

Data in an Excel table format

Using a table, you can more easily:

Manage and analyze data independently of data outside of one of the many table formats to make it easier to view data and scanAdd calculated columns to calculate instantly valuesUse a total row to calculate and display data from totalsFilter in the columns of the table to display only the data that you want to quickly parse the tableApply

If you're trying to extract meaningful information from data, for example, to find out which products are selling best over time, you can use a PivotTable report instead of an Excel table. A pivot table is an interactive table that summarizes large amounts of data quickly, that can then be analyzed in detail.

By using a PivotTable, you can more easily:

The same data in a PivotTable. The PivotTable Field List lets you arrange the data the way that you want.

Display the exact data that you want to analyzePivot data for display by different data anglesFocus on specific details by expanding or collapsing the data or by applying templates to filtersMake data comparisonsDetect data, reports and trends data

For more information about Excel tables or PivotTables, see the video or the following articles:

Video: create an Excel table

Create or delete an Excel table in a worksheet

Video: Create a PivotTable report

Create or delete a PivotTable or PivotChart view

--Frederique Klitgaard

View the original article here

No comments: