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 - Microsoft Excel Tutorial
From the course: Visualizing Geospatial Data with Power Map in Excel
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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.