Financial Modelling using Dynamic Arrays

Let Lambdas Extend Your Range

Liam Bastick

$79.99

Paperback

Forthcoming
Pre-Order now

QTY:

English

Holy Macro! Books
09 July 2025

Finance; Spreadsheet software

RAISING ARRAYS FOR MODELLING

This book tries hard to raze a laugh (yes, that'

s what was meant...

).

Instead, through numerous examples and case studies, it details the impact of the ecosystem introduced by dynamic arrays in Excel, injecting life into the jaded, stale world of financial modelling.

From comparing the old methodologies to the new frontiers, this book considers how dynamic arrays have reshaped Excel and made it Turing complete, with its liberal use of LET, LAMBDA, eta lambdas et al.

LET invites complexity but reduces memory requirements, LAMBDA allows you to build anything, and dynamic arrays make it easy to quite literally extend your ideas and your way of thinking.

See for yourself.

Through a dynamic array of Best Practice tips, tricks, functions and features, Financial Modelling using Dynamic Arrays shows you how to revamp and reinvent your financial models with Excel 365.

Recreate your development kit in this brave new world.

Erase the old and embrace the arrays!

By: Liam Bastick
Imprint: Holy Macro! Books
Country of Publication: United States
Dimensions: Height: 254mm, Width: 165mm, Spine: 30mm
Weight: 943g
ISBN: 9781615470877
ISBN 10: 1615470875
Pages: 400
Publication Date: 09 July 2025
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Forthcoming

Starting off as a university lecturer, Liam has over 30 years' experience in financial model development / auditing, valuations, mergers and acquisitions, project finance, public private partnerships, strategy, training and consultancy. Indeed, he has been appointed as an independent expert for the courts of Victoria and New South Wales, in Australia. He has considerable experience in many different sectors (e.g. banking, energy, media, mining, oil and gas, private equity, retail, transport and utilities) and has worked in many countries.