Excel Magic - Building Dynamic Formulas

Excel Magic - Building Dynamic Formulas

The 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!

Next, 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:

o Dynamic range formula

o Table formula

o Conditional formula,

o SUMPRODUCT()

o INDIRECT/ADDRESS

o Array formula

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

o SORT()

o XLOOKUP()

Building Dynamic Formulas

Url: View Details

What you will learn

• Intermediate to Advanced Excel skills that will help you
• - to ace your Excel skills,
• - to find state-of-the art Excel functions,

Rating: 3.75

Level: Intermediate Level

Duration: 1 hour

Instructor: Lenny Wu, MBA, CPA, CGA