News

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.

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 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.

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.

Lessons learned in app development

An app’s development is only the start of its business journey. Finance director and entrepreneur Maciej Kubat, ACMA, CGMA, offers lessons learned.

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.
Advertisement
Advertisement
Read the latest FM digital edition, exclusively for CIMA members and AICPA members who hold the CGMA designation.
Advertisement