CLASS-1-WHY MIS & DATA ANALYTICS
WHY MIS & DATA ANALYTICS00:35:42
CLASS-2-EXCEL INTERFACE & OPTIONS
INTERFACE & OPTIONS00:55:10
CLASS-3-PASTE SPECIAL
PASTE SPECIAL00:36:56
RESOURCES-PASTE SPECIAL
CLASS-4-CUSTOM FORMAT
CUSTOM FORMATTING00:43:07
RESOURCES-CUSTOM FORMATTING
CLASS-5-FORMULA REFERENCE & CONDITIONAL FORMATTING
FORMULA REFERENCE & CONDITIONAL FORMATTING01:08:41
RESOURCES – CR-CF
CLASS-6-FORMULA VS FUNCTION-LOGICAL
LOGICAL FUNCTION-IF & NESTED IF01:03:51
RESOURCES-LOGICAL FUNCTION
CLASS-7-LOGICAL
LOGICAL FUNCTION00:46:47
RESOURCES-LOGICAL
CLASS-8-MATH-SUMIFS
SUMIFS00:54:33
RESOURCES-SUMIFS
CLASS-9-TEXT FUNCTION
TEXT FUNCTION-BASICS01:00:11
RESOURCES-TEXT FUNCTION-BASICS
CLASS-10-TEXT FUNCTION
TEXT FUNCTION00:51:14
RESOURCES-TEXT FUNCTION
CLASS-11-TEXT FUNCTION
TEXT FUNCTION01:06:12
RESOURCES-TEXT FUNCTION
CLASS-12-TEXT FUNCTION
TEXT FUNCTION00:59:53
RESOURCES-TEXT FUNCTION
CLASS-13-TEXT FUNCTION
TEXT FUNCTION00:00:00
RESOURCES-TEXT FUNCTION
CLASS-14-DATE FUNCTION
DATE FUNCTION00:58:31
RESOURCES-DATE FUNCTION
CLASS-15-DATE FUNCTION
DATE FUNCTION00:51:25
RESOURCES-DATE FUNCTION
CLASS-16-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:49:16
RESOURCES-STATISTICAL FUNCTION
CLASS-17-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:48:33
RESOURCES-STATISTICAL FUNCTION
CLASS-18-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:41:34
RESOURCES-STATISTICAL
CLASS-19-GOTO SPEICAL-SECURITY
GOTO SPEICAL-SECURITY01:05:43
RESOURCES-GOTO SPECIAL-SECURITY
CLASS-20-SORTING
SORTING00:58:06
RESOURCES-SORTING
CLASS-21-FILTER & ADVANCED FILTER
RESOURCES-FILTER-ADV FILTER
FILTER00:53:06
CLASS-22-SUBTOTAL-TTC
SUBTOTAL00:56:29
RESOURCES-SUBTOTAL
CLASS-23-DATA VALIDATION
DATA VALIDATION00:51:47
RESOURCES-DATA VALIDATION
CLASS-24-WHAT IF ANALYSIS
WHAT IF ANALYSIS01:01:31
RESOURCES-WHAT IF
CLASS-25-WHAT IF ANALYSIS
WHAT IF ANALYSIS00:47:43
RESOURCES-WHAT IF ANALYSIS
CLASS-26-WHAT IF ANALYSIS
WHAT IF ANALYSIS00:28:21
RESOURCES-WHAT IF ANALYSIS
CLASS-27-ARRAY
ARRAY00:43:08
RESOURCES-ARRAY
CLASS-28-SUMPRODUCT
SUMPRODUCT00:52:18
RESOURCES-SUMPRODUCT
CLASS-29-VLOOKUP
VLOOKUP01:00:16
RESOURCES-VLOOKUP
CLASS-30-VLOOKUP & HLOOKUP
HLOOKUP00:44:29
RESOURCES-HLOOKUP
CLASS-31-MATCH FUNCTION
MATCH FUNCTION00:52:58
RESOURCES-MATCH FUNCTION
CLASS-32-INDEX FUNCTION-ARRAY FORMAT
INDEX FUNCTION00:57:35
RESOURCES-INDEX ARRAY FORMAT
CLASS-33-INDEX EXAMPLES
INDEX EXAMPLES00:59:09
RESOURCES-INDEX
CLASS-34-INDEX REFRENCE & CHOOSE FUNCTION
INDEX & CHOOSE01:02:04
RESOURCES-INDEX & CHOOSE
SKILL ENHANCER MCQ TEST QUESTIONS
CLASS-35-INDIRECT
INDIRECT00:46:39
RESOURCES-INDIRECT
CLASS-36-OFFSET
OFFSET00:47:01
RESOURCES-OFFSET
CLASS-37-OFFSET
OFFSET00:38:07
RESOURCES-OFFSET
CLASS-38-PIVOT TABLE-1
PIVOT TABLE-100:50:38
RESOURCES-PIVOT TABLE-1
EXTRAZ-MATH FUNCTION
RESOURCES-MATH FUNCTION
EXTRAZ-MATH00:22:43
CLASS-39-PIVOT TABLE-2
PIVOT TABLE-200:50:43
RESOURCES-PIVOT2
CLASS-40-PIVOT TABLE-3
PIVOT TABLE-300:42:31
RESOURCES-PIVOT TABLE
CLASS-41-PIVOT TABLE-4
PIVOT TABLE00:49:38
RESOURCES-PIVOT TABLE-5
CLASS-42-PIVOT TABLE-5
PIVOT TABLE-500:34:37
RESOURCES-PIVOT
CLASS-43-CHART
CHART00:00:00
RESOURCES-CHART
CLASS-44-CHART
CHART00:35:32
RESOURCES-CHART
CLASS-45-DASHBOARD
DASHBOARD00:00:00
RESOURCES-DASHBOARD
CLASS-46-DASHBOARD
DASHBOARD00:00:00
RESOURCES-MINI DASHBOARD
CLASS-47-DASHBOARD & ADV. CONDITIONAL FORMATTING
DASHBOARD00:00:00
RESOURCES-MINI DB
Resources-advanced conditional formatting
CLASS-48-SALES MINI DASHBOARD
SALES DASHBOARD00:35:04
RESOURCES-SALES DASHBOARD
CLASS-49-KPI DASHBOARD
KPI DASHBOARD00:55:17
RESOURCES-KPI
CLASS-50-OFFICE 365
OFFICE 36500:41:23
RESOURCES-OFFICE 365
CLASS-51-OFFICE 365
OFFICE 36500:45:31
RESOURCES-OFFICE 365