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.

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.

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 ...

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