Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Pre-Training Preparation Kit (Financial Modeling)
Essential Shortcuts
Formula Auditing and Tracking (4:51)
Cell Referencing ($) using F4 ($A$1 vs. $A1 vs. A$1) (3:19)
Essential Formulas
Why is VLOOKUP with TRUE used for Slab-logics? (6:41)
What is 2D Lookup? (4:02)
Combining IF() w. AND() & OR() (3:34)
What If Analysis
What IF Analysis – Using Form Control Buttons from Developer Tab (Spin Bar, Scroll Bar) (5:06)
What IF Analysis – Goal Seek (4:31)
What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & 1 Output (8:20)
Formula Auditing and Tracking
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock