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.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Students (secondary or post secondary)
- Office workers
- Professionals, and Managers
Requirements:
- 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.
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
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.
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 | ||
About This Course
Who this course is for:
- Students (secondary or post secondary)
- Office workers
- Professionals, and Managers
Requirements:
- 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.
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
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.
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 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved