Excel Magic 1: Building Dynamic Formulas

This course is presented in four parts.

First, the course relates earlier course of Top 5 Excel Skills to drive the concept home: Dynamic formulas are your “first” step toward full automation in Excel Modeling!

Second, the course brings the topic of what is a dynamic formula and let students consider if VLOOKUP() is a dynamic formula? It is only a semi-dynamic formula.

Third, we illustrate the top 10 dynamic formulas, including:

• Dynamic range formula
• Table formula
• Conditional formula
• SUMPRODUCT()
• INDIRECT/ADDRESS
• Array formula

Last, the course explores latest features from Excel 365 that are considered by many to be amazing. They include:

• SORT()
• XLOOKUP()

Course Key Concepts: Dynamic formulas, Array formulas, Dynamic array formulas, Absolute reference, Relative reference, Spill range.

The course relates Excel Magic courses series. ‘Building Dynamic formulas’ is the “first” step toward full automation in Excel Modeling.