CLASS-1-EXCEL INTRODUCTION & PASTE SPECIAL
PASTE SPECIAL01:45:02
Resources-Paste Special
CLASS-2-FORMULA REFERENCE & CONDITIONAL FORMATING
FORMULA REFERENCE & CF01:51:46
RESOURCES-FR & CF
CLASS-3-FORMULA VS FUNCTION
FORMULA VS FUNCTION00:00:00
RESOURCES-Function
CLASS-4-LOGICAL FUNCTION
LOGICAL FUNCTION00:00:00
RESOURCES-LOGICAL
CLASS-5-SUMIFS
SUMIFS00:00:00
RESOURCES-SUMIFS
CLASS-6-TEXT
TEXT00:00:00
RESOURCES-TEXT
CLAS-7-TEXT FUNCTION
TEXT FUNCTION00:00:00
RESOURCES-TEXT ADVANCED
CLASS-8-DATE FUNCTION
DATE FUNCTION00:00:00
RESOURCES-DATE
CLASS-9-STATISTICAL FUNCTION
STATISTICAL FUNCTION00:00:00
RESOURCES-STATISTICAL
CLASS-10-INFORMATION-DATABASE SECURITY
INFORMATION-DATABASE00:00:00
RESOURCES-INFORMATION
CLASS-11-SORTING-FILTER-ADV FILTER
SORTING-FILTER00:00:00
RESOURCES-SORT-FILTER-ADV FILTER
CLASS-13-SUBTOTAL-TTC-DATA VALIDATION
SUBTOTAL-TTC-DATA VALIDATION00:00:00
RESOURCES-SUBTOTAL-TTC-DV
CLASS-14-WHAT IF ANALYSIS
WHAT IF01:54:54
RESOURCES-WHAT IF
CLASS-15-ARRAY & SUMPRODUCT
ARRAY & SUMPRODUCT00:00:00
RESOURCES-DATA VISUALIZATION
CLASS-16-VLOOKUP
VLOOKUP00:00:00
RESOURCES-VLOOKUP
CLASS-17-HLOOKUP-LOOKUP-MATCH
hlookup-lookup00:00:00
match00:35:38
Resources-hlookup-lookup-match
CLASS-18-INDEX MATCH
INDEX MATCH01:50:11
RESOURCES-INDEX MATCH
CLASS-19-CHOOSE & INDIRECT
CHOOSE & INDIRECT00:00:00
Resources-choose & indirect
CLASS-20-OFFSET & LOOKUP RECAP
OFFSET01:40:14
RESOURCES-OFFSET
RESOURCES-MASTERING VLOOKUP
CLASS-21-POWER QUERY-PIVOT TABLE
PQ-PT01:58:04
RESOURCES-PT1
CLASS-22-PIVOT TABLE
PIVOT TABLE02:01:12
RESOURCES-PIVOT TABLE
CLASS-23-PIVOT TABLE & CHART
PIVOT TABLE01:38:08
RESOURCES-PIVOT TABLE
CLASS-24-CHART
CHART00:35:31
RESOURCES-CHART
CLASS-25-CHART & DASHBOARD
CHART & DB01:26:53
RESOURCES-CHART
CLASS-26-DASHBOARD
DASHBOARD01:28:27
RESOURCES-DASHBOARD
CLASS-27-OFFICE 365
OFFICE 36501:15:11
RESOURCES-OFFICE365
CLASS-28-OFFICE 365
OFFICE 36501:20:17
RESOURCES-OFFICE 365
