Microsoft MapPoint is an extra program you can buy from Microsoft. There’s a North American and a European version. At $299 list price, it is pricey. You also might be able to pick up a copy on eBay for less than the list price. MapPoint allows you to do some very cool geographic analysis of data.
With the help of the Data Validation feature, you can add your own custom Excel tooltip to any cell in a worksheet. Read on as Mr. Excel explains how to accomplish this task with just a few easy clicks.
Problem: Your company offers a bonus pool on any day where the total sales exceed $1,000. You have invoice data by date, as shown in Fig. 1303. You would like to highlight all records for the days that meet $1,000 in sales.