DEMO SESSION-CAREER GUIDE
CLASS-1-EXCEL INTRO & PASTE SPECIAL
PASTE SPECIAL01:46:13
RESOURCES-PASTE SPECIAL
CLASS-2-FORMULA REFERENCE
FORMULA HANDLING01:50:41
RESOURCE-FORMULA REFERENCE
CLASS-3-CONDITIONAL FORMTING
CONDITIONAL FORMATING01:18:12
RESOURCES-CONDITIONAL FORMATING
CLASS-4-FORMULA VS FUNCTION – LOGICAL FUNCTION
FORMULA VS FUNCTION – LOGICAL FUNCTION01:43:19
RESOURCE LOGICAL FUNCTION
CLASS-5-LOGICAL FUCTION
LOGICAL FUCTION01:53:09
RESOURCES-LOGICAL
CLASS-6-MATH & TEXT
MATH & TEXT01:08:17
RESOURCE MATH & TEXT00:00:00
CLASS-7-TEXT FUNCTION
TEXT FUNCTION01:13:17
RESOURCE TEXT FUNCTION
CLASS-9-DATE TIME FUNCTION
DATE TIME FUNCTION01:45:00
RESOURC DATE TIME FUNCTION
CLASS-10-STATISTICAL FUNCTION
STATISTICAL FUNCTION01:46:42
RESOURCE STATISTICAL FUNCTION
CLASS-11-GOTO SPECIAL
GOTO SPECIAL-SORT01:22:50
RESOURCE GOTO SPECIAL
CLASS-12-FILTER & ADVANCED FILTER
FILTER & ADVANCED FILTER01:45:17
RESOURCE FILTER & ADVANCED FILTER
CLASS-13-DATA VALIDATION
DATA VALIDATION01:00:52
RESOURCE DATA VALIDATION
CLASS-14-WHAT IF ANALYSIS
WHAT IF ANALYSIS01:33:08
RESOURCE WHAT IF ANALYSIS
CLASS-15-ARRAY & SUMPRODUCT
ARRAY & SUMPRODUCT01:41:09
RESOURCE ARRAY & SUMPRODUCT
CLASS-16-LOOKUP & REFERENCE FUNCTION
LOOKUP & REFERENCE FUNCTION00:20:23
RESOURCE LOOKUP & REFERENCE FUNCTION
CLASS-17-LOOKUP & REFERENCE FUNCTION
LOOKUP & REFERENCE FUNCTION01:41:35
RESOURCE LOOKUP & REFERENCE FUNCTION
CLASS-18-INDEX MATCH
INDEX MATCH01:45:14
RESOURCE INDEX MATCH
CLASS-19-CHOOSE-INDIRECT FUNCTION
CHOOSE FUNCTION01:27:21
RESOURCE CHOOSE FUNCTION00:00:00
CLASS-20-OFFSET FUNCTION
OFFSET01:33:29
Resources-offset
CLASS-21-PIVOT TABLE
PIVOT TABLE01:40:45
RESOURCE PIVOT TABLE
CLASS-22-SUMMARIZE VALUE AS
SUMMARIZE VALUE AS01:29:28
RESOURCE SUMMARIZE VALUE AS
CLASS-23-VLOOKUP REPLACEMENT
VLOOKUP REPLACEMENT01:21:56
RESOURCE VLOOKUP REPLACEMENT
CLASS-24-CHART
CHART01:30:43
RESOURCE CHART
CLASS-25-DASHBOARD
DASHBOARD01:13:34
RESOURCE DASHBOARD
CLASS-26-KPI & SALES DASHBOARD
KPI DASHBOARD01:24:02
RESOURCES-KPI DASHBOARD
CLASS-27-EXCEL DYNAMIC ARRAYS
EXCEL DYNAMIC ARRAYS01:20:19
RESOURCE EXCEL DYNAMIC ARRAYS
CLASS-28-OFFICE 365
OFFICE 36501:29:43
Resources-Office 365
