Open Daily: 10am - 10pm | Alley door pickup 10am - 7pm 3038 Hennepin Ave Minneapolis, MN
612-822-4611

  • Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
Mastering Excel: Power Map

Mastering Excel: Power Map

Moore, Mark

Paperback

Series: Mastering Excel

Applications

ISBN10: 1546907149
ISBN13: 9781546907145
Publisher: Createspace
Published: May 23 2017
Pages: 44
Weight: 0.16
Height: 0.09 Width: 6.00 Depth: 9.00
Language: English
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.

13 different editions

Also available

Also in

Applications

View All