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:02
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:16
14- C F Higlight Alt Rows00:08:38
15 – Advance Filter00:12:26
16 – Advance filter Macro00:14:00
17 – Auto Sort Macro00:07:39
18 – Text to Columns00:05:00
19 – Flash Fill in Excel00:13:30
20 – Remove Duplicate and Consolidate00:08:40
21 – 3D Formula00:07:15
22 – Data Validation00:28:16
23 – Scenario Manager00:06:21
24- Goal Seek00:08:51
25 – Data Table00:05:31
26 – Home Tab 100:12:24
27 – Home Tab 200:11:10
28 – Home Tab 300:06:32
29 – Home Tab 400:09:53
30 – Find and Replace00:12:40
31 – Goto Special00:20:14
32 – Paste Special00:17:32
33 – Pivot Table Introduction00:13:28
34 – Pivot Table Filter Use00:08:23
35 – Pivot Table Options00:11:42
36 – Slicer and Timeline00:15:10
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:41
41 – Insert Tab200:08:05
42 – Excel Chart00:12:21
43 – Excel Chart and Formatting00:08:16
44 – Excel Sparkline Chart00:05:30
45 – Hyperlink in Excel00:04:32
46 – Insert Tab 300:11:58
47 – Watermark in Excel00:05:40
48 – Pagelayout Tab Themes and Margins00:11:13
49 – Pagelayout Tab Print Settings00:11:14
50 – Pagelayout Tab 200:07:03
51 – Pagelayout Tab300:11:38
52 – Formula Tab Name Manager00:11:24
53 – Formula Tab Formula Auditing00:09:02
54 – Data Tab Get External Data00:08:08
55 – Data Tab SubTotal00:07:22
56 – Data Tab Solver add ins00:06:28
57 – Reveiw Tab00:09:38
58 – View Tab00:10:34
59 – Macro Recording00:12:12
60 – Create your own Tab00:05:57
61 – Vlookup 1 Intro00:16:38
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:39
67 – CountA and Count Blank Formula00:07:10
68 – Countif Formula00:05:59
69 – Countifs Formula00:11:33
70 – Sumif and Sumifs00:07:22
71 – Averageif and Averageifs00:06:57
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:05:57
78 – Repeat and Substitute Formula00:04:25
79 – PMT, PV, FV Formula00:10:51
80 – IPMT AND PPMT00:08:34
81- V lookup with Match00:10:20
82 – Text Formulas00:06:46
83 – Date in Quarter00:06:19
84 – Datedif Formula00:06:43
85 – Date Formula00:05:13
86 – Switch Date00:06:31
87 – More Date Formulas00:07:23
88 – Ranking Formula00:05:19
89 – Concatenate and Vlookup00:04:05
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:22
97 – Data Entry form00:04:22
98 – File Menu00:06:06
99 – Excel Settings00:11:00
100 – Short formulas00:11:07
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:07
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:14
122 – Excel – Swap range in Excel00:04:18
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:09
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:36
131 – Excel – Filter Formula of Office 36500:05:20
132 – Excel – Sort Formula of Office 36500:06:56
133 – Excel – Real Job use of Aggregate Formula in Excel00:10:34
134 – Excel – Xlookup In Office 36500:06:37
135 – Excel – Xlookup In Office 36500:06:42
136 – Excel – Xlooup Work Reverse00:09:47
137 – Excel – Xlooup In Office 36500:05:40
138 – Excel – Xlooup In Office 36500:09:56
139 – Excel – Xlookup in Office 36500:08:38
140 – Excel – Xlookup in Office 36500:06:22
141 – Excel – Xlookup in Office 36500:05:06
142 – Excel – Xlookup in Office 36500:05:36
143 – Excel – Xlookup in Office 36500:05:20
144 – EXCEL – XMATCH Formula office 36500:13:07
145 – Excel – Create Searchable Drop Down List In Office 36500:09:45
146 – Excel – Analyze Data And Get Ideas Office 36500:06:31
147 – Excel – Map Chart In Office 36500:08:04
148 – Excel – Dynamic Conditional Formatting00:09:53
149 – Excel – Unique Formula In Office 36500:05:15
150 – Excel – Sequence And Random Array Formula In Office 36500:04:34
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
