| Mastering Excel: Power Map Contributor(s): Moore, Mark (Author) |
|
 |
ISBN: 1546907149 ISBN-13: 9781546907145 Publisher: Createspace Independent Publishing Platform OUR PRICE: $9.69 Product Type: Paperback - Other Formats Published: May 2017 |
| Additional Information |
| BISAC Categories: - Computers | Desktop Applications - Spreadsheets |
| Physical Information: 0.09" H x 6" W x 9" (0.16 lbs) 44 pages |
| Descriptions, Reviews, Etc. |
| Publisher Description: Learn how to create beautiful interactive maps directly in Excel. It's like adding Google Maps to your spreadsheets.PowerMap has been moved out of Excel and into Power BI. Doesn't matter, Power BI Desktop is still free for Excel users and you can still use Power Maps.With Power Map you can 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. |