In August 2022, Microsoft introduced exciting new features and 14 new functions.
The Insider features will also gradually roll out to everyone.
Another exciting addition is the TEXTSPLIT function which lets you split text across multiple rows or columns.
Expand Dynamic Arrays
Excel has also introduced the EXPAND function that helps you expand your dynamic arrays.
For example, by refreshing a group, you’re able to refresh all queries inside the group.
Moreover, Excel now lets you reorganize the Power Query groups more efficiently.
you could move a query or group into another group or remove certain queries from a group.
Likewise, you could expand or collapse all Power Query groups, simultaneously.
Lastly, changing the group name and description has become more straightforward using Properties.
For more efficient analysis, Excel has introduced two new improvements:
5.
Previously, when you inserted an image into your spreadsheet, it hovered over the cells.
You only need to enter a source location into the image function formula to get the image.
The formula also lets you enter alternative text and predefine the image dimensions.
you might choose the Show Changes option in the Review tab to see the changes made in your workbooks.
