Excel 2016: Working with Data in 3D Maps


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
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.

Expected Duration (hours)
0.9

Lesson Objectives

Excel 2016: Working with Data in 3D Maps

  • 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
  • Course Number:
    ds_msex2016_20_enus

    Expertise Level
    Beginner