In this video we walk through 20 Excel Formulas to learn for any job interview! Please check out our website at ...and follow us on LinkedIn: BASIC Formulas & Functions Playlist - ADVANCED Formulas & Functions Playlist - 50 Excel Shortcuts - 0:00 Introduction 0:30 SUM Formula 0:48 AVERAGE Formula 1:11 COUNT Formula 3:29 VLOOKUP Formula 3:57 INDEX MATCH 4:19 XLOOKUP Formula 6:42 DATEDIF Formula 7:33 DAYS Formula 8:00 TODAY Formula 8:18 LEFT Formula 8:36 RIGHT Formula 8:57 MID Formula 9:39 CONCAT Formula 10:02 SUBSTITUTE Formula 10:30 TRIM Formula 11:36 BONUS UPPER, LOWER, PROPER