Monday, April 4, 2011

She asked about PivotTables (video)

Many customers ask "pivot table" that we have collected the best answers in this blog post. Most likely, looking for information about how to create a PivotTable report that can help you to summarize and analyze the data. Or already data in a PivotTable report and are looking for information on how to pin it.

Example of a PivotTable report

Example of a PivotTable report

To follow A three-step process for inserting a PivotTable report is based on worksheet data, look at the quick start: create a PivotTable report.

To get the full scoop on tables (and PivotCharts) or to create a PivotTable that is based on an external data source, you should follow the instructions in create or delete a PivotTable or PivotChart reportinstead.

Because the PivotTables are not easy to understand, the video that follows can be useful.

Six new on PivotTables? In this case, I recommend that you start with this popular training course written by my colleague, Judi Hurlock, PivotTable i: get started with PivotTable reports in Excel 2007. Definitely helped me out when I Got started.

If you are using an earlier version of Excel, you may also enjoy this article Pivot, Swivel, and roll by Crabby Office Lady, which provides an interesting overview of PivotTables, those flexible little contortionists of the data world!

Excel is the Office application to use for the in-depth analysis of data, but if you keep your data in an Access database, you can work on it there as well. The article Create or delete a PivotTable or PivotChart report should help you get started.

After you create a PivotTable, it makes sense that you'll want to pivot data to view it from different angles. Unfortunately, to better match the actual features that "pins" pivot table data, we used a different article title for a while-we called "Changing the layout of a PivotTable report," which made it difficult to find when you were looking for info on pivoting data.

But now is back as Pivot data in a PivotTable report-that it should be easier to find when you search!

I hope that this provides the answers to your questions on the PivotTable. If there are other ideas out there, or if you have a great tip about using PivotTables, we'd love to hear from you!

-Frederique Klitgaard

View the original article here

No comments: