This course is designed for those interested to learn the basics of dynamic formulas, dynamic range formulas, table formulas, conditional and array formulas, and using SORT and LOOKUP.Read more.
Lenny has over 15 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and compliance auditing.
Only want this course? Buy this course for
$199 $29 and keep lifetime access.
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
- Array formula
Last, the course explores the latest features from Excel 365 that are considered by many to be amazing. They include:
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.
10 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.
|Section 1 - Introduction|
|Recap Of Prior Excel Course: Top Five Excel Skills||00:00:00|
|Hierarchy Of Excel Modeling Techniques||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|
|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|
|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|
|Next Course and Q and A||00:00:00|