Develop Dynamic Excel Worksheets by Mastering Excel's INDEX and MATCH functions (Excel 2007, 2010, 2013, 2016)
InstructorKyle Pew • 2,000,000+ Students
Free
Instruction is paired with downloadable files that encourage reinforcing concepts through repeated application and manual formula construction.
The teaching approach emphasizes the underlying logic of formula creation, helping learners understand why specific functions are used in various scenarios.
While strong on core lookups, some advanced multi-value formulas are noted as being difficult to grasp due to their length and complexity.
The curriculum focuses heavily on specific lookup mechanics, which may feel limited for those expecting a broader advanced functions survey.
The curriculum aligns well with the stated goal of mastering INDEX and MATCH for users with basic function experience.