To create maps using Excel data outside of Excel, you can also use online mapping services like BatchGeo.com or Google Earth. BatchGeo.com lets you paste your Excel data directly into their web page.

Once you have a unique list of ZIP Codes, you can use COUNTIF() to return the count of each ZIP Code value, as shown in Figure C, using =COUNTIF(Table1[ZIPS],D2) and copying it to the remaining cells.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.