From the course: Visualizing Geospatial Data with Power Map in Excel

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Welcome

Welcome - Microsoft Excel Tutorial

From the course: Visualizing Geospatial Data with Power Map in Excel

Start my 1-month free trial

Welcome

- [Voiceover] Hi, I'm Chris Dutton and welcome to Visualizing Geospatial Data with Power Map. In this course, we'll expand on the Building Excel Heat Maps course and use Power Map to plot accident locations based on latitude and longitude data, all within Excel. We'll start by analyzing a heat map, identifying the geospatial variables in our data set, and laying out a project road map. I'll show you how to use text functions like TRIM, PROPER, and CONCATENATE to standardize data fields and combine them to create new values. We'll then use pivot tables to sort and filter by accident type and location, and import that data into Power Map to visualize exactly where accidents most frequently occur. Finally, we'll explore two creative ways to integrate the maps into our tool using the INDIRECT and HYPERLINK functions. Ready to get started? Let's dive in with Visualizing Geospatial Data with Power Map.

Contents