00:01Well, let's move on to the third perspective. How do you broaden the reach of mapping into every office? And I do mean every office.
00:10For an exciting new beta announcement, please welcome, from the Software Development team, Art Haddad.
00:16Thanks, John. I'm excited to be here today and represent the core development team…
00:23…to tell you about a new product that's currently in beta today--a product that works inside of Microsoft Office…
00:30…Esri Maps for Office. Yes, we're adding mapping capabilities and tools to the Microsoft Office product suite.
00:36And today, I want to give you a little peek at what we have in the beta.
00:40Let's start in Microsoft Excel. I have here a workbook that's opened up with a number of spreadsheets in it.
00:45This spreadsheet happens to be gross domestic product values, across counties within our country.
00:54Inside of Excel, it's easy to aggregate this information using a Pivot table to summarize everything by state name…
01:01…in this case, state name to gross domestic product and the regional domestic product.
01:06And I'll go ahead and format those using a currency value to represent those numbers.
01:09Now, since I'm working with state name, it makes sense to add a map to represent these values.
01:16When we installed Esri Maps for Office into the Office product suite, it added a new tab to the Office ribbon.
01:23And on this tab, I can easily sign in to my ArcGIS Online subscription.
01:30And then I can insert a map…I'll go ahead and size this a little bit, so you can see it a little better…
01:38…and I'll change the basemap to represent the information I'm going to be portraying.
01:42I can then add the Pivot table information by simply selecting the data range, specifying place name of state, and add that to the map.
01:57So as you can see here, I now have all the states added to the map with just a few clicks of the mouse. [Applause] Thank you.
02:07But wait, there's more. I can easily style this information to represent the larger GDP values on the map using a darker color.
02:17Again, a few clicks of the mouse, and I now have color-coded maps within Excel.
02:22And since I'm interested in the eastern seaboard, I'll go ahead zoom in here a little bit closer.
02:28Now I also have some visible scale ranges. I definitely want to see this down to the city level.
02:33So I'll go ahead and quickly do that.
02:36I also have another spreadsheet that contains government-awarded contracts for around the country.
02:40This is all referenced by address information. I want to add this to my map as well…
02:45…to further answer the questions that I'm actually looking for.
02:51Again, using Add Excel data, and this time I'll use the table of North Carolina contracts, filtered table within Excel…
02:57…matching up those addresses to the map.
03:01So what we're doing here is, we're actually taking the spreadsheet information…
03:04…using ArcGIS Online to match those addresses back to the map, and representing those coordinate values appropriately. Great.
03:13So there, let me actually zoom in to it, and of course I have all the information here…
03:18…and pop-up information, that even drills down into the states.
03:22But I also want to see the larger government-awarded contracts using a different symbol.
03:28So here, I'll go ahead and size everything out. Actually, let me change that to be the local awarded amount.
03:36And again, I'll change that to a better grouping method, and change the size so I can see them a little better. Great.
03:43Now I have all the information I'm looking for. But it's still a little cluttered. Let me clean that up here.
03:47So quickly I can clean that up, I can zoom in to it, and I can even see all the information within a given area.
03:56Now, I also know about other projects that my colleagues have been working on through ArcGIS Online.
04:01So let me go ahead and add those other government projects--estuaries--this is the one you've just seen…
04:07…in the previous demonstration--and I'll add those to the map as well. So now I have everything that I'm looking for.
04:17I have all the information in my spreadsheets, multiple spreadsheets, on one map, cleaned up, looking exactly the way I want.
04:25Now, there's other tools on this ribbon that I really haven't shown you yet…
04:28…for instance, sharing all this work back to ArcGIS Online with a single click…
04:32…but I do want to focus in on this one tool here, and that's sharing back to PowerPoint.
04:38I want to actually present this information in PowerPoint.
04:41So I'm going to move this out of the way to expose my PowerPoint chart here--my deck--and since I now have my map…
04:48…I can go ahead and click, I can create that information, I can select North Carolina, since that's the state I'm focusing on…
04:56…and again, I'll create that slide.
04:59Now let me move into PowerPoint. And in PowerPoint, we also added a new tab to the Office ribbon.
05:05And I am signed into my ArcGIS Online subscription, so what I want to do is, search for another project area, called wind energies.
05:14And this was the first demonstration you saw today.
05:18And of course, within my organization--and I'll use the one that everyone's been marking up.
05:24Let me open that map, and I'll also create another slide.
05:30And I think I'm ready to show this now, so if I go into PowerPoint presentation mode, I can navigate through my slides…
05:38…tell my story as part of my presentation, and oh, yeah, they might have another question about this…
05:43…so let me take this live, and sure enough, I can work with my map…I can see the questions, and of course, see the answers…
05:54...and all of this is in real time. So now, what we've been able to do, in summary.
05:59We now have a product that works inside Microsoft Office, a very familiar environment for everyone in the office workplace.
06:07We now have this product in beta, so in our Beta Community, .esri.com, you can easily go up there and sign up for our beta…
06:15…and we look to be final in summertime this year. John? Back to you.
06:22Thank you. Thanks, Art. If we all share Art's enthusiasm for this product, the opportunities are endless…
06:30…millions and millions of Office users that can now interact with ArcGIS Online.
Esri Maps for Office
Art Haddad demonstrates Esri Maps for Office.
- Recorded: Mar 24th, 2012
- Runtime: 06:38
- Views: 2055
- Published: May 14th, 2012
- Night Mode (Off)Automatically dim the web site while the video is playing. A few seconds after you start watching the video and stop moving your mouse, your screen will dim. You can auto save this option if you login.
- HTML5 Video (Off) Play videos using HTML5 Video instead of flash. A modern web browser is required to view videos using HTML5.