Create a 3D map in Excel that shows sales amounts by location, lat/long codes, or street addresses
- [Instructor] Excel 2016 has got a really cool feature…called 3D map charts.…It lets you plot geographical information…like address, city, state, and country…on a three-dimensional map, and you can also…add in a category and sales amount as well.…This can be really handy if you want…to see where your sales are concentrated,…and if you need to look for other areas…to maximize your revenue potential.…For this video I have 04_09 3D Maps open,…and that's in the Chapter Four folder.…We are currently looking at our Northwind sales data,…and if I scroll to the right, you can see…that I only have City and State columns…for this sales data, and since this is a public course,…we don't have actual street addresses…for each of these sales records.…
But of course, yours certainly could include…a street address.…Note that we also have of course the sales amount…for each sales transaction, and we also have…the category, and we've been working with these…throughout the course.…But to plot this on a 3D map,…you just click inside that table,…
- Using, modifying, and sharing templates
- Importing data from a database
- Cleaning up data
- Refreshing queries
- Pasting data
- Sorting and filtering tables
- Using slicers
- Adding a dynamic commission calculation
- Using conditional formatting
- Working with PivotTables and PivotCharts
- Creating a leaderboard
- Create period, monthly, and yearly summaries
- Creating dashboards
Skill Level Intermediate
1. Getting Started with Templates
2. Importing Sales Data
3. Working with Tables
4. Analyzing Sales Data
5. Build Awesome Sales Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.