The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

In this article, I'll run through three of the functions or combinations of functions I use the most when I want to either extract or summarize information in my Excel tables.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

Use these six shortcuts to select Table elements and insert columns and rows quickly in Microsoft Excel, making your use of Tables that much easier.