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.
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.
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.
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.
Efforts of many organisations to get a blockchain up and running stall, a PwC survey suggests. To successfully implement the technology, follow these six strategies.
Conducting scenario planning through analytics can prepare companies and employees to invest their resources wisely and succeed in the jobs of the future.
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.
In this instalment of a seven-part series, Excel MVP Liam Bastick explains how the new Dynamic Arrays capabilities work and how they interrelate with the application’s Tables functionality.
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”.
It might not be the first option you think of, if you think of it at all, but OFFSET can prove very helpful managing ‘what if?’ scenarios in spreadsheet models.
