How to Use Built-In Geography Feature in MS Excel

How to Use Built-In Geography Feature in MS Excel

This guide is about How to Use Built-In Geography Feature in MS Excel. So read this free guide, How to Use Built-In Geography Feature in MS Excel step by step. If you have query related to same article you may contact us.

How to Use Built-In Geography Feature in MS Excel – Guide

You want to keep your geographic data as basic as possible when placing it in your Microsoft Excel workbooks. What better way to do this than with a map of the world? You don’t need expert assistance to create a complex map chart thanks to Microsoft Excel’s built-in Geography data function. Data types provide links to information in the cloud after you apply them to your data. You have access to an unlimited scope of valuable data for your project by integrating your data in the spreadsheet with the data in the cloud.

You can get rich geographic data into your Excel spreadsheets using the Geography data type. Here it is how to make good use of it!

When working with Microsoft Excel spreadsheets, there are cases where you will need to include geographic data. Fortunately, Microsoft Excel makes this possible in a few simple steps. It’s as simple as converting your data to the Geography data type. You will be able to link your data to an internet data source if you do so. If you have a free Microsoft account or a Microsoft 365 subscription, this article will walk you through the process of converting your data to Geography data types.

If you are curious about how to use the built-in map links in Excel, here is a guideline on how to successfully create a map link.

  • Type your text into their respective cells. Make sure your data is geographic. This means it must be a country, territory, province or city in each of the required cells in your spreadsheet.
  • Click on the cells that contain the data to select it.
  • If you want to have an easier time working with your data, generate a professional table that will help you manipulate your data. You can do this by clicking Insert, then Table.
  • Click Data tab > Geography.
  • Excel will automatically convert your data to a Geography data type if there is a match between your data in cells and data in online sources.
  • Click one or more cells that contain the Geography data type.
  • Click on the Insert Data button button.
  • To extract more information, click on a field name. For example, clicking Population in the Geography data type will provide more data about the field.
  • To add more fields to your worksheet, click the Insert Data button again button and follow the process above.
  • You can update the data to newer versions by right-clicking the cell that contains your Geographic data, selecting Data Type > Update. This process will update all linked data in the worksheet.
  • Creating your custom values

    Once you’ve entered your data types and relevant data links, you can choose to add custom values ​​based on your spreadsheet and the type of data you handle. If, for example, you want to create values ​​for the number of hotels in a city, you can easily do this by creating your custom value.

    Unlinking your data cells

    If you want to unlink your data cells from online cloud sources, the process is quite simple.

  • Click a cell that contains the linked data type.
  • Copy it by pressing Ctrl+C.
  • Press CTRL+ALT+V.
  • Choose the Values ​​option.
  • This process will paste all your copied values ​​into a different cell without allowing the feature’s update functionality.
  • exchanging your data

    You can also switch the data type in your worksheets whenever you want. To do this;

  • Right-click on the specific cell whose data you want to change.
  • Click on the Data Type option.
  • Click Change.
  • Clicking Change will bring up a panel on the right.
  • Use the dashboard to search for the data you want.
  • Click Select when you find the appropriate information you intend to use.
  • The information will appear in place of your initial data.
  • Removing data types

    When working on your worksheets, you may decide to eliminate data types that you have already entered. here is one guide about how to remove data types from your worksheet.

  • Right-click the cell that contains the data type.
  • Select the Data type option.
  • Click Convert to Text.
  • Your computer will then convert your data type to regular text. Your cell phone no longer has a connection to the online cloud.
  • Note that you will lose all data initially extracted from the data type once you do this. In its place, you will notice an error message (#FIELD!).
  • Advantages of using data types

  • Saves you time by automatically extracting data and values ​​from online sources. That way, you don’t have to enter multiple values ​​into your spreadsheet manually.
  • They categorize your data based on online matches. This gives you a wider scope of data compared to your manual searches.
  • They increase the precision of your values. Automated processes generally generate higher levels of accuracy compared to manual options.
  • They allow for easy updating of relevant fields. Your updates are just a click away. All you have to do is click on update button.
  • Final note

    I hope you like the guide How to Use Built-In Geography Feature in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.

    We will be happy to hear your thoughts

    Leave a reply

    How to Guides, Best Lists, Top 10 and Tech News - Compsmag
    Logo