Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
So in this module Ah, I talked about using, uh,
00:07
being maps in Excel to put your data on the geographic distribution. So have seen how you can put the example country sales data on a map. Uh uh shows you circle That is, uh,
00:24
different from each country to each country in size. Regarding off the
00:28
sales that you have achieved in the country you have seen how many details can you go in? You have seen that you cannot use political visit nations. You can use the on
00:44
use on geographically locations like a country name or geographic location like, for example, Iberian Peninsula or Balkan spending Scylla.
00:54
Uh, so the rest of Europe is not defined geographic, and so you can't use it. And you have seen that you can go into detail to the street level street address off,
01:08
uh, every location, every every house in that street, and put some some information to it.
01:15
Also, you have seen that if you're using to the maps, you can have on Lee one designation in terms of location which can be addressed, or longitude latitude or the name of the place if it's unique,
01:29
country on and you can use several numbers defining that location, for example, have sales and profit
01:40
in two separate calls.
01:42
You have also seen that on three D maps. You can go much further
01:48
and you can, uh,
01:49
uh puts many more data there so you can put the boat in the name of the store and it's less physical Institute. And it's, uh, uh, street address on when you click on the bar that is representing that particular,
02:07
uh, location. You get old information that
02:10
long you have
02:13
made possible to see. So with the bing maps, you can really, really worker nicely in terms of putting your date down
02:24
geographic spread. But you have to be careful how you define locations, because in some, Katie, this case is being lapse simply won't recognize what you're looking,
02:37
uh, to locate. So if you call something,
02:43
Northern Europe will be no faults,
02:47
and this is collusion off. Seven

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor