Financial Modelling Using Dynamic Arrays


December 2024

Financial Modelling Using Dynamic Arrays

Let Lambdas Extend Your Range

Buy Now »

covers: Microsoft 365

Product Details
  • 580 pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-087-7
  • PDF ISBN: 978-1-61547-173-7

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!

  • CHAPTER 0: INTRODUCTION
  • CHAPTER 1: KEY EXCEL FUNCTIONS
  • CHAPTER 2: KEY EXCEL FUNCTIONALITIES
  • CHAPTER 3: OTHER EXCEL POINTERS
  • CHAPTER 4: INTRODUCING ARRAYS
  • CHAPTER 5: DYNAMIC ARRAYS
  • CHAPTER 6: LET and LAMBDA
  • CHAPTER 7: LAMBDA HELPER FUNCTIONS
  • CHAPTER 8: GROUPBY, PIVOTBY, PERCENT OF and ETA LAMBDAS
  • CHAPTER 9: BEST PRACTICE METHODOLOGY
  • CHAPTER 10: LAYOUT TIPS
  • CHAPTER 11: TIME SERIES ANALYSIS
  • CHAPTER 12: ERROR CHECKS
  • CHAPTER 13: MODEL TEMPLATE EXAMPLE
  • CHAPTER 14: FINANCIAL STATEMENT THEORY
  • CHAPTER 15: CONTROL ACCOUNTS
  • CHAPTER 16: REPEATABLE CALCULATIONS
  • CHAPTER 17: EXAMPLE MODEL BUILD
  • CHAPTER 18: RATIO ANALYSIS
  • CHAPTER 19: GOING OUT AS A LAMBDA
  • CHAPTER 20: AND FINALLY...

Where to Buy

Amazon

Print Book from Amazon

Amazon

eBook from Amazon


Related Products


Introduction to Financial Modelling

October 2019

With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.


Continuing Financial Modelling

November 2020

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.


Financial Modelling for Project Finance

December 2024

If you have a beginner’s grasp in accounting, finance and Excel, you might be tempted to explore the quantitative, decision-centric world of Project Finance, ring-fencing funding for profitable projects. This book seeks to demystify the area and show how the basic principles of financial modelling.