1 – Excel Introduction00:13:55
2 – Basic Formula in Excel00:20:14
3 – If Formula in Excel00:18:13
4 – If and If or Formula00:09:02
5 – Nested IF Formula in Excel00:10:30
6 – Nested if Calculate Discount00:14:51
7 – Salary Sheet Basic Formula00:13:08
8 – Salary Sheet Nested if00:15:32
9 – Attendance Sheet00:14:03
10 – Attendacne Sheet Countif Formula00:12:06
11 – Sort, Custom Sort & Filter00:17:41
12 – Conditional Formatting Basic00:13:23
13- Conditional Formatting Advance00:10:17
14- C F Higlight Alt Rows00:08:38
15 – Advance Filter00:12:26
16 – Advance filter Macro00:13:59
17 – Auto Sort Macro00:07:38
18 – Text to Columns00:04:58
19 – Flash Fill in Excel00:13:29
20 – Remove Duplicate and Consolidate00:08:39
21 – 3D Formula00:07:15
22 – Data Validation00:28:16
23 – Scenario Manager00:06:21
24- Goal Seek00:08:50
25 – Data Table00:05:30
26 – Home Tab 100:12:23
27 – Home Tab 200:11:09
28 – Home Tab 300:06:32
29 – Home Tab 400:09:52
30 – Find and Replace00:12:40
31 – Goto Special00:12:13
32 – Paste Special00:17:32
33 – Pivot Table Introduction00:13:27
34 – Pivot Table Filter Use00:08:23
35 – Pivot Table Options00:11:42
36 – Slicer and Timeline00:15:09
37 – Pivot Chart in Excel00:10:56
38 – Auto Refresh Pivot Table00:06:21
39 – Table in Excel00:10:56
40 – Insert Tab – 100:08:48
41 – Insert Tab200:08:06
42 – Excel Chart00:12:21
43 – Excel Chart and Formatting00:08:15
44 – Excel Sparkline Chart00:05:29
45 – Hyperlink in Excel00:04:31
46 – Insert Tab 300:11:58
47 – Watermark in Excel00:05:39
48 – Pagelayout Tab Themes and Margins00:11:12
49 – Pagelayout Tab Print Settings00:11:13
50 – Pagelayout Tab 200:07:02
51 – Pagelayout Tab300:11:39
52 – Formula Tab Name Manager00:11:28
53 – Formula Tab Formula Auditing00:09:01
54 – Data Tab Get External Data00:08:09
55 – Data Tab SubTotal00:07:22
56 – Data Tab Solver add ins00:06:29
57 – Reveiw Tab00:09:38
58 – View Tab00:10:34
59 – Macro Recording00:12:13
60 – Create your own Tab00:05:56
61 – Vlookup 1 Intro00:16:37
62 – Vlookup 2 Use of Range Lookup00:13:02
63 – Vlookup 3 Double Vlookup00:08:28
64 – Vlookup 4 Nested Vlookup00:07:46
65 – Vlookup 5 Vlookup Project00:09:24
66 – Vlookup 6- Unique Example of Vlookup00:05:38
67 – CountA and Count Blank Formula00:07:10
68 – Countif Formula00:05:59
69 – Countifs Formula00:11:33
70 – Sumif and Sumifs00:07:21
71 – Averageif and Averageifs00:06:56
72 – Frequency Formula00:07:25
73 – Index and Match00:07:10
74 – Lookup Formula00:05:06
75 – SumProduct , Left and Find formula00:07:13
76 – Right and Find00:05:01
77 – Mid and Find Formula00:09:56
78 – Repeat and Substitute Formula00:04:26
79 – PMT, PV, FV Formula00:10:50
80 – IPMT AND PPMT00:08:34
81- V lookup with Match00:10:19
82 – Text Formulas00:06:45
83 – Date in Quarter00:06:19
84 – Datedif Formula00:06:44
85 – Date Formula00:05:13
86 – Switch Date00:06:32
87 – More Date Formulas00:07:23
88 – Ranking Formula00:05:20
89 – Concatenate and Vlookup00:04:04
90 – Sheet Tips00:06:32
91 – Excel To Powerpoint00:06:14
92 – Change Excel Icon00:06:25
93 – Number to Word00:06:14
94 – Custom Cells Tips00:08:00
95 – Picture Lookup 00:11:27
96 – Picture Game00:08:21
97 – Data Entry form00:04:22
98 – File Menu00:06:05
99 – Excel Settings00:10:59
100 – Short formulas00:11:06
101 – Excel – Database function DGET Formula of Excel00:10:36
102 – Excel – DSUM Formula in Excel00:07:24
103 – Excel – DAVERAGE Formula00:02:41
104 – Excel – DCOUNT, DCOUNTA Formula00:04:11
105 – Excel -DMAX Formula, DMIN Formula, DPRODUCT Formula00:06:10
106 – Excel – Vlookup on Multiple Tables00:06:54
107 – Excel – Offset Formula Introduction00:11:01
108 – Excel – Offset Formula Calculate Sum of Last 6 Days00:09:37
109 – Excel – Offset Formula Real Job Use00:05:21
110 – Excel – Sumifs, Index, Match Real Job Use00:08:24
111 – Excel – Practical use of Isblank and Istext Formula00:04:35
112 – Excel – Counting Words in Excel Interview Question00:08:54
113 – Excel – Build Login in Excel Formula00:05:55
114 – Excel – Create Dynamic List Using Index, Match Formula00:04:08
115 – Excel – Conditional Formatting with Text and Or Formula00:04:33
116 – Excel – Unique Example of Conditional Formatting00:05:53
117 – Excel – Auto Sort data using Countif, Match and Index Formula00:09:02
118 – Excel – Condition Inside Rank using CountIFS Formula00:05:40
119 – Excel – Camera, Autofilter, Form – 3 Hidden Features00:06:55
120 – Excel – Max IF and Min IF Formula using Array00:05:39
121 – Excel – Choose Formula in Excel00:07:15
122 – Excel – Swap range in Excel00:04:19
123 -Excel- Reverse Lookup Using Choose Formula00:05:37
124 – Excel – Reverse Lookup using Match and Index00:06:40
125 – Excel – Find & Vlookup Real Job Query00:09:41
126 – Excel – Vlookup Duplicate Names Issue00:04:09
127 – Excel – Vlookup with Chooze formula and array00:09:10
128 – Excel – Text Join Formula in Excel 201900:05:02
129 – Excel – IFS Formula in Excel 201900:04:47
130 – Excel – MaxIFS and MinIFS in Excel 201900:04:37
131 – Excel – Filter Formula of Office 36500:05:19
132 – Excel – Sort Formula of Office 36500:06:056
133 – Excel – Real Job use of Aggregate Formula in Excel00:10:34
134 – Excel – Xlookup In Office 365 – 1-100:06:36
135 – Excel – Xlookup In Office 365 – 2-100:06:42
136 – Excel – Xlooup Work Reverse00:09:47
137 – Excel – Xlooup In Office 36500:05:29
138 – Excel – Xlooup In Office 36500:09:56
139 – Excel – Xlookup in Office 36500:08:39
140 – Excel – Xlookup in Office 36500:06:18
141 – Excel – Xlookup in Office 36500:05:06
142 – Excel – Xlookup in Office 36500:05:35
143 – Excel – Xlookup in Office 36500:05:20
144 – EXCEL – XMATCH Formula office 36500:13:08
145 – Excel – Create Searchable Drop Down List In Office 36500:9:44
146 – Excel – Analyze Data And Get Ideas Office 36500:06:31
147 – Excel – Map Chart In Office 36500:08:05
148 – Excel – Dynamic Conditional Formatting00:09:53
149 – Excel – Unique Formula In Office 36500:05:19
150 – Excel – Sequence And Random Array Formula In Office 36500:04:35
151 – EXCEL – Assignment 1 With Answer 36500:13:17
152 – EXCEL – Assignment 2 With Answer 36500:06:40
153 – EXCEL – Assignment 3 With Answer 36500:04:37
154 – EXCEL – Assignment 4 With Answer 36500:03:14