Lookup and Referencing

Following is the list of all courses tagged as covering the use of lookup and referencing functions to retrieve data, implement scenarios, and drive analysis and forecasting calculations.  The primary functions covered in these courses are MATCH, XMATCH, INDEX, XLOOKUP, and in some cases INDIRECT.

Title Modified Date
A01 - Streamlining Performance Reporting in Excel 07 May 2024
Financial Analysis Certificate 07 May 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
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
T07 - Formula Auditing & Error Tracing & Handling 07 May 2024
T08 - Array Formulas Reinvented 07 May 2024
T09 - Using LET to Add Transparency to Complex Calculations 07 May 2024
T11 - Structuring and Accessing Data in Models 07 May 2024