Mark Moore

Mastering Excel Mark Moore

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.