Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Financial Modeling Pre Training Prep Course
Financial Modeling Pre Training Prep Course
Practice Files to Download
Why is SUMPRODUCT so important for calculating weighted average? (3:33)
What is "locking" the cell reference - Basics of using $ (3:01)
Learn the two advanced cases of using $ while locking the cell reference (3:19)
4 "must-know" date formulas for every Excel user - YEAR, MONTH, DAY, DATE (2:14)
How to calculate 5th of next month? (3:40)
How to calculate expiry date for agreements and warranty period? (3:54)
How to create a basic drop down list? (2:36)
When do I need to a apply TRUE instead of FALSE in VLOOKUP? (7:14)
How to write IF formulas - Basic to Intermediate level? (5:17)
The two must under-used logical formulas - AND & OR (5:12)
How to add Spin buttons to make your financial model interactive? (5:06)
Financial Modeling Pre Training Prep Feedback
What is "locking" the cell reference - Basics of using $
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock