From the course: Excel for Sales Professionals
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
3D maps
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Conditional formatting5m 1s
-
(Locked)
PivotTables3m 29s
-
(Locked)
Unpacking PivotTables3m 44s
-
(Locked)
Create a leaderboard2m 29s
-
(Locked)
Leaderboard finishing touches5m 37s
-
(Locked)
PivotCharts6m 24s
-
(Locked)
Funnel charts8m 42s
-
(Locked)
Quick forecasting7m 30s
-
(Locked)
3D maps5m 58s
-
(Locked)
-
-