For deeper dives, check out my earlier articles on creating relational tables and creating relational databases. How to create an Excel table 1. First, enter the field names in the columns across ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

To learn more about Excel Table objects, read 10 reasons to use Excel’s table object. Send me your question about Office I answer readers’ questions when I can, but there’s no guarantee.