Скачать или смотреть Excel Charts - Mapping Data with Map Point - Episode 1318

Microsoft Excel Tutorial: Creating Visual Representations of Geographic Data in Excel | MrExcel Podcast.

Welcome to the MrExcel podcast. In this episode, we will be discussing how to create visual representations of geographic data using charts and graphs. This is an essential skill for anyone working with data that has a geographic component, such as postal codes, zip codes, or latitude and longitude coordinates. By visualizing this data on a map, you can gain valuable insights and make informed decisions.

One tool that can help you achieve this is Microsoft Map Point. This program has versions for the U.S., Canada, and Europe, making it a versatile option for users around the world. With Map Point, you can easily import data from Excel and choose how you want it to be displayed on the map. For example, if you have a database of Chipotle restaurants in the U.S. with latitude and longitude coordinates, you can use Map Point to plot them on a map.

Map Point offers various options for visualizing your data, such as using thumbtacks or small circles. You can also zoom in on specific areas to get a more detailed view. This is particularly useful if you want to analyze the distribution of your customers or target areas for advertising. By using Map Point, you can easily identify hotspots and make data-driven decisions.

Thank you for tuning in to this episode of the MrExcel podcast. We hope you found this tutorial on creating charts and graphs for geographic data helpful. Don't forget to subscribe to our channel for more informative netcasts from MrExcel. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Excel Charts
(00:10) Mapping Customers with Map Point
(00:20) Importing data from Excel
(00:40) Choosing visualization options
(01:02) Zooming in on specific locations
(01:34) Benefits for businesses with customer data
(01:48) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Advertising
Chipotle restaurants
Customer hot spots
Excel Charts
Geographic data in Excel
Latitude and longitude
Mapping Customers
Microsoft Map Point
Netcast from MrExcel
Visualize data on a map


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...


Data is great stuff. Adding a visual component to enhance the appeal of your data? Awesome! Today, in Episode #1318, Bill shows us how to use Microsoft Map Point in conjunction with our Data Set in Excel 2010 to produce a great visual! Try it!

From Chapter 10...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.