Get the App
SLTechnology News&Howtos  ›  IT Information  › 

Microsoft Excel PivotTable adds data types such as inserting pictures

Shulou Source: shulou.com Published: 2023-11-24 17:37:59 11月23日 Update

CTOnews.com June 21, Microsoft recently invited Microsoft 365 Preview experience members to test a feature of the Excel PivotTable that allows images and other content to be inserted.

Microsoft says Excel can handle a variety of data types, and cells also support embedding images, but PivotTable reports have previously been limited to text descriptions in these content formats.

Now PivotTable can insert image cards, data type icons, data type cards and other related data types, and users can interact with the source data directly.

CTOnews.com attaches an example from Microsoft's official blog post that embeds an image of a table, chair or other furniture in a PivotTable report.

In another example, the relevant data can be filtered based on the national flags of different countries.

Microsoft suggests that the new Excel PivotTable can control more application scenarios, including product sales summaries, portfolios, sports team analysis, and even art or hobby collections.

Tags: Data type Microsoft images content examples pictures different products product sales features units countries flags icons scenes official furniture suggestions members Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MySQL Linux Shulou Tech Info MariaDB macOS