Excel: Dashboards and Geospatial Visualizations

Overview

In this course, you'll continue to develop your data-analysis skills in Excel by presenting visual insights with dashboards. You'll also create geospatial visualizations in Excel. This is the third course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.

Syllabus

Presenting Visual Insights with Dashboards in Excel

PivotTables provide the raw power and ease of use that allow you to perform iterative data analysis to determine important insights and trends in data, but you still have to communicate those findings in a way that is compelling and easy to understand.

Creating Geospatial Visualizations with Excel

Often, images can tell a story or provide insight in an instantaneous fashion that isn't always possible with words and numbers. When presenting complex relationships among various bits of data to large groups of people, you may find it easier to display a chart or a map instead of asking the audience to pore over massive amounts of data to see your point.