Editor’s Note: To read more about spreadsheets, share a tip with other readers, or suggest a topic for Bill Jelen to cover in an upcoming column, click here to visit CFO.com’s Spreadsheet Tips page.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

In this article we shall deal with one of the most dynamic & import feature of Excel: Pivot Table: Pivot Tables are interactive table that allow the user to group and summarize large amounts of data ...

Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

Conclusion Microsoft Excel’s pivot table options provide powerful tools for aggregating and analyzing accounting data. While the example here focused on analyzing accounts receivable, similar analyses ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Learn how to delete Excel Pivot Tables and keep the data, remove the data, or delete the data and keep the Pivot Table properly.