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.
- 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.
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)
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
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
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
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
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
- Excel Intermediate to Advanced. Some knowledge of Excel Data Model/Power Pivot will be beneficial.
- 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.”