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.