In this video I'll talk about the 4 main excel unctions that you must know in with some background on why you would use them. Timestamps: 00:00 Intro 01:31 Vlookup Intro 02:34 Vlookup Tutorial 10:11 Index-Match Intro 11:13 Index-Match Tutorial 15:31 Pivot Tables Intro 15:56 Pivot Tables Tutorial 19:17 Aggregation & Conditionals 20:30 Tutorial 22:56 1 Interview Tip Download the Excel file (view-only — please make a copy to practice): 👨👩👧 405