Analyse Spatial Data with ArcGIS Maps for Office

Strictly by pre-registration only

What is this course about?

ArcGIS Maps for Office gives you the power to ask location-related questions of your data, get new insights, and make smarter decisions.

This course teaches how to create a map directly inside an Excel worksheet, work with the map and map layers to create new information, use analysis and data enrichment tools to discover patterns in your data, answer questions, and support informed decision making and share the results throughout your organization.

This course is for: Microsoft Office users, knowledge workers, GIS professionals, and others who want to map and analyse Excel data.

Download course outline

Course details




1 day




Web Application Configuration

Are there any prerequisites?

  • Proficiency with Microsoft Excel and PowerPoint is required
  • Familiarity with ArcGIS Online is recommended

What skills will I learn?

After completing this course, you will be able to:

  • Represent Excel data as map features
  • Display and group Excel worksheet data as features on a map
  • Modify symbology to tell your map story
  • Visualise your data on a map directly inside Microsoft Excel
  • Perform analysis to find features in relation to other features
  • Insert an interactive web map into a PowerPoint presentation
  • Share analysis results to your ArcGIS Online site or in a PowerPoint presentation

What can I expect?

  • Course activities

    Create map in Excel

    • Add a map to Excel
    • Add data from Excel
    • Manage the map
    • Navigate the map
    • Change the basemap

    Add layers from ArcGIS Online

    • Add layers from Excel
    • Geocode Microsoft Excel content
    • Tables and named ranges

    Style layers

    • Change a layer’s style
    • Classification methods
    • Configure and display pop-up

    Perform analysis

    • Select features
    • Configure clustering
    • Find hot spots
    • Find nearby features
    • Map temporal data

    Share map

    • Share the map to ArcGIS Online
    • Share the layer to ArcGIS Online
    • Copy a map image

    Work with PowerPoint

    • Create a PowerPoint map slide from Excel
    • Add a dynamic map to a PowerPoint slide

Subscribe to
Esri Singapore news