Introduction
	Welcome_Excel	00:00:00
	What you should know before watching this course_Excel	00:00:00
	Using the exercise files_Excel	00:00:00
Getting Started
	Heat map overview_Excel	00:00:00
	Reviewing the dataset_Excel	00:00:00
	Defining the project goal and creating a roadmap_Excel	00:00:00
Standardizing Location Data
	TRIM and PROPER_Excel	00:00:00
	IF and CONCATENATE_Excel	00:00:00
Creating a new source data
	Creating our pivot table_Excel	00:00:00
	Applying our pivot table_Excel	00:00:00
Data Visualization with Power Map
	Intro to Power Map_Excel	00:00:00
	Power Map by accident type_Excel	00:00:00
	Creating Power Map images_Excel	00:00:00
Option 1: Populating Map Images with Indirect
	Using Named Ranges_Excel	00:00:00
	Using IF map references_Excel	00:00:00
	Using INDIRECT_Excel	00:00:00
Option 2: Linking to Map Images with Hyperlink
	Removing INDIRECT_Excel	00:00:00
	Using IF tab names_Excel	00:00:00
	Using the HYPERLINK function_Excel	00:00:00
Wrapping-Up
	Accident analytics with Power Map_Excel	00:00:00
Conclusion
	Next Steps_Excel	00:00:00

N.A

ratings

No Reviews found for this course.

0 STUDENTS ENROLLED

Visualizing Geospatial Data with Power Map in Excel