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
Excel Dummy Sheet: https://docs.google.com/spreadsheets/d/1Dd092lQBV5pNJ0Z56ELH4fnSniUcRqND/edit?usp=drive_link&ouid=110199468232275321205&rtpof=true&sd=true
??? 405