CLASS-1-CAREER GUIDE & EXCEL INTRODUCTION
CAREER GUIDE & EXCEL INTRODUCTION1:31:25
RESOURCES-EXCEL INTRODUCTION
CLASS-2-PASTE SPECIAL
PASTE SPECIAL1:10:54
RESOURCES-PASTE SPECIAL
CLASS-3-FORMULA REFERENCE
FORMULA REFERENCE1:13:11
RESOURCES-FORMULA REFERENCE
CLASS-4-CUSTOM FORMATTING
CUSTOM FORMATTING1:03:32
Resources-Custom Formating
CLASS-5-CONDITIONAL FORMATTING
CONDITIONAL FORMATTING1:09:27
RESOURCES-CONDITIONAL FORMATTING00:00:00
CLASS-6-CONDITIONAL FORMATTING
CONDITIONAL FORMATTING1:03:24
RESOURCES-CONDITIONAL FORMATTING
CLASS-7-FORMULA VS FUNCTION
FORMULA VS FUNCTION46:18
Resources-Formula vs Function
CLASS-8-LOGICAL FUNCTION-IF
LOGICAL FUNCTION-IF1:03:00
RESOURCES-LOGICAL-1
CLASS-9-LOGICAL FUNCTION-NESTED IF AND OR
NESTED IF AND OR1:09:33
Resources-Logical-if-and or
CLASS-10-LOGICAL FUNCTION-MORE
LOGICAL FUNCTION MORE48:29
LOGICAL FUNCTION MORE00:00:00
CLASS-11-MATH FUNCTION
MATH FUNCTION-7PMWD59:23
RESOURCES-MATH FUNCTION-SUMIFS
CLASS-12-MATH FUNCTION
MATH FUNCTION1:01:25
RESOURCES-MATH FUNCTION
CLASS-13-TEXT FUNCTION
TEXT FUNCTION1:01:15
RESOURCES-TEXT-1
CLASS-14-TEXT FUNCTION
TEXT FUNCTION1:02:11
RESOURCES-TEXT FUNCTION
CLASS-15-TEXT FUNCTION
TEXT FUNCTION1:12:43
Resources-Text Function
CLASS-16-TEXT FUNCTION
TEXT FUNCTION1:09:37
Resources-Text Function
CLASS-17-TEXT FUNCTION
TEXT FUNCTION ADV1:01:52
Resources-Text Adv
CLASS-18-DATE FUNCTION
DATE FUNCTION50:40
Resources-Date Function-1
CLASS-19-DATE FUNCTION
DATE FUNCTION-257:50
Resources-Date Function-2
CLASS-20-DATE FUNCTION
DATE-31:06:57
RESOURCES-DATE
CLASS-22-DATE RECAP & ASSIGNMENT
DATE RECAP1:03:13
RESOURCES-RECAP
CLASS-23-STATISTICAL FUNCTION
STATISTICAL FUNCTION-11:07:34
RESOURCES – STATISTICAL FUNCTION-1
CLASS-24-STATISTICAL FUNCTION
COUNTIF EXAMPLES1:01:22
RESOURCES-COUNTIF
CLASS-25-STATISTICAL FUNCTION
STATISTICAL FUNCTION56:46
RESOURCES-STATISTICAL FUNCTION
CLASS-26-STATISTICAL FUNCTION
STATISTICAL FUNCTION1:01:58
RESOURCES-STATISTICAL
CLASS-27-DATABASE & INFORMATION FUNCTION
DATABASE & INFORMATION58:37
Resources-Database & information
CLASS-29-GO TO SPECIAL-FORMULA AUDITING
ERROR-GOTO SPECIAL59:20
RESOURCES-ERROR-GOTO SPECIAL
CLASS-30-SECURITY & NAMING RANGE
SECURITY & NAMING RANGE58:18
RESOURCES-SECURITY & NAMING RANGE
CLASS-31-SORTING
SORTING54:43
RESOURCES-SORTING
CLASS-32-FILTER & ADVANCED FILTER
ADVANCED FILTER52:33
Resource-Auto & Adv. Filter
CLASS-33-SUBTOTAL
SUBTOTAL45:31
RESOURCES-SUBTOTAL
CLASS-34-TEXT TO COLUMN-FLASH FILL
TTC & FLASH FILL57:08
Resources=TTC & Flash Fill
CLASS-35-DATA VALIDATION
DATA VALIDATION46:40
RESOURCES-DATA VALIDATION
CLASS-36-DATA VALIDATION
DATA VALIDATION44:24
RESOURCES-DATA VALIDATION
CLASS-37-GOAL SEEK & SOLVER TOOL
GOAL SEEK & SOLVER TOOL49:28
RESOURCES-GOAL SEEK & SOLVER
CLASS-38-CONSOLIDATION & DATA TABLE
CONSOLIDATION & DATA TABLE00:49:49
RESOURCES-CONSOLIDATION & DATA TABLE
CLASS-39-WORKING WITH EXTERNAL DATA
WORKING WITTH EXTERNAL DATA
RESOURCES-EXTERNAL DATA
CLASS-40-HYPERLINK & ARRAY
HYPERLINK & ARRAY55:54
RESOURCES-ARRAY
CLASS-41-SUMPRODUCT
SUMPRODUCT-147:43
RESOURCES-SUMPRODUCT
CLASS-42-SUMPRODUCT
SUMPRODUCT ADVANCED53:40
RESOURCES-SUMPRODUCT ADVANCED
CLASS-43-VLOOKUP -1
VLOOKUP-1
RESOURCES-VLOOKUP-1
CLASS-44-COLUMNS-ROWS-HLOOKUP
COLUMNS-ROWS-HLOOKUP
RESOURCES-COLUMNS-ROWS-HLOOKUP
CLASS-45-DOUBLE VLOOKUP
DOUBLE VLOOKUP1:01:29
RESOURCES-DOUBLE VLOOKUP
CLASS-46-LOOKUP FUNCTION
LOOKUP FUNCTION59:57
RESOURCES-LOOKUP FUNCTION
CLASS-47-MATCH FUNCTION
MATCH FUNCTION53:45
RESOURCES-MATCH FUNCTION
CLASS-48-INDEX ARRAY FORMAT
INDEX MATCH1:02:32
RESOURCES-INDEX FUNCTION
CLASS-49-INDEX FUNCTION EXAMPLES
INDEX EXAMPLES50:05
INDEX EXAMPLES
CLASS-50-INDEX REFRENCE FORMAT
INDEX REFERENCE FORMAT48:37
INDEX REFERENCE FORMAT
CLASS-51-ONE-TWO-THREE WAY INDEX
ONE-TWO-THREE WAY1:02:11
RESOURCES-INDEX LOOKUP
CLASS-51-CHOOSE FUNCTION
CHOOSE FUNCTION55:48
RESOURCES-CHOOSE FUNCTION
CLASS-52-INDIRECT FUNCTION
INDIRECT FUNCTION1:02:09
RESOURCES-INDIRECT FUNCTION
CLASS-53-OFFSET FUNCTION
OFFSET FUNCTION27:57
RESOURCES-OFFSET FUNCTION
CLASS-54-OFFSET FUNCTION
OFFSET FUNCTION54:50
RESOURCES-OFFSET FUNCTION
CLASS-55-OFFSET & 2D-3D-LOOKUP RECAP
OFFSET & LOOKUP RECAP49:23
RESOURCES-OFFSET FUNCTION
CLASS-56-MASTERING VLOOKUP RECAP
VLOOKUP RECAP55:01
MASTERING VLOOKUP
CLASS-57-PIVOT TABLE-1
PIVOT TABLE-147:53
RESOURCES-PIVOT-1
CLASS-58-PIVOT TABLE-2
PIVOT TABLE-254:02
RESOURCES-PIVOT TABLE-2
CLASS-59-PIVOT TABLE-3
PIVOT TABLE-348:57
RESOURCES-PIVOT TABLE-3
CLASS-60-PIVOT TABLE-SHOW VALUE AS
SHOW VALUE AS47:59
RESOURCES-PIVOT4
CLASS-61-PIVOT TABLE
PIVOT TABLE-552:10
RESOURCES-PIVOT TABLE-5
CLASS-62-PIVOT TABLE
PIVOT TABLE-650:37
RESOURCES-PIVOT TABLE-6
CLASS-63-PIVOT TABLE RELATIONSHIP
PIVOT TABLE-744:12
RESOURCES-PIVOT TABLE-7
CLASS-64-EXCEL CHART
EXCEL CHART52:09
RESOURCES-EXCEL CHART
CLASS-65-EXCEL CHART
EXCEL CHART49:57
RESOURCES-EXCEL CHART
CLASS-66-DASHBOARD
DASHBOARD-139:44
RESOURCES-DASHBOARD-1
CLASS-67-DASHBOARD
SPEEDOMETER & BULLET CHART29:39
RESOURCES-SPEEDOMOTER & BULLET
CLASS-68-DASHBOARD
DASHBOARD45:15
RESOURCES-DASHBOARD
CLASS-69-DASHBOARD
DASHBOARD40:20
RESOURCES-DASHBOARD
CLASS-70-DASHBOARD
DASHBOARD42:39
RESOURCES-DASHBOARD
CLASS-71-DASHBOARD
DASHBOARD30:46
KPI DASHBOARD
CLASS-72-OFFICE 365
OFFICE 365-135:16
RESOURCES-OFFICE 365-1
CLASS-73-OFFICE 365
OFFICE 36544:52
RESOURCES-OFFICE 365
CLASS-74-OFFICE 365
OFFICE 3651:02:33
RESOURCES-OFFICE 365