This site use cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.
Even before releasing Excel’s new array functionality to the general public, Microsoft has improved one function and replaced another in a move that could put current spreadsheets @ risk.
With the right toolset of techniques, you can design spreadsheet models that smoothly produce forecast projections using historical and current information.
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 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.
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 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.
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.