00:01When you purchase an ArcGIS Online subscription, a copy of Esri Maps for Office is included.
00:07You can sign into your ArcGIS Online account from Excel and access your organization's content.
00:13Esri Maps for Office is an add-in for Microsoft Office 2010 or later.
00:18Esri Maps for Office brings mapping capabilities into Microsoft Excel and Microsoft PowerPoint.
00:24You can easily create interactive maps that include data from Excel and ArcGIS services and publish…
00:30…your Excel data to ArcGIS Online without leaving the Excel environment.
00:34Esri Maps for Office includes the gallery of ArcGIS Online basemaps, easy wizards to add spreadsheet data to the map…
00:42…tools for configuring the display style, and tools to create heat maps and cluster maps.
00:48In this video, we will show you how to make a map using your data inside Excel…
00:52…and how to share the map with your organization using ArcGIS Online.
00:57Here we have a workbook open in Excel with two spreadsheets.
01:01In one spreadsheet, we have average monthly spending on restaurants per household by ZIP code.
01:08In the second spreadsheet, we have a table of restaurants including their addresses.
01:12Since both these tables have location information, ZIP codes in one, and addresses in another…
01:18…it makes sense to geographically visualize this data, rather than seeing them in tables or in charts.
01:25To map this data, insert a map. You can change the title of the map.
01:31Now add the spreadsheet with monthly spending on restaurants, and zoom into the area for which the data was added.
01:39You can divide data into groups by choosing the Data Attribute, Grouping Method, and Number of Groups.
01:46Now add the second spreadsheet that has the restaurant's data.
01:52Select Style Option to customize the appearance points representing restaurant locations.
01:58You can choose to show data by a single icon, or divide them into groups of different sizes.
02:05You will see a lot of points on top of each other.
02:07To clean it up, you can click the Clustering button and create a clearer view.
02:12You can also generate a heat map from the address points.
02:15Now you're able to visualize the Excel data in a map, which is easier to understand and communicate to others.
02:22Now it's ready to share with others in your organization.
02:26You'll see a progress icon showing that it is publishing the map as a feature service to ArcGIS Online.
02:32Now if you go to your ArcGIS Online home page…
02:35…and go to your My Content page, you'll see your feature service listed there as one of your items…
02:40…and is ready to be used in a web map.
Esri Maps for Office with ArcGIS Online Subscriptions
Find out how to get started using Esri Maps for Office, which is an add-in for Microsoft Office. A demo shows how to make a map using your data inside Excel and share it using ArcGIS Online.
- Recorded: Jul 1st, 2012
- Runtime: 02:47
- Views: 440
- Published: Jul 20th, 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.