LECTURE:1 – EXCEL INTRODUCTION & PASTE SPECIAL
Introduction – Customizing Paste Special00:35:37
Resources – Introduction Customizing Paste Special
Skil Enhancer level 1
LECTURE:2 – CELL REFERENCE
Cell Reference00:30:00
Resources – Cell Reference
Cell Reference questions.
LECTURE:3 – CUSTOM AND CONDITIONAL FORMATTING
Custom And Conditional Formatting00:50:05
Resources – Custom Conditional Formatting
Formatting- Custom/ Readymade/ Conditional
LECTURE:4 – LOGICAL FUNCTION – 1
Logical Function – 11:02:06
Resources – Logical Function – 1
SKILL ENHANCER-3
LECTURE:5 – LOGICAL FUNCTION – 2
Logical Function – 200:28:39
Resources – Logical Function – 2
SKILL ENHANCER-3
LECTURE:6 – MATH FUNCTION – 1
Math Function – 100:31:13
Resources – Math Function – 1
LECTURE:7 – MATH FUNCTION – 2
Math Function – 200:19:43
Resources – Math Function – 2
LECTURE:8 – TEXT FUNCTION – 1
Text Function – 100:50:08
Resource – Text Function – 1
LECTURE:9 – TEXT FUNCTION – 2
Text Function – 200:33:46
Resources – Text Function – 2
LECTURE:10 – TEXT FUNCTION – 3
Text Function – 300:22:09
Resources – Text Function – 3
LECTURE:11 – DATE AND TIME FUNCTION – 1
Date And Time Function – 100:36:29
Resources – Date and Time Function – 1
LECTURE:12 – DATE AND TIME FUNCTION – 2
Date And Time Function – 200:31:12
Resources – Date And Time Function – 2
LECTURE:13 – DATE AND TIME FUNCTION – 3
Date And Time Function – 300:13:44
Resources – Date And Time Function – 3
LECTURE:14 – STATISTICAL FUNCTION – 1
Statistical Function – 100:26:02
Resources – Statistical Function – 1
LECTURE:15 – STATISTICAL FUNCTION – 2
Statistical Function – 200:30:12
Resources – Statistical Function – 2
LECTURE:16 – STATISTICAL FUNCTION – 3
Statistical Function – 300:21:01
Resources – Statistical Function – 3
LECTURE:17 – DATABASE FUNCTION
Database Function00:24:28
Resources – Database Function
LECTURE:18 – INFORMATION FUNCTION
Information Function00:32:31
Resources – Information Function
LECTURE:19 – ERROR WORLD
Error World00:19:37
Resources – Error World
LECTURE:20 – Goto Special Security
Goto Special Security00:27:11
Resources – Goto Special Security
LECTURE:21 – PRINTING NAMING RANGE
Printing Naming Range00:24:28
Resources – Printing Naming Range
LECTURE:22 – SORTING
Sorting00:29:34
Resources – Sorting
LECTURE:23 – FILTER
Filter00:29:23
Resources – Filter
LECTURE:24 – ADVANCED FILTER
Advanced Filter00:34:10
Resources – Advanced Filter
LECTURE:25 – SUBTOTAL
Subtotal00:22:45
Resources – Subtotal
LECTURE:26 – TEXT TO COLUMN FLASH FILL
Text To Column Flash Fill00:25:21
Resources – Text To Column Flash Fill
LECTURE:27 – DATA VALIDATION – 1
Data Validation – 100:20:47
Resources – Data Validation – 1
LECTURE:28 – DATA VALIDATION – 2
Data Validation – 200:19:48
Resources – Data Validation – 2
LECTURE:29 – WHAT IF ANALYSIS – 1
What If Analysis – 100:25:29
Resources – What If Analysis – 1
LECTURE:30 – WHAT IF ANALYSIS – 2
What If Analysis – 200:30:14
Resources – What If Analysis – 2
LECTURE:31 – SCENARIO DATA CONSOLIDATION DATA TABLE
Scenario Data Consolidation Data Table00:34:29
Resources – Scenario Data Consolidation Data Table
LECTURE:32 – ARRAY FUNCTION
Array Function00:22:50
Resources – Array Function
LECTURE:33 – SUMPRODUCT FUNCTION – 1
Sumproduct Function – 100:24:49
Resources – Sumproduct Function – 1
LECTURE:34 – SUMPRODUCT FUNCTION – 2
Sumproduct Function – 200:19:59
Resources – Sumproduct Function – 2
LECTURE:35 – SUMPRODUCT FUNTION – 3
Sumproduct Function – 300:19:38
Resources – Sumproduct Function – 3
LECTURE:36 – SUMPRODUCT FUNCTION – 4
Sumproduct Function – 400:15:48
Resources – Sumproduct Function – 4
LECTURE:37 VLOOKUP
VLOOKUP00:34:57
Resources – Vlookup
LECTURE:38 VLOOKUP COLUMN COLUMNS ROW ROWS
Vlookup Column Columns Row Rows00:30:10
Resources – Vlookup Column Columns Row Rows
LECTURE:39 – DOUBLE VLOOKUP TWO LOOKUP VALUE
Double Vlookup Two Lookup Values00:21:25
Resources – Double Vlookup Two Lookup Values
LECTURE:40 – HLOOKUP
HLOOKUP00:23:46
Resources – Hlookup
LECTURE:41 – LOOKUP FUNCTION
Lookup Function00:22:08
Resources – Lookup Function
LECTURE:42 – MATCH FUNCTION
Match Function00:27:01
Resources – Match Function
LECTURE:43 – INDEX ARRAY FORMAT
Index Array Format00:32:13
Resources – Index Array Format
LECTURE:44 – INDEX REFERENCE FORMAT
Index Reference Format00:20:40
Resources – Index Reference Format
LECTURE:45 – INDEX EXAMPLES
Index Examples00:19:19
Resources – Index Examples
LECTURE:46 – IMAGE LOOKUP OTHERS
Image Lookup Others00:19:13
Resources – Image Lookup Others
LECTURE:47 – INDEX ONE TWO THREE WAY LOOKUP
Index One Two Three Way Lookup00:21:31
Resources – Index One Two Three Way Lookup
LECTURE:48 – CHOOSE FUNCTION – 1
Choose Function – 100:29:42
Resources – Choose Function – 1
LECTURE:49 – CHOOSE FUNCTION – 2
Choose Function – 200:21:27
Resources – Choose Function – 2
LECTURE:50 – INDIRECT FUNCTION – 1
Indirect Function – 100:25:35
Resources – Indirect Function – 1
LECTURE:51 – INDIRECT FUNCTION – 2
Indirect Functions – 200:19:11
Resources – Indirect Function – 2
LECTURE:52 – INDIRECT FUNCTION – 3
Indirect Functions – 300:16:58
Resources – Indirect Function – 3
Resources-Indirect-36 Table ex
LECTURE:53 – ADDRESS FUNCTION
Address Function00:21:49
Resources – Address Function
LECTURE:54 – OFFSET FUNCTION – 1
Offset Function – 100:30:21
Resources – Offset Function – 1
LECTURE:55 – OFFSET FUNTION – 2
Offset Function – 200:24:28
Resources – Offset Function – 2
LECTURE:56 – OFFSET FUNCTION – 3
Offset Function – 300:22:59
Resources – Offset Function – 3
LECTURE:57 – MASTERING VLOOKUP
Mastering Vlookup00:28:39
Resources Mastering Vlookup
LECTURE:58 – PIVOT TABLE – 1
Pivot Table – 100:28:07
Resources – Pivot Table – 1
LECTURE:59 – PIVOT TABLE – 2
Pivot Table – 200:24:50
Resources – Pivot Table – 2
LECTURE:60 – PIVOT TABLE – 3
Pivot Table – 300:17:56
Resources – Pivot Table – 3
LECTURE:61 – PIVOT TABLE – 4
Pivot Table – 400:27:35
Resources – Pivot Table – 4
LECTURE:62 – PIVOT TABLE – 5
Pivot Table – 500:19:43
Resources – Pivot Table – 5
LECTURE:63 – PIVOT TABLE – 6
Pivot Table – 600:29:36
Resources – Pivot Table – 6
LECTURE:64 – PIVOT TABLE – 7
Pivot Table – 700:29:17
Resource – Pivot Table – 7
LECTURE:65 – EXCEL CHART – 1
Excel Chart – 100:37:25
Resources – Excel Chart – 1
LECTURE:66 – EXCEL CHART – 2
Excel Chart – 200:23:21
Resources – Excel Chart – 2
LECTURE:67 – DASHBOARD – 1
Dashboard – 100:24:14
Resources – Dashboard – 1
LECTURE:68 – DASHBOARD – 2
Dashboard – 200:26:14
Resources – Dashboard – 2
LECTURE:69 – DASHBOARD – 3
Dashboard – 300:21:48
Resources – Dashboard – 3
LECTURE:70 – DASHBOARD – 4
Dashboard – 400:26:15
Resources – Dashboard – 4
LECTURE:71 – DASHBOARD – 5
Dashboard – 500:32:25
Resources – Dashboard – 5
LECTURE:72 – OFFICE 365 – 1
Office 365 – 100:27:59
Resources – Office 365 – 1
LECTURE:73 – OFFICE 365 – 2
Office 365 – 200:13:51
Resource – Office 365 – 2
LECTURE:74 – OFFICE 365 – 3
Office 365 – 300:20:20
Resources – Office 365 – 3
LECTURE:75 – POWER QUERY – 1
INTRODUCTION POWER QUERY00:00:00
RESOURCES-POWER QUERY
LECTURE:76 – POWER QUERY – 2
POWER QUERY-200:00:00
Resources-Power Query-2
LECTURE:77 – POWER QUERY – 3
POWER QUERY-300:00:00
RESOURCES-POWER QUERY-3
LECTURE:78 – POWER QUERY – 4
POWER QUERY – 400:00:00
Resources-Power Query – 4
CLASS:79 – POWER QUERY – 5
POWER QUERY-500:00:00
Merge Query
CLASS:80-POWER QUERY-6
POWER QUERY-600:00:00
Append Query
