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


  • Date:Mar 6th, 2019
  • Time:12:00pm AEST
  • Price: $195
  • 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

  • WEBSERVICE() and FILTERXML()
  • 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 

A bit about our Trainer

Matt Burr is a Business and Data Analyst with extensive experience in both the public and private sector. He has been the lead Trainer in our Canberra operation. He brings technical knowledge and real world applications which results in great learning outcomes for our students.


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

EXCEL CONSULTING Microsoft WORKSHOPS


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.”

presentation

Instructor Led

cityscape-2

Remote Login

notebook

Materials

clock_re

Short Sessions

certificate

Expert Trainers

chat

Live Q&A


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