Financial Modelling using Dynamic Arrays: Let Lambdas Extend Your Range
1146719129
Financial Modelling using Dynamic Arrays: Let Lambdas Extend Your Range
14.99 In Stock
Financial Modelling using Dynamic Arrays: Let Lambdas Extend Your Range

Financial Modelling using Dynamic Arrays: Let Lambdas Extend Your Range

by MrExcel's Holy Macro! Books, Liam Bastick
Financial Modelling using Dynamic Arrays: Let Lambdas Extend Your Range

Financial Modelling using Dynamic Arrays: Let Lambdas Extend Your Range

by MrExcel's Holy Macro! Books, Liam Bastick

eBook

$14.99 

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers

Product Details

ISBN-13: 9781837023189
Publisher: Packt Publishing
Publication date: 12/17/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 596
File size: 62 MB
Note: This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Liam Bastick has over 30 years' experience in financial model development / auditing. With over 2,000 articles written for the accounting profession, he is a regular contributor to the AICPA, Microsoft's Excel Blog and various LinkedIn specialist discussion groups. A frequent public speaker, Liam attends Excel and Power BI conferences around the globe and has been a central organiser for the Excel Summit South and Excel Virtually Global. He still follows Derby County and the England cricket team. Poor soul.

Table of Contents

Table of Contents
  1. Introduction
  2. Key Excel Functions
  3. Key Excel Functionalities
  4. Other Excel Pointers
  5. Introducing Arrays
  6. Dynamic Arrays
  7. LET and LAMBDA
  8. LAMBDA Helper Functions
  9. GROUPBY, PIVOTBY, PERCENT OF, and ETA LAMBDAS
  10. Best Practice Methodology
  11. Layout Tips
  12. Time Series Analysis
  13. Error Checks
  14. Model Template Example
  15. Financial Statement Theory
  16. Control Accounts
  17. Repeatable Calculations
  18. Example Model Build
  19. Ratio Analysis
  20. Going Out as a LAMBDA
  21. And Finally...
From the B&N Reads Blog

Customer Reviews