Course Curriculum
- 2 sections
- 13 lectures
- 00:00:00 total length
-
Building basic math formulas
00:08:00 -
Autosum and Relative references
00:09:00 -
Absolute references
00:06:00 -
Named Ranges
00:06:00 -
Linking sheets and workbooks
00:06:00 -
If, And, Or, and the nested If functions
00:16:00 -
Countif, Sumif, Averageif, Sumifs, and Countifs functions
00:09:00 -
Vlookup and Hlookup functions
00:15:00 -
Match and Index functions
00:07:00 -
Date and time formulas and functions
00:12:00 -
Text functions
00:11:00 -
Tracing formulas
00:08:00
-
Assignment – Excel Must know Formulas and Functions
00:00:00