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
