Advanced Formulas

Following is the list of all courses tagged as covering understanding and creation of advanced formulas for complex modelling and analysis.  These formulas will use advanced techniques to derive the required results and may rely on some abstract concepts.  The use of the LET function to add clarity to multistep calculations to make them easier to manage and understand than heavily nested formulas may be demonstrated.

Title Modified Date
Financial Analysis Certificate 07 May 2024
M02 - Implementing Complex Scenarios in Cash Flow Models 07 May 2024
M05 - Dynamic Array Formulas in Forecasting 07 May 2024
M06 - Dealing with Interest Circularity 07 May 2024
T02 - Advanced Analytic Formulas 07 May 2024
T04 - Date Sensitive Forecasting & Reporting 07 May 2024
T06 - Save Time - Build a Template for Reuse and Standardisation 07 May 2024
T09 - Using LET to Add Transparency to Complex Calculations 07 May 2024
T10 - Advanced Formula Environment and LAMBDAs - A Revolution in Excel 07 May 2024
T11 - Structuring and Accessing Data in Models 07 May 2024