CLASS-1-WHY MIS & EXCEL INTRO
Live Class-Why MIS ? Excel Introduction01:18:26
Resources-Excel Introduction ,Paste Special & Shortcut
Introduction-Main Edited Video35:37
CLASS-2-PASTE SPECIAL
PASTE SPECIAL01:12:24
Resources-Paste Special
CLASS-3-CELL OR FORMULA REFERENCE
CELL REFERENCE01:11:06
Resources-Cell References
Cell Reference-Main Edited Video30:49
CLASS-4-CUSTOM & READYMADE CF
Custom & Readymade CF01:09:05
Resources-Custom & Readymade CF
Custom & CF-Main Edited Video50:05
CLASS-5-CUSTOMIZED CF
Customized CF01:24:01
Resources-Conditional Formatting
CLASS-6-FORMULA VS FUNCTION
Formula vs Function1:19:50
Resources-Formula vs Function
CLASS-7-LOGICAL FUNCTION-IF
LOGICAL FUNCTION-IF-Part-100:14:31
LOGICAL FUNCTION-IF-Part-201:02:39
Resources-If Function
CLASS-8-LOGICAL FUNCTION-OR & AND
LOGICAL-OR & AND01:10:19
Resources-Logical-OR & AND
Logical-Main Edited Video1:02:06
CLASS-9-LOGICAL FUNCTION-NOT,IFERROR,SWITCH
Logica Function-XOR,IFERROR00:50:41
Resources-Logical-xor,iferror
Logical-Main Edited Video28:39
CLASS-10-MATH FUNCTION-SUMIF & SUMIFS
MATH FUNCTION-SUMIF & SUMIFS00:59:37
Resources-Math-sumifs
Math-Main Edited31:13
CLASS-11-MATH FUNCTION-SUMIFS
SUMIFS MORE51:51
Resources-Sumifs More
CLASS-12-MATH FUNCTIONS
MATH FUNCTIONS-EDITED00:51:30
Math Function51:30
Resources-Math Function
CLASS-13-BASIC TEXT FUNCTION-1
BASIC TEXT FUNCTION-101:03:15
Resources-Basic Text-1
Basic Text-Main50:08
CLASS-14-BASIC TEXT FUNCTION-2
Basic Text Function01:07:55
Resources-Basic Text-2
CLASS-15-ADV TEXT FUNCTION-3
Adv Text Function-201:02:44
Resources-Basic Text-2
CLASS-16-ADV TEXT FUNCTION-4
Adv Text Function-21:02:35
Resources-Adv Text
Adv Text-EDITED22:09
CLASS-17-ADV TEXT FUNCTION-5
Adv Text-51:05:26
Resources-Adv Text-5
CLASS-19-DATE FUNCTION-1
DATE FUNCTION-11:45:39
Date Function-Main36:29
Resources-Date Function-1
CLASS-20-DATE FUNCTION-2
Date Function-201:00:34
Resources-Date Function-2
Date Function-2-Main31:12
CLASS-21-DATE FUNCTION-3
Date Function-301:03:42
Resources-date Function-3
Date Function-3-Main13:44
CLASS-22-STATISTICAL FUNCTION-1
STATISTICAL FUNCTION-100:58:44
STATISTICAL-1-MAIN26:02
Resources-Statistical-1
CLASS-23-STATISTICAL FUNCTION-2
Statistical Function-21:00:03
Resources-Text Function-2
Statistical Function-2-Main30:12
CLASS-24-STATISTICAL FUNCTION-3
Statistical function-300:48:22
Resources-Basic Text-3
CLASS-25-STATISTICAL FUNCTION-4
Statisticcal Function-400:56:52
Resources Statistical Function-4
CLASS-26-DATABASE & INFROMATION FUNCTION
DATABASE & INFORMATION00:57:48
Resources-Database & Information
CLASS-27-GOTO SPECIAL & ERROR WORLD
Goto Special & Error World00:52:38
Resources-Goto Special & Error
CLASS-28-PRINTING.NAMING RANGE – SECURITY
Resources-Printing-Naming Range & Security00:00:00
Printing-Naming Range-Security1:37:43
Printing-Naming Range-Main Edited24:28
CLASS-29-SORTING
SORTING01:07:47
Resources-Sorting
Sorting Edited-Main29:34
CLASS-30-AUTO FILTER
AUTO FILTER1:05:29
Resources-Auto Filter
Auto Filter-Main Edited29:23
CLASS-31-ADVANCED FILTER
ADVANCED FILTER01:05:32
Resources-Advanced Filter
Adv Filter-Main Edited34:10
CLASS-32-SUBTOTAL
Subtotal Part-1 Live00:25:20
Subtotal-2-Live00:22:08
Subtotal-Main Edited22:45
Resources-Subtotal
CLASS-33-TTC & FLASH FILL
TTC & FLASH FILL00:57:22
TTC & FLASH FILL-MAIN EDITED25:21
CLASS-34-DATA VALIDATION-1
DATA VALIDATION-101:00:05
Data Validation-Main Edited20:47
Resources-Data validation-1
CLASS-35-DATA VALIDATION-2
DATA VALIDATION-200:49:31
Resources-Data Validation
CLASS-36-WHAT IF ANALYSIS-1
EXTERNAL DATA-HYPERLINK01:02:60
What if-Edited Video25:29
Resources-What if-1
CLASS-37-WHAT IF ANALYSIS-2
CONSOLIDATION-GOAL SEEK-SOLVER01:10:48
Resources-What if-2
CLASS-38-INTERVIEW PREPARATION
CLASS-39-WHAT IF ANALYSIS-3
WHAT IF -301:17:03
Resources-What if-3
CLASS-40-ARRAY FUNCTION
ARRAY FUNCTION01:05:10
Resources-Array Function
ARRAY FUNCTION-EDITED22:50
CLASS-41-SUMPRODUCT
SUMPRODUCT-101:08:07
Resources-Sumproduct
Sumproduct-1-edited24:49
CLASS-42-SUMPRODUCT
SUMPRODUCT-200:48:48
Resources-Sumproduct-2
sumproduct-2-edited19:59
Sumproduct-3-edited19:38
Sumproduct-4-edited15:48
CLASS-43-VLOOKUP-1
VLOOKUP-101:01:05
Resources-VLOOKUP-1
VLOOKUP MAIN-EDITED34:57
CLASS-44-CLOUMNS & DOUBLE VLOOKUP
COLUMNS & DOUBLE VLOOKUP01:11:32
Resources-Double Vlookup
COLUMN COLUMNS-Main Edited30:10
DOUBLE VLOOKUP-EDITED21:25
CLASS-45-COLUMNS & ROWS & HLOOKUP
COLUMNS & ROWS01:09:34
RESOURCES COLUMN COLUMNS
CLASS-46-MATCH RECAP
MATCH RECAP00:38:47
HLOOKUP FUNCTION-MAIN EDITED23:46
MATCH FUNCTION-EDITED27:01
RESOURCES MATCH FUNCTION
RESOURCES-HLOOKUP
CLASS-47-INDEX MATCH-1
INDEX MATCH-100:54:45
Resources-Index-1
CLASS-48-INDEX MATCH-2
INDEX MATCH-200:46:27
RESOURCES-INDEX MATCH-2
CLASS-49-INDEX MATCH-3
INDEX MATCH-300:44:09
RESOURCES-INDEX MATCH-3
CLASS-50-CHOOSE FUNCTION
CHOOSE FUNCTION01:07:06
Resources-Choose Function
CLASS-51-INDIRECT FUNCTION
INDIRECT FUNTION00:49:44
Resources-Indirect Function
CLASS-52-INDIRECT FUNCTION
INDIRECT-2-EDITED19:11
INDIRTECT-3-EDITED16:58
ADDRESS FUNCTION-EDITED21:49
Resources-Indirect & Address Function
CLASS-53-OFFSET FUNCTION
OFFSET FUNCTION-100:47:49
RESOURCES-OFFSET-1
RESOURCES-OFFSET-2
CLASS-54-OFFSET MORE
OFFSET-200:47:31
Draft Lesson
CLASS-55-LOOKUP REVISION-1
Lookup Revision-100:39:53
Resources-Lookup Revision
CLASS-56-MASTERING VLOOKUP RECAP
MASTERING VLOOKUP RECAP01:00:25
Resources-Mastering Vlookup
CLASS-57-PIVOT TABLE-1
PIVOT TABLE-101:21:50
Resources-Pivot Table-1
CLASS-59-PIVOT TABLE-3
PIVOT TABLE-300:53:47
Resources-Pivot Table-3
CLASS-60-PIVOT TABLE-4
PIVOT TABLE-400:52:19
RESOURCES-ADV PIVOT
CLASS-61-PIVOT TABLE-5
PIVOT TABLE-500:47:19
Resources-Pivot Table
Resources-Pivot
CLASS-62-PIVOT TABLE-6
RESOURCES PIVOT TABLE-600:00:00
PIVOT TABLE-600:59:36
CLASS-63-PIVOT TABLE-7
PIVOT TABLE-700:42:08
Resources-Pivot Table-7
CLASS-64-EXCEL CHART-1
EXCEL CHART-100:59:14
RESOURCES-EXCEL CHART-1
CLASS-65-EXCEL CHART-2
EXCEL CHART-2 (DYNAMIC CHART)01:00:20
RESOURCES-CHART
CLASS-66-DASHBOARD
DASHBOARD00:56:12
RESOURCES-DASHBOARD
CLASS-67-DASHBOARD-2
DASHBOARD-201:03:17
RESOURCES-DASHBOARD-2
CLASS-68-DASHBOARD-3
DASHBOARD-301:14:21
RESOURCES-DASHBOARD-3
CLASS-69-DASHBOARD-4 (KPI)
KPI DASHBOARD01:09:04
RESOURCES-DASHBOARD-4
CLASS-70-OFFICE 365
OFFICE 36500:54:39
RESOURCES-OFFICE 365
CLASS-71-OFFICE 365
OFFICE 36500:38:01
RESOURCES ALL-OFFICE 365
CAREER PATH COUNSELLING BY JHA SIR
COUNSELLING SESSION00:54:20
