Mastering Excel

Power Map

By: Mark Moore

Write A Review

Paperback | 23 May 2017

At a Glance

Paperback
44 Pages

Dimensions(cm)
22.86 x 15.24 x 0.23

Paperback

$35.99

or 4 interest-free payments of $9.00 with

Ships in 5 to 10 business days

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.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.