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
CLASS-45-PIVOT TABLE
PIVOT TABLE00:59:07
RESOURCES-PIVOT
CLASS-46-PIVOT TABLE
PIVOT TABLE01:02:16
RESOURCES-PIVOT TABLE
CLASS-47-PIVOT TABLE
PIVOT TABLE00:52:50
RESOURCES-PIVOT
CLASS-48-PIVOT TABLE
PIVOT TABLE00:43:26
RESOURCES-PIVOT
CLASS-49-PIVOT TABLE
PIVOT TABLE-p100:24:26
pivot table-p200:31:44
Resources-Pivot
CLASS-50-PIVOT TABLE
PIVOT TABLE00:54:32
RESOURCES-PIVOT
CLASS-51-PIVOT TABLE
PIVOT TABLE00:53:55
RESOURCES-PIVOT
CLASS-53-PIVOT TABLE
PIVOT TABLE00:53:18
PIVOT ALL RESOURCES
CLASS-54-CHART
CHART00:41:45
RESOURCES-CHART
CLASS-55-CHART
CHART00:52:35
RESOURCES-CHART
CLASS-57-CHART
CHART00:39:58
RESOURCES-CHART
CLASS-58-DASHBOARD
DASHBOARD00:43:42
RESOURCES-DASHBOARD
CLASS-59-DASHBOARD
DASHBOARD00:44:11
RESOURCES-DASHBOARD
CLASS-60-MINI DASHBOARD
MINI DASHBOARD00:52:27
RESOURCES-MINI DASHBOARD
CLASS-61-SALES DASHBOARD PROTOTYPE
SALES DASHBOARD00:45:33
RESOURCES-SALES DB
CLASS-62-KPI DASHBOARD
KPI DASHBOARD00:59:12
KPI DASHBOARD
CLASS-63-OFFICE 365
OFFICE 36500:41:23
RESOURCES-OFFICE 365
CLASS-64-OFFICE 365
OFFICE 36500:47:53
RESOURCES-OFFICE 365
ASSIGNMENT MASTER-CORE EXCEL
