Microsoft Excel tips and tricks

Will Dynamic Arrays kill Data Tables, PivotTables?

In the final instalment of a seven-part series, Excel MVP Liam Bastick wraps up his examination of Excel’s new Dynamic Arrays capabilities by assessing how they could affect Excel features Data Tables and PivotTables.

Focus on 2 new Excel functions: UNIQUE and FILTER

In Part 5 of a seven-part series, Excel MVP Liam Bastick takes a look at two of the seven new functions Microsoft has created to go with its spreadsheet program’s new Dynamic Arrays capabilities.

Excel new function focus: SEQUENCE and RANDARRAY

In Part 6 of a seven-article series, Excel MVP Liam Bastick explores two of the seven new functions Microsoft has created to go with its spreadsheet program’s new Dynamic Arrays capabilities.

This Excel change is more than SORT of a big deal

In Part 4 of a seven-part series, Excel MVP Liam Bastick takes a look at two of the seven new functions Microsoft has created to go with its spreadsheet program’s new Dynamic Arrays capabilities.

Excel: 2 new errors and a SINGLE function

What happens when something goes wrong related to Excel’s new Dynamic Arrays capabilities? Excel MVP Liam Bastick takes a look in this instalment of a seven-part series.

Excel: Microsoft unveils Dynamic upgrades

In the first instalment of a seven-part series, Excel MVP Liam Bastick introduces the first major leap forward to spill from Microsoft’s partial rewrite of its spreadsheet application’s “calculation engine”.
Advertisement
Advertisement
Advertisement