About This Course

The course relates to the earlier course of Top Five Excel Skills – How To Break The Vicious Cycle 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:

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

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

  • SORT
  • XLOOKUP

Prerequisites and advanced preparation:

  • Should have taken Top Five Excel Skills – How To Break The Vicious Cycle
  • Basic Excel knowledge such as being able to open one Excel file and connect to external data files, etc.

Who this course is for:

  • Students (secondary or post secondary) 
  • Office workers
  • Professionals, and Managers

Our Promise to You

By the end of this course, you will have learned to create dynamic formulas with Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about dynamic formulas.

Course Curriculum

Section 1 - Introduction
Introduction 00:00:00
Course Resources 00:00:00
Recap Of Prior Excel Course: Top Five Excel Skills 00:00:00
Hierarchy Of Excel Modeling Techniques 00:00:00
Instructor’s Background 00:00:00
How This Course Is Compared With “Other Similar Courses”? 00:00:00
What You Will Get From This Course 00:00:00
Section 2 - Dynamic Formulas - Basic
Intro To Dynamic Formulas 00:00:00
References: Absolute vs Relative Reference 00:00:00
Conditional formulas: IF() 00:00:00
Table Formula 00:00:00
Section 3 - Dynamic Formulas - Intermediate
Lookup Formula: INDEX/MATCH 00:00:00
Lookup And Sum Formulas: SUMPRODUCT/SUMIF/SUMIFS 00:00:00
Multi-tab Formula: SUM(START:END!) 00:00:00
Link To Pivot Table Formula: GETPIVOTDATA() 00:00:00
Section 4 - Dynamic Formulas - Advanced
Parameterized Formulas: INDIRECT/ADDRESS 00:00:00
Dynamic Range Formula: OFFSET 00:00:00
Array Formulas 00:00:00
Section 5 - New Feature – Excel 365: Dynamic Array formulas
Dynamic Array Formulas (Excel 365): SORT 00:00:00
Dynamic Array Formulas (Excel 365): XLOOKUP 00:00:00
Dynamic Array Formulas (Excel 365): Spill Range 00:00:00
Section 6 - Conclusion
Takeaways 00:00:00
Next Course and Q and A 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel