5 More Cool Things You Can Do with Excel

Geocode simply means to find the latitude and longitude of an address. Geocoding provides businesses with very exact location information, important for a variety of functions such as address verification, product routing, even demographics analysis. In particular, location-based advertising for mobile devices (such as the iPhone and iPad) can tailor the advertising message using latitude and longitude coordinates provided by the device GPS, and then point consumers to the nearest store of interest. Please read the Directions magazine article Connecting the Dots: Why Geocoding is Critical for Businesses for more information on how geocoding can help your organization.

CDXZipStream, working in conjunction with Microsoft MapPoint, can provide latitiude and longitude information for long address lists, with just a few clicks in Excel. CDXZipStream can also "reverse" geocode, providing the closest address for a given latitude/longitude combination. Our YouTube video Geocoder in Excel is a quick and simple tutorial showing both geocoding and reverse geocoding in a simple Excel worksheet, and the article Geocoder as Business Tool discusses in detail how geocoding can target customers and increase market share. Considering CDXZipStream costs a fraction of other geocoding systems, it's an easy-to-use and economical solution that can deliver big dividends for your business.

Doing a demographic analysis based on zip codes often requires generating lists of zip codes for a particular city, county, or state. These lists are available from various websites, such as the U.S. Postal Service, but in a form that can't be easily copied into a spreadsheet. With CDXZipStream, you can generate lists quickly and easily using our CDXZipList function. Just right-click on any cell in a worksheet, and select the location where you need zip codes. Within seconds you'll have your list of zip codes, along with any other available city, state, and county information. The data is formatted and ready to use immediately. Watch the short YouTube Video Zip Code List in Microsoft Excel to see how easy it is.

CDXZipStream now allows you to insert maps into your Excel worksheet. As they say "A picture is worth a thousand words", and now you can insert a map showing a particular driving route, illustrate a radius distance around a zip code, or simply show an address of interest. All you need to do is right-click on a cell in your Excel worksheet, specify the type of map you need, and CDXZipStream does the rest, automatically grabbing the proper map from Microsoft MapPoint. All of this is done without leaving Excel - there's no programming required, and no need to learn another mapping application. Watch the YouTube video Map It in Excel for step-by-step instructions.

CDXZipStream has received numerous awards including the prestigious "5 Cow" award at Tucows.com. You can get a fully-functional, 30-day trial of CDXZipStream absolutely free. We provide complete technical support for both trial and purchased versions. If you decide to buy, pricing starts at $39.95 and the premium package (which includes eight demographic data feeds) is $299.95. Quantity discounts and site licensing are also available. Keep in mind CDXZipStream is not a subscription service - you buy it one time and purchase data updates only if you need them - and if you aren't happy for any reason within 30 days after purchase, you'll get a full refund.

Sometimes you simply need demographic data for a single zip code, and CDX Technologies is proud to introduce our new, free on-line demographic tool. Just input the zip code of interest and select the kind of data you need. Your data request is displayed as a web page, but can also be exported to Microsoft Excel for further analysis, or to a presentation-quality pdf file. We'd like to incorporate your comments and suggestions as we add more features, so please feel free to contact us at support@cdxtech.com. .