Рет қаралды 6,490
In this video we walk through 20 Excel Formulas to learn for any job interview!
Please check out our website at www.EssentialsExplained.com
...and follow us on LinkedIn: / essentials_explained
BASIC Formulas & Functions Playlist - • Excel - Basic Formulas...
ADVANCED Formulas & Functions Playlist - • Excel - Advanced Formu...
50 Excel Shortcuts - • 50 Excel Shortcuts you...
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