Excel - 3D Maps Tutorial

In this video, you will learn about 3D maps in Microsoft 365. The video covers how to create and navigate 3D maps using the tools available in Microsoft 365. This will help you visualize data in a new and interactive way, making it easier to analyze and understand complex information.
With 3D maps, you can create stunning visualizations that will impress your audience and enhance your presentations.

1:41
5677 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive overview of the 3D Map feature in Excel 2016, detailing its functionalities, how to utilize it for geospatial visualization, and practical examples to enhance understanding.

Chapitres :

Introduction to 3D Map in Excel 2016
The 3D Map feature, previously known as Power Map, is an innovative tool integrated into Excel 2016. It allows users to visualize data in a three-dimensional format, enhancing storytelling capabilities through geospatial representation. This feature is accessible to all Excel 2016 users and can be found under the Insert tab.
Getting Started with 3D Map
To utilize the 3D Map feature, your Excel data must contain geographic properties formatted in a table. This includes data such as city names, states, countries, zip codes, regions, or coordinates (longitude and latitude). For instance, consider a table that lists sales data for a product across various cities in Europe.
Activating 3D Mapping
To activate 3D mapping, select your data table and click on the '3D Map' option in the Insert tab. The tool uses Bing to geocode your data based on its geographic properties. After a brief loading period, a globe will appear alongside the layer pane, displaying the geographical representation of your data.
Organizing and Visualizing Data
Excel organizes the imported data by selecting fields such as country or city. Users can match these fields to various criteria, such as height, to create different types of visual displays. For example, by dragging and dropping the sales data to the height property, users can create a histogram display that visually represents sales figures for each country.
Creating Visual Displays
Once the data is imported onto the map, users can choose from several visualization formats. The 3D Map feature allows for the establishment of a play tour, the creation of a video, or simply capturing a screenshot of the map for presentations or reports.
Conclusion
The 3D Map feature in Excel 2016 provides a powerful tool for visualizing geographic data. By following the steps outlined, users can effectively utilize this feature to enhance their data storytelling and presentations, making complex data more accessible and engaging.

FAQ :

What is the purpose of 3D Map in Excel?

3D Map in Excel is used to visualize geographic data in three dimensions, allowing users to create interactive maps that represent data with geographic properties.

How do I access 3D Map in Excel 2016?

To access 3D Map in Excel 2016, click on the 'Insert' tab and select '3D Map' from the visualization tools available.

What types of data can be used with 3D Map?

3D Map can utilize data that has geographic properties, such as city names, states, countries, zip codes, regions, or coordinates (longitude and latitude).

Can I create a video from my 3D Map visualization?

Yes, 3D Map allows you to create a video of your data visualization or capture a screenshot of the map for presentations.

What is the benefit of using geocoding in 3D Map?

Geocoding in 3D Map helps to accurately place your data on the map based on its geographic properties, enhancing the visualization's relevance and clarity.

Quelques cas d'usages :

Sales Data Visualization

A sales manager can use 3D Map to visualize sales data across different cities in Europe, allowing for better understanding of regional performance and strategic planning.

Market Analysis

A marketing analyst can leverage 3D Map to analyze customer demographics and sales trends geographically, helping to identify target markets and optimize marketing strategies.

Logistics and Distribution Planning

A logistics coordinator can utilize 3D Map to visualize distribution routes and warehouse locations, improving efficiency in supply chain management.

Urban Planning

Urban planners can apply 3D Map to visualize population density and infrastructure data, aiding in the development of city planning initiatives.

Event Planning

Event planners can use 3D Map to visualize potential venues and attendee locations, facilitating better logistical arrangements for events.

Glossaire :

3D Map

A geospatial visualization tool integrated into Excel 2016 that allows users to create three-dimensional representations of data with geographic properties.

Geocoding

The process of converting addresses or geographic data into geographic coordinates, which can be used to place markers on a map.

Data Model

A collection of tables and relationships that can be used to analyze data in Excel, allowing for more complex data manipulation and visualization.

Visualization Tools

Features in Excel that allow users to represent data graphically, making it easier to understand and analyze.

Histogram

A graphical representation of the distribution of numerical data, often used to show frequency distributions.

Layer Pane

A feature in 3D Map that allows users to manage and organize different data layers displayed on the map.

Play Tour

A feature in 3D Map that allows users to create a dynamic presentation of their data visualization, simulating a guided tour of the map.

00:00:08

has been renamed and is now available to all Excel 2016

00:00:12

customers and it's built into Excel.

00:00:15

This innovative set of storytelling capabilities has been

00:00:19

renamed 3D Map and can be found along with other

00:00:22

visualization tools by clicking 3D map on the Insert tab.

00:00:27

When you have Excel data that has geographic properties

00:00:29

and table format or in a data model, for example,

00:00:33

rows and columns that have names of cities, states, countries,

00:00:36

zip codes, regions or longitudes and latitudes, you're ready to get started.

00:00:42

Here's an example, this table represents the Europe sales of a product,

00:00:46

this contains country, city and sales columns.

00:00:50

By selecting this table I'll activate the 3D mapping by

00:00:54

clicking on 3D Map.

00:00:56

3D map uses Bing to geocode your data based on its

00:01:00

geographical properties, after a few seconds, the globe

00:01:03

will appear next to the first screen of the layer pane,

00:01:06

in the field less, Excel recovers information from the table,

00:01:10

organizes your display by selecting country or city.

00:01:13

You can also match those fields to criteria like height

00:01:16

to create a histogram display for example.

00:01:19

Here I drag and drop sales to match it to the height property,

00:01:24

if I want a different display for each country,

00:01:26

I drag and drop Country to Category.

00:01:29

The data visualization can take several formats,

00:01:33

once data is imported on the map, I can establish a play tour,

00:01:37

create a video or simply capture a screen of the map.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2672 Views

Video Training Microsoft Excel - Advanced level

With our "advanced" tutorials, discover and master the full potential of Excel, using complex functions, macros and the power of DCTs and Po...

ALL COURSES