How to Create Maps in Excel 2007. There are several ways to create maps in Microsoft Excel 2007. ... Drag the mouse across the data you want to use for the map, including the column of ZIP Codes.

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.