{"id":68211,"date":"2015-07-07T07:00:54","date_gmt":"2015-07-07T07:00:54","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/be-an-excel-ninja-part-2\/"},"modified":"2018-03-26T21:05:50","modified_gmt":"2018-03-26T21:05:50","slug":"be-an-excel-ninja-part-2","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/data-management\/data-management\/be-an-excel-ninja-part-2","title":{"rendered":"Be An Excel Ninja, Part 2"},"author":5791,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851,24641,25741,22851,22841,22941,22771,25831,24371,22871,25841,23351,23051],"tags":[25751,25761,25941,25901,24981,23551,23161,25951,25911,22901,22821,26221,24391,29961,23401,23081,23101],"industry":[],"product":[36591,36751,36551,42661],"class_list":["post-68211","blog","type-blog","status-publish","format-standard","hentry","category-data-management","category-defense","category-electric-gas","category-national-government","category-local-government","category-mapping","category-natural-resources","category-petroleum","category-public-safety","category-state-government","category-telecommunications","category-transportation","category-water","tag-arcgis-for-electric","tag-arcgis-for-gas","tag-esri","tag-excel","tag-hydro","tag-location-analytics","tag-maps","tag-microsoft","tag-microsoft-office","tag-national-government","tag-oceans-and-maritime","tag-open-data","tag-public-safety","tag-telecom","tag-transportation","tag-utilities","tag-water-utilities","product-apps","product-esri-maps-office","product-arcgis-online","product-arcgis-solutions"],"acf":{"short_description":"More speed? More power? You got it. Here\u2019s one easy how-to with Esri Maps for Office that will dramatically increase your ninja factor....","flexible_content":[{"acf_fc_layout":"content","content":"

More speed? More power? You got it. Here\u2019s one easy how-to with Esri Maps for Office that will dramatically increase your ninja factor.<\/strong><\/p>\n

In our previous post, we showed you how Esri Maps for Office can quickly access a treasure trove of data from inside Microsoft Excel<\/a> you never knew you had.<\/p>\n

Now, here\u2019s one tip that will raise your ninja factor significantly. This one small feature relating to data enrichment<\/a> can dramatically improve the quality of your analysis.<\/p>\n

What is it? Looking at data based on drive time from your target locations, instead of a distance radius.<\/p>\n

Why is this significant? Depending on which you choose, the difference can be as dramatic as night and day.<\/p>\n

\"\"<\/a>\"\"<\/a><\/p>\n

By\u00a0default, Esri Maps for Office pulls data\u00a0from\u00a0a\u00a01-mile\u00a0distance radius\u00a0from\u00a0your\u00a0target locations. (You can see this here<\/a>.)<\/p>\n

However, as we know, most people live along roadways, and commute by car.<\/p>\n

When a retail store is deciding where to locate its next store, for example, drive-time analysis like this is critical. After all, it is far more relevant to know the characteristics of people who live within a 10-minute drive of your store, than of people who live on the other side of the lake (who would be better served by other stores) just because they fall within a 1-mile radius.<\/p>\n

Try it for yourself by firing up Esri Maps for Office<\/a> in Microsoft Excel (requires sign-in with an ArcGIS Online or Portal for ArcGIS account). Here\u2019s a quick video showing how you can add drive-time analysis to your work.<\/p>\n