Microsoft brings custom data types to Excel

[Daniel Sims]

In a nutshell: Up until recently, Microsoft Excel users have only been able to enter text and numbers as data into cells. One of the announcements Microsoft made at its Ignite 2021 event this week is the addition of more types of information users can enter into Excel, on top of additions it has made in recent years.

Microsoft will soon open up a preview of a new JavaScript API for Excel that will let users make their own custom data types containing things like images, entities, arrays, or formatted number values. These can all be backed up by users' own custom data sources. Users will also be able to make custom functions that can use these data types as both inputs and outputs.

Microsoft published a blog post elaborating on the changes to Excel as well as other parts of Microsoft Office, and includes animated gifs showing Bloomberg using the new data types. The gifs show someone entering a graph into an Excel chart by entering what looks like a formula. Another shows them dragging locations from a world map into cells in a chart, incorporating them with formulas on that chart.

In 2018, Microsoft added AI-powered stocks and geography to data types. Last year it started letting users enter their own data as a data type, and announced plans to add over 100 more data types going forward like chemistry, elements, food, and more.

At Ignite 2021, Microsoft also announced changes to PowerPoint, the Office app, and more. It announced a whole new video editing app called Clipchamp, along with more significant changes to Microsoft Office applications.

Permalink to story.

https://www.techspot.com/news/92052-microsoft-brings-custom-data-types-excel.html

 

[Dimitriid]

*Exasperated sigh*

I work in Business Intelligence and the company is investing literally millions to get people AWAY from using excel for everything and actually learn to use verified, useful, accurate data instead.

But nope: let's just put more sh*t on the already bloated excel so people can just keep literally making up numbers for their presentation and managers keep wasting most of their time arguing who's numbers are actually correct instead of you know, using data to plan things.

I know what they're trying to accomplish but this is functionality that would have been sooo much more useful on another key Microsoft product: POWER BI.

 

[Uncle Al]

Wouldn't it be nice to have a simple modification table where you could add or remove functions from excel, on the fly as well!

 

[about30ninjas]

Because macros weren't already a security issue, lets add JavaScript ffs! lmao

 

[GregonMaui]

Maybe they will get rid of that terrible ribbon and allow multiple tables per sheet instead of sub-tables, and hire a UI design team that is out of Kindergarten.