Excel data types: Stocks and geography - Microsoft Support
You can get stock and geographic data in Excel. It's as easy as typing text into a cell, and converting it to the Stocks data type, or the Geography data type. These two data types are considered linked data types because they have a connection to an online data source.
Get geographic location data - Microsoft Support
To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total population, or Time zone. Note: The Stocks data type is only available to Microsoft 365 accounts or those with a free Microsoft Account.
About the Stocks financial data sources - Microsoft Support
When you use the Stocks data type or the STOCKHISTORY function to obtain stock prices and other company information, that information is provided by another company. Fundamental company data, historical data, real-time and delayed prices, fund summary and performance data are provided by Refinitiv.
Translate text into a different language - Microsoft Support
In Word for Microsoft 365 when you open a document in a language other than a language you have installed in Word, Word will intelligently offer to translate the document for you. Click the Translate button and a new, machine-translated, copy of the document will be created for you.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Import or export text (.txt or .csv) files - Microsoft Support
There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down …
Create a Map chart in Excel - Microsoft Support
You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. : This feature is available if you have a Microsoft 365 subscription.
Add East Asian fonts in Windows 10 for use with Office documents
To add the East Asian fonts, you need to install the East Asian language. Installing the East Asian language does not necessarily change the default language you use with Windows; it simply adds the East Asian language as an additional language and downloads the related fonts.
Load the Solver Add-in in Excel - Microsoft Support
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel. Click Go. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
Excel Functions Translator - Microsoft Support
Enables users to easily translate full formulas to their native language. Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions. Provides an efficient way to search for any part of a function's name in both languages selected.
Switch between languages using the Language bar - Microsoft …
After you enable the keyboard layout for two or more languages in the Windows operating system, you can use the Language bar to switch between languages that use different keyboard layouts.