Product Review

This lesson of Mastering Excel covers Power Map. Power Map is a new feature that lets you use Excel to graph geographical data. If your data has cities, addresses, zip codes, longitude & latitude coordinates, you can load the data into Power Map and have a variety of graphs appear on a map. Additionally, you can add a time series and build an animation that displays how the data changes as time progresses. I'll also how you how to compile the animations and send them to people who don't have Excel. Yes, the animations can be sent independently of the Excel file.

Maybe you don't have geographical data. You can still use Power Map. I will show you how to load custom maps and link your data to your map. For example, if you have inventory location data and a map of your store/warehouse, you can use Power Map to display the product breakdown by bin location. The lesson has an exercise where you plot failure points on a part schematic. You'll learn how to link the image to the data and build a heat map to display the major fault points of the part.

As with all my lessons, you'll get several follow along workbooks that you can use to work through the exercises as you read.