CLASS-1-EXCEL INTRO & PASTE SPECIAL
PASTE SPECIAL01:07:22
RESOURCES-EXCEL INTRO
CLASS-2-CELL REFERENCE
CELL REFERENCE00:00:00
RESOURCES-CELL REFERENCE
CLASS-3-RECAP & CUSTOM FORMAT
CUSTOM FORMAT00:45:26
RESOURCES-CUSTOM FORMAT
CLASS-4-MCQ ASSESSMENT & RECAP
MCQ & RECAP00:52:05
MCQ ASSESSMENT
CLASS-5-CONDITIONAL FORMATING
CONDITIONAL FORMATING01:05:35
RESOURCES-CONDITIONAL FORMATING
CLASS-6-FORMULA VS FUNCTION
FORMULA VS FUNCTION01:02:58
RESOURCES-Formula vs Function
CLASS-7-LOGICAL FUNCTION-IF & NESTED IF
LOGICAL FUNCTION00:57:41
RESOURCES-LOGICAL FUNCTION00:00:00
CLASS-8-LOGICAL FUNCTION
LOGICAL-AND OR00:54:00
RESOURCES-LOGICAL
CLASS-10-MATH FUNCTION
MATH FUNCTION00:51:35
RESOURCES-MATH
CLASS-11-MATH FUNCTION
MATH FUNCTION00:38:33
RESOURCES-MATH
CLASS-12-TEXT FUNCTION
TEXT FUNCTION00:59:38
RESOURCES-TEXT FUNCTION
CLASS-14-TEXT
TEXT00:50:45
RESOURCES-TEXT ADVANCED
CLASS-16-DATE FUNCTION
DATE FUNCTION00:50:34
RESOURCES-DATE FUNCTION
CLASS-17-DATE FUNCTION
DATE FUNCTION00:52:51
RESOURCES-DATE
CLASS-18-STATISTICAL FUNCTION
STATISTICAL00:57:07
RESOOURCES-STATISTICAL
CLASS-19-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:56:28
RESOURCES-STATISTICAL
CLASS-20-DATABASE & INFORMATION FUNCTION
DATABASE & INFORMATION00:45:15
RESOURCES-DATABASE & INFORMATION
CLASS-21-SECURITY
SECURITY00:55:54
RESOURCES-SECURITY
CLASS-22-GOTO SPECIAL NAMING RANGE
GOTO00:50:00
RESOURCES-GOTO SPECIAL
CLASS-23-SORTING & FILTER
SORTING & FILTER00:49:12
RESOURCES-SORTING
CLASS-24-ADVANCED FILTER-SUBTOTAL
ADVANCED FILTER-SUBTOTAL00:53:50
RESOURCES-ADVANCED FILTER-SUBTOTAL
CLASS-25-TEXT TO COLUMN-FLASH FILL
TEXT TO COLUMN00:44:34
RESOURCES-TTC-FLASH FILL
CLASS-26-DATA VALIDATION
DATA VALIDATION00:38:16
RESOURCES-DATA VALIDATION
CLASS-27-WHAT IF ANALYSIS
WHAT IF00:51:06
RESOURCES-WHAT IF
CLASS-28-WHAT IF ANALYSIS
WHAT IF00:45:19
RESOURCES-WHAT IF
CLASS-29-ARRAY
ARRAY00:16:26
RESOURCES-ARRAY
CLASS-30-SUMPRODUCT
SUMPRODUCT00:46:08
RESOURCES-SUMPRODUCT
CLASS-31-SUMPRODUCT
SUMPRODUCT00:42:26
RESOURCES-SUMPRODUCT
CLASS-32-VLOOKUP
VLOOKUP00:49:39
RESOURCES-VLOOKUP