Back in November last year, Microsoft announced several new functions, including PIVOTBY, and eta lambdas such as PERCENTOF. On the quiet, they have added a new argument which makes PIVOTBY just that little bit more powerful...

Generating multiple formula columns, creating complex formula columns that span across multiple tables and new ways to engage with Copilot in Excel are now all available to Excel users on web and Windows (subject to roll out)...

This month’s updates see line enhancements, supporting folders in workspace, dynamic subscriptions for Power BI and paginated reports, amongst other newbies.

Another busy month for Power BI (just for a change!). There are new updates for Visual calculations, editing your data model in the Power BI Service, and deliver report subscriptions to OneDrive SharePoint.

This month sees Export to CSV and Show Details in PivotTables are now available in Excel for the web. Also, creating Power BI-connected tables is available in Excel for Windows users, together Office Scripts for Office 365 E1 and F3 licenses.

Fantastic news for Leap Day: we are very pleased to announce US head honcho Steve Kraynak has been awarded Microsoft’s Most Valuable Professional (MVP) award for Excel.

This month sees the ‘Chart data’ task pane and the ability to use images and Data Types in your PivotTables both now available in Excel for the web. The new default theme for Office is Generally Available in Excel for Windows and Mac too.

There are some great updates this month. Visual calculations make their debut and are accompanied by the new-look Power BI Home (for Desktop) and an ability to add descriptions to your semantic model measures.

The Forms data synchronisation to Excel (for the web) is now available in Microsoft Forms.

This month’s updates see users able to synchronise form data to Excel for the web. ‘Insert pictures into cells’ is available to users of Excel on Windows and Mac, and PivotTables now has expanded functionality in Excel for iPad.