Working with Data in 3D Maps in Excel 2016 for Windows

Excel 2016 (Windows)    |    Beginner
  • 11 videos | 53m 9s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 75 users Rating 4.6 of 75 users (75)
Knowing how to bring in data and map it to your 3D Maps tours is key to getting the most out of your data. During this course, you will learn how to use data from multiple tables, add layers, timestamps, and filters to better understand your tours, and how to customize the information on display. You will start by creating your map from your initial data table with details such as time zones, place names, and zip codes. Then you will learn how to add, refresh, format, annotate, and delete data. From there you can explore how to combine data from separate tables into one 3D map; employ layers to differentiate, shape, and display different data sets, and customize and insert charts into your data layers. Other topics include how to adjust your 3D map display, how to add legends, apply data filters, show or hide elements, and change map views.

WHAT YOU WILL LEARN

  • Work with layers in a 3d map in excel 2016
    Manage layers in a 3d map in excel 2016
    Add data to a 3d map in excel 2016
    Add timestamps to a 3d map in excel 2016
    Work with data from multiple tables in 3d maps in excel 2016
    Use charts in 3d maps in excel 2016
  • Customize charts in 3d maps in excel 2016
    Use filters in 3d maps in excel 2016
    Use legends in 3d maps in excel 2016
    Customize map data in 3d maps in excel 2016
    Manage the 3d map display in excel 2016

IN THIS COURSE

  • 5m 31s
    In 3D Maps, layers will allow you to choose the data to display. With layers, you can also access filter tools and other customization options. FREE ACCESS
  • 5m 33s
    If you are working on a map with different types of data, you can use layers to distinguish the different datasets. When you have multiple layers, see how to manage them to better understand as well as differentiate between different datasets. FREE ACCESS
  • Locked
    3.  Adding data to a map in Excel 2016 for Windows
    4m 59s
    The data inserted on a 3D map is associated with the table used to create the tour. In this module, you will learn how to add, refresh, and delete data from a 3D map. FREE ACCESS
  • Locked
    4.  Adding timestamps in Excel 2016 for Windows
    5m 51s
    If you want to see the evolution of your data, you can display timestamps on a 3D map. You will see in this module how to configure the display options for the time and date, after adding them to your 3D map. FREE ACCESS
  • Locked
    5.  Adding data from multiple tables in Excel 2016 for Windows
    3m 51s
    Excel 2016 enables you to work with multiple tables simultaneously. This is also possible from the 3D Maps interface, which allows you to combine data from different tables in a single location. FREE ACCESS
  • Locked
    6.  Using charts in Excel 2016 for Windows
    4m 45s
    When working with different data layers on an Excel 2016 3D map, the charts on each layer can be useful for highlighting certain information. You will see in this module how to insert the different types of charts. FREE ACCESS
  • Locked
    7.  Customizing charts in Excel 2016 for Windows
    4m 55s
    The charts used in Excel 2016 3D Maps are customizable. In this module, you will see how to modify the shapes, scales or colors of these elements. FREE ACCESS
  • Locked
    8.  Using filters in Excel 2016 for Windows
    4m 32s
    In order to display only the data that you need, you can use filters. This will allow you to choose the type of data displayed, such as numbers or text, on your 3D map in Excel 2016. FREE ACCESS
  • Locked
    9.  Using legends in Excel 2016 for Windows
    4m 17s
    Legends are text boxes where you will see detailed information. This will help you understand the display and data in your 3D map. In this module, you will see how to customize the content as well as the layout. FREE ACCESS
  • Locked
    10.  Customizing map data in Excel 2016 for Windows
    5m 42s
    When you add data or information to Excel 2016 3D Maps, this data is displayed as a graph or in data cards. In this module, you will learn how to format data cards as well as add additional information in the form of annotations. FREE ACCESS
  • Locked
    11.  Managing the map display in Excel 2016 for Windows
    3m 15s
    Once you have created your 3D map in Excel 2016, you can manage the display multiple ways, such as showing or hiding certain elements, doing a search or viewing the map in a certain way. You will see in this module how to find and use these options. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Working with tables in Excel 365
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Course Customizing charts in Excel 365
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Designing your slides in PowerPoint 365
Rating 4.3 of 107 users Rating 4.3 of 107 users (107)
Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Course Creating PivotTables and PivotCharts in Excel 365
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)