/* ---- Google Analytics Code Below */

Thursday, October 29, 2020

Custom Live Data Drama in Excel

Though its now quite outdated, we used to do lots of things in spreadsheets, remember this could have been very useful.   Drama?   Well maybe. 

Microsoft Excel spreadsheets now take custom live data

Who knew spreadsheets could be exciting?  By Jon Fingas, @jonfingas in Engadget

Microsoft is still finding ways to inject drama into spreadsheets. The Verge reports that Microsoft is giving Excel support for custom live data types, expanding the content you can include well past text, numbers and the occasional stock quote. You could slip a country’s data into a cell and create a formula that extracts the most recent population for your sheet, for example.

The approach works by using logic to structure the data you insert into a given cell, using Power BI to connect data types with Excel for business users. Existing cells can even be turned into linked data types, and you can use a Power Query feature to turn imported data into its own type. ... " 

No comments: