CLASS-1-EXCEL INTRO & PASTE SPECIAL
EXCEL INTRO & PASTE SPECIAL01:13:45
RESOURCES-EXCEL INTRO
CLASS-2-FORMULA REFERENCE
FORMULA REFERENCE00:58:56
RESOURCES-FORMULA REFERENCE
CLASS-3-CUSTOM & CONDITIONAL FORMATTING
CONDITIONAL FORMATTING01:10:24
RESOURCES-CONDITIONAL FORMATTING
CLASS-4-FORMULA VS FUNCTION
FORMULA VS FUNCTION01:08:38
RESOURCES-FORMULA VS FUNCTION
CLASS-5-LOGICAL FUNCTION
LOGICAL FUNCTION01:01:60
RESOURCES-LOGICAL FUNCTION1
CLASS-6-LOGICAL & SUMIF FUNCTION
LOGICAL & SUMIF FUNCTION00:00:00
RESOURCES-LOGICAL FUNCTION
CLASS-7-SUMIFS FUNCTION
SUMIFS FUNCTION00:00:00
RESOURCES-SUMIFS
CLASS-8-MATH & TEXT FUNCTION
MATH & TEXT FUNCTION01:01:27
RESOURCES-MATH & TEXT FUNCTION
CLASS-9-TEXT FUNCTION
TEXT FUNCTION01:03:42
RESOURCES-TEXT FUNCTION
CLASS-10-TEXT FUNCTION
TEXT FUNCTION01:02:53
RESOURCES-TEXT FUNCTION
CLASS-11-DATABASE & INFORMATION
DATABASE FUNCTION00:50:38
RESOURCES-DATABASE-INFORMATION
CLASS-12-DATE & TIME
DATE FUNCTION00:00:00
RESOURCES-DATE
CLASS-13-DATE & TIME
DATE & TIME00:00:00
RESOURCES-DATE
CLASS-14-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:00:00
RESOURCES-STATISTICAL
CLASS-15-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:43:53
RESOURCES-STATISTICAL FUNCTION
CLASS-16-STATISTICAL-PRINTING-NAMING RANGE
STATISTICAL01:04:35
RESOURCES-STATISTICAL
CLASS-17-GOTO SPECIAL-SECURITY
GOTO SPECIAL-SECURITY01:05:55
RESOURCES-GOTO SPECIAL
CLASS-18-ERROR WORLD & INTERVIEW QUESTION
ERROR WORLD01:03:30
RESOURCES-ERROR & INTERVIEW
CLASS-19-SORTING
SORTING00:59:20
RESOURCES-SORTING
CLASS-20-FILTER & ADVANCED FILTER
ADVANCED FILTER01:05:08
RESOURCES-FILTER -ADVANCED FILTER
CLASS-21-SUBTOTAL & TTC
subtotal ttc00:56:29
RESOURCES-SUBTOTAL
CLASS-22-DATA VALIDATION
DATA VALIDATION00:59:09
RESOURCES-DATA VALIDATION
CLASS-23-WHAT IF-CONSOLIDATION-EXTERNAL DATA
WHAT IF-EXTERNAL DATA01:04:41
RESOURCES-CONSOLIDATION-EXTERNAL DATA
CLASS-24-WHAT IF-GOAL SEEK-SOLVER
GOAL SEEK-SOLVER01:20:52
WHAT IF
CLASS-25-WHAT IF-SCENARIO-DATA TABLE
SCENARIO-DATA TABLE01:11:03
RESOURCES-SCENARIO
CLASS-27-ARRAY FUNCTION
ARRAY FUNCTION00:50:16
RESOURCES-ARRAY FUNCTION
CLASS-28-SUMPRODUCT FUNCTION
SUMPRODUCT00:44:38
RESOURCES-SUMPRODUCT
CLASS-29-SUMPRODUCT FUNCTION
SUMPRODUCT00:50:58
RESOURCES-SUMPRODUCT
CLASS-30-SUMPRODUCT
SUMPRODUCT00:51:23
RESOURCES-SUMPRODUCT
CLASS-31-VLOOKUP
VLOOKUP00:56:08
RESOURCES-VLOOKUP
CLASS-32-DOUBLE VLOOKUP
DOUBLE VLOOKUP00:55:17
RESOURCES-DOUBLE VLOOKUP
CLASS-33-HLOOKUP-LOOKUP
HLOOKUP01:00:31
RESOURCES-HLOOKUP-LOOKUP
CLASS-34-MATCH FUNCTION
MATCH FUNCTION00:57:37
RESOURCES-MATCH
CLASS-35-INDEX FUNCTION
INDEX FUNCTION-ARRAY FORMAT00:56:40
RESOURCES-INDEX-ARRAY
CLASS-36-INDEX RECAP
INDEX RECAP00:56:00
RESOURCES-INDEX
CLASS-37-INDEX-REFRENCE FORMAT
REFERENCE00:58:41
RESOURCES-INDEX
CLASS-38-INDEX CF & CHOOSE FUNCTION
CHOOSE00:54:34
RESOURCES-CHOOSE
CLASS-39-INDIRECT FUNCTION
INDIRECT00:57:31
RESOURCES-INDIRECT
CLASS-40-INDIRECT FUNCTION
INDIRECT & INTERVIEW QUESTION00:51:42
CLASS-41-OFFSET
OFFSET100:48:05
RESOURCES-OFFSET
