Excel - 3D Maps Vidéo
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
- 6001 vues
-
Excel - Do things quickly with Tell Me
- 1:07
- Vu 2817 fois
-
Excel - New Chart types
- 1:52
- Vu 4532 fois
-
Excel - One click Forecasting
- 1:01
- Vu 4149 fois
-
Excel - Ink Equation
- 0:41
- Vu 6394 fois
-
Excel - More complex formulas
- 4:17
- Vu 4997 fois
-
Excel - A closer look at the ribbon
- 3:55
- Vu 4634 fois
-
Excel - Start using Excel
- 4:22
- Vu 4711 fois
-
Excel - Introduction to Excel
- 0:59
- Vu 4317 fois
-
Remove a watermark
- 2:20
- Vu 34262 fois
-
Activate the features of Teams Premium
- 3:48
- Vu 17917 fois
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Vu 15911 fois
-
Change the default font for your emails
- 1:09
- Vu 15891 fois
-
Collapsible headings
- 3:03
- Vu 15568 fois
-
How do I prevent the transfer of an email?
- 2:07
- Vu 13865 fois
-
Create automatic reminders
- 4:10
- Vu 11585 fois
-
Protect a document shared by password
- 1:41
- Vu 11287 fois
-
Morph transition
- 0:43
- Vu 10389 fois
-
Creating a Report
- 2:54
- Vu 9591 fois
-
Remove a watermark
- 2:20
- Vu 34262 fois
-
Activate the features of Teams Premium
- 3:48
- Vu 17917 fois
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Vu 15911 fois
-
Change the default font for your emails
- 1:09
- Vu 15891 fois
-
Collapsible headings
- 3:03
- Vu 15568 fois
-
How do I prevent the transfer of an email?
- 2:07
- Vu 13865 fois
-
Create automatic reminders
- 4:10
- Vu 11585 fois
-
Protect a document shared by password
- 1:41
- Vu 11287 fois
-
Morph transition
- 0:43
- Vu 10389 fois
-
Creating a Report
- 2:54
- Vu 9591 fois
-
Summary of the Microsoft 365 task management system
- 02:46
- Vu 45 fois
-
Track in Planner and Lists and summarize in Teams
- 05:55
- Vu 34 fois
-
Automate task creation and deadline reminders
- 06:49
- Vu 69 fois
-
Choose between Forms, Lists, and Power Apps to collect and manage tasks
- 02:22
- Vu 34 fois
-
Track your daily tasks with To Do and Planner
- 03:33
- Vu 52 fois
-
Manage team tasks with Microsoft Planner
- 02:06
- Vu 36 fois
-
Collaborate on tasks with Team, Loop, and Planner
- 02:11
- Vu 41 fois
-
Create tasks automatically from a SharePoint list
- 02:25
- Vu 43 fois
-
Create a task tracking board in Microsoft Lists
- 02:42
- Vu 41 fois
-
Centralize emails, conversations, and forms into a single task management flow
- 02:28
- Vu 34 fois
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
