Blogs

Microsoft announce new Text and Array functions for Excel

The release of LAMBDA has been celebrated as a seminal moment for Microsoft Excel – paralleled only by the Pivot Table back in 1994. And this comes hot on the heels of Data Types and Dynamic Array functionality. It’s an exciting time for us Excel geeks.

The different modelling standards are more alike than they are different. They all emphasise similar elements of good practice. What’s important is to pick one and apply it consistently. When I started in financial modelling, I worked for one of the Big 4.

In this series of articles, we will look at the future of Excel.

The FAST Standard For those of you unfortunate enough to have been within earshot when I start to talk enthusiastically about my spreadsheet work (we’re a rare breed I know…), you may be familiar with the phrase “FAST modelling”, “FAST standard”, or something similar.

Discover the key Excel functions for financial modelling.

Sum rows that meet specifc criteria

Looks up values from another table

Returns a value from a range based on the position specified