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
- 9697 views
-
Excel - Start with "Ideas" in Excel
- 0:38
- Viewed 7168 times
-
Excel - Do things quickly with Tell Me
- 1:07
- Viewed 4010 times
-
Excel - New Chart types
- 1:52
- Viewed 5639 times
-
Excel - Creating a forecast sheet with Excel
- 0:43
- Viewed 5702 times
-
Excel - One click Forecasting
- 1:01
- Viewed 5218 times
-
Excel - Ink Equation
- 0:41
- Viewed 8353 times
-
Excel - Share documents
- 1:13
- Viewed 4388 times
-
Excel - Improved version history
- 0:51
- Viewed 5021 times
-
Remove a watermark
- 2:20
- Viewed 67685 times
-
Change the default font for your emails
- 1:09
- Viewed 62811 times
-
Collapsible headings
- 3:03
- Viewed 36631 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 30635 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 29759 times
-
Add headers and footers to slides
- 3:52
- Viewed 24808 times
-
Change footnote font, size, and formatting
- 2:48
- Viewed 24593 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 20931 times
-
Add a sound effect to a transition
- 3:45
- Viewed 20324 times
-
Add sound effects to an animation
- 4:29
- Viewed 19211 times
-
Remove a watermark
- 2:20
- Viewed 67685 times
-
Change the default font for your emails
- 1:09
- Viewed 62811 times
-
Collapsible headings
- 3:03
- Viewed 36631 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 30635 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 29759 times
-
Add headers and footers to slides
- 3:52
- Viewed 24808 times
-
Change footnote font, size, and formatting
- 2:48
- Viewed 24593 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 20931 times
-
Add a sound effect to a transition
- 3:45
- Viewed 20324 times
-
Add sound effects to an animation
- 4:29
- Viewed 19211 times
-
Preparing for the EU AI Act: Timeline and Obligations
- 01:54
- Viewed 115 times
-
Using AI in the Workplace: 3 Tips to Minimize Risks
- 03:10
- Viewed 116 times
-
Shadow AI: Identifying Uncontrolled AI Use
- 02:21
- Viewed 111 times
-
EU AI Act Risk Levels: From Minimal to Unacceptable
- 02:37
- Viewed 153 times
-
Understanding the EU AI Act: A Regulation Governing the Use of AI
- 02:24
- Viewed 120 times
-
Analyze the performance of a newsletter or an edition in Outlook
- 01:30
- Viewed 161 times
-
Collaborate on writing an edition in Outlook
- 01:35
- Viewed 142 times
-
Enhance an edition and create a template in a newsletter
- 06:14
- Viewed 133 times
-
Collaborate on a Clipchamp Project
- 01:21
- Viewed 437 times
-
Create a Video with AI in Clipchamp
- 03:26
- Viewed 387 times
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.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise