Analysing and visualising geographical data in Excel 

If you are an Advanced Excel user who works with location-based data and have ever wanted to calculate straight-line or driving distances, driving times or you would like to visualise your data, then this is the online workshop for you.  

Excel Online Training Webinars

  • Time:12:00pm AEDT
  • Price: $99
  • Skill Level: Advanced
  • Duration: 90 mins
  • CPD hours: 90 mins


  • Live Q&A
  • Instructor Led
  • Class size (max): 25
  • Exercise Materials
  • Great Reviews
  • Recorded Playback

Learning Outcomes in a Nutshell

Learn how to manipulate, enhance, analyse and visualise your geographical data in Excel. Calculate straight-line or driving distances, driving times and how to visualise your geo data in Excel.

Course Content

Microsoft Excel Green Logo  Capturing location-based data

  • The more granularity the better 
  • What is longitude and latitude
  • Other common location-based meta data (statistical areas, electoral boundaries, etc) 

Microsoft Excel Green Logo Excel Data Types 

  • What is the new data type? 
  • What version of Excel is it included in 
  • How to expand your Geographic/Location information 
  •  Excel Functions 

Microsoft Excel Green Logo 3rd party services to provide location based information

  • Using Google Maps API
  • Using Bing Maps API 
  • Overview of costs of these services
  • Registering for an API key
  • Secure your API key so others can’t use it 

Microsoft Excel Green Logo Using Excel functions to call API data

  • Using the Google Maps and Bing Maps API calls in Excel 
  • Calculating driving distances 
  • Calculating longitude and latitude of an address 

Microsoft Excel Green Logo Using Excel’s new Map Chart

  • What data is required
  • Limitations with what can be mapped 
  • How to insert a map chart 
  • How to format a map chart 

Microsoft Excel Green Logo Using Excel’s 3D Maps (previously known as Power Map) 

  • Versions of Excel with 3D Map included
  • Excel 2013 Power Map Add-In
  • How to setup your data for use in 3D Maps (Tables, Data Model, Power Pivot) 

  • Geocoding your data (include as much location data as possible) 
  • Create your first 3D Map 
  • Moving around your 3D Map 
  • Changing how your data is displayed 
  • Changing the map theme and labels 

  • Importing a custom region file 

  • Using time data in 3D Maps
  • Creating scenes 
  • Filtering Data 
  • Exporting 3D Maps as a video file


Course Prerequisites
There are basic skills and software requirements for this workshop. To get the most out of this webinar, make sure you have the software ready to go.

Skill Requirements:

  • Excel Intermediate to Advanced. Some knowledge of Excel Data Model/Power Pivot will be beneficial.

Software Requirements:

  • Excel 2013 and onwards for 3D Maps/Power Maps, Excel 2019 for Map Charts 

Meet our Trainer

Matt Burr is a Business and Data Analyst with extensive experience in both the public and private sector.

After completing a double Bachelor Degree in Economics and Commerce at the Australian National University, Matt spent over 10 years working in the Construction, Defence, Resources and Health sectors before bringing his experience and knowledge to our Canberra venue as the lead Trainer.

Matt brings current technical knowledge and relevant real-world applications which results in great learning outcomes for our students. In the last 6-months Matt has trained over 250 students, many repeat clients, maintaining an excellent student satisfaction rating of 4.7 out of 5.

How our Webinars Work

  • Click Book Now, select your Webinar and Sign Up
  • Receive Email with Login Details
  • 5 Days ahead of course check your login credentials work
  • Day of course Log On to join the Webinar
  • Q&A session will be facilitated and explained by the presenter


Why train with Excel Consulting?

“We are passionate about Professional Development and continue to invest in our trainers, courses and material so our students can achieve fantastic learning outcomes.”


Instructor Led


Remote Login




Short Sessions


Expert Trainers


Live Q&A

If you are hungry to learn more then Book Now or check out our Excel Specialist Courses.