Excel expands connected data types as it evolves into a real-time data tracker

Microsoft on Thursday leaned more heavily into its support for “data types” within Excel, going beyond the staid concept of numbers and formulas to embrace a huge variety of elements that could reside within a single cell.

Microsoft calls data types the “third dimension” of an otherwise two-dimensional Excel cell, and it’s easy to see why. In 2019, Microsoft introduced the first two data types: “stocks” and “geography.” If you input a stock symbol into a cell, and then identify it as a stock symbol using the Data > Data Types > Stocks identifier, the term “MSFT” opens the door to numerous fields of live data which can be set as separate cells, columns or more. You can always get the latest data by tapping the “Refresh data” button within Excel.

To read this article in full, please click here

from PCWorld https://ift.tt/3jDXYm5