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.

Click on Queries in the left pane and then click Create Query in Design View. A new window will open, prompting you to Add Tables or Query (Figure B). Figure B ...