Microsoft decided to get busy before they broke up for the seasonal year-end break. Excel for the web benefitted immensely with a raft of new features / updates...

This month’s updates see a new sparklines Preview feature, several new Format Pane updates, e-mail subscription access via Admin API and numerous other useful features.

If you have ever collaborated with someone else in a workbook and suddenly notice that the data table you’re looking at has changed drastically, this often happens because someone has filtered or sorted the table while you were looking at the data. Microsoft accepts that while people want to work together in a file, it doesn’t necessarily mean everyone has the same task at hand. To provide users with the freedom to collaborate as they want, they have previously developed Sheet View.

For many years, Microsoft Excel used to only allow two types of data: text and numbers. But that’s changing: Microsoft is opening up Excel to provide you with the freedom to create your own custom data types that can contain images, arrays and more.

To replace Excel UserVoice, the software giant has introduced their new Microsoft Feedback portal, where you may submit suggestions about Excel and other Microsoft products, vote and comment on suggestions made by others, and see feedback submitted.

This month’s updates see the release of a new Format pane Preview feature, Page and Bookmark navigators and new text box formatting options, amongst other goodies.

This month’s updates see the release of additional functionality and performance improvements for DirectQuery and optimisation for the SWITCH function, amongst other enhancements.

Ah, to have been working 43 years ago...

It's not far off now!! We are back for a SEVENTH time! Do you think a pandemic will stop us..? 50+ presenters from all over the globe speaking on all things Excel and Power BI. It's for charity!

There have been some recent updates to the threaded comments and notes experience in Excel.