Autoplay
Autocomplete
Previous Lesson
Complete and Continue
EY - Financial Modeling (Prep Kit) - 2021
Pre-Session Prep (35 mins.)
Top 10 Must-Know Excel Shortcuts (7:32)
How to audit a Financial Model or a Budget Sheet? (4:51)
Date Formulas - DATE, DAY, MONTH, YEAR (2:09)
Using Cell Reference ($) (6:05)
Logical Functions - IF AND OR (7:58)
MAX() function's use in Financial Models & Budget (2:43)
Data Validation - Drop down list (2:36)
Financial Modeling Pre Training Prep Course Feedback
Post-Session Assignments (50 mins.)
VLOOKUP with MATCH (4:02)
INDEX MATCH (8:12)
SUMIFS & COUNTIFS (10:36)
Data Tables (What If analysis) (8:20)
Goal Seek (What If analysis) (4:31)
OFFSET with MATCH (15:08)
Financial Modeling Pre Training Prep Course Feedback
OFFSET with MATCH
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock