Dynamic Arrays

Following is the list of all courses tagged as covering the use and understanding of dynamic array formulas in Modern Excel.  This includes the use of the new reference operators, the key dynamic array functions and the use of older functions in constructing forecasting and analytical arrays. Techniques for calculating arrays of conditions where AND and OR cannot be appropriately used are demonstrated.  Functions typically covered include SEQUENCE, UNIQUE, FILTER, BYCOL, BYROW, TAKE, INDEX (array form) and LET.  Check the course description for which specific functions are included.

Title Modified Date
ENCODEURL 05 January 2024
Financial Analysis Certificate 07 May 2024
LAMBDA 16 February 2024
LET 05 January 2024
M01 - Fundamentals of Model Design & Development in Excel 07 May 2024
M02 - Implementing Complex Scenarios in Cash Flow Models 07 May 2024
M03 - Building Valuation Models with Less Complexity 07 May 2024
M05 - Dynamic Array Formulas in Forecasting 07 May 2024
M06 - Dealing with Interest Circularity 07 May 2024
T01 - Function & Formula Fundamentals 07 May 2024
T02 - Advanced Analytic Formulas 07 May 2024
T04 - Date Sensitive Forecasting & Reporting 07 May 2024
T05 - Building Dynamic Charts 07 May 2024
T09 - Using LET to Add Transparency to Complex Calculations 07 May 2024