You can now author queries from local files, SharePoint, OData and various other sources with the Power Query Editor in Excel for Mac.

February’s updates include the ability to manually sort row and column values in PivotTables to users of Excel for the web. For Insiders, users can also check out automatic recalculation optimisation – but that’s not all.

Power Query in Excel for Mac allows you to get and transform your data from various data sources. Up until now, importing data in Power Query in Excel for Mac was available only from Excel workbooks and Text / CSV files.

This latest set of updates see TypeScript support added in the developer playground sandbox and several new formatting features amongst other tweaks.

The latest updates see the release of PivotTable ‘Show Details’ in Excel for the web and the ability to automate your tasks with the Power Automate tab in Excel for Windows and Mac. For Insiders users on Windows and Mac, you can try recording your worksheet actions using Office Scripts and checking your formula with the Value Preview ToolTip.

Microsoft has just added ToolTips to help you check your formulae directly in the Formula bar or in the cell you’re editing.

The latest update sees the release of ‘Formula Suggestions’ and ‘Formula by Example’ for Excel web users: these are brand new capabilities designed to help save you time and learn more about Excel formulae as you use them. Also for web users are ‘Suggested Links’, the IMAGE function and a new Search bar in the Queries pane. For Windows users, a new keyboard shortcut is available to open the Power Query editor, and Insiders users on Windows can now get data from dynamic arrays and create nested Power Query data types to better organise your data.

If our Final Friday Fix challenges don’t quite scratch your Excel itch, there are plenty of Excel challenges to be found out in the wild.

The latest updates see Microsoft add a slew of DAX functions (well, three anyway!), improve slicer type formatting and bring Metrics to the Windows application.

This is going to stuff up a few textbooks! Power BI is updating its accent colour to teal.