Computer Fundamental
2 – CPU Hardware Parts00:09:19
3 – Desktop Icon Settings00:08:44
4 – Keyboard and Mouse Information00:11:14
5 – Software Installation00:09:47
6 – Change Computer Password00:09:17
Microsoft Word Full Course?
Word Course
2 – Home Tab Font Group00:18:29
3 – Home Tab : Advance Font, Clipboard Group00:11:17
4 – Word Paragraph group00:11:46
5 – Create Page cover in Word00:12:20
6 – Create and Design Table00:27:59
7 – Insert and Format Picture00:14:49
8 – Draw Shape, Insert Chart & Smart art00:15:35
9 – Header and Footer in Word00:11:57
10 – Insert Symbol and Object00:07:32
11 – Design Tab in Word00:10:16
12 – Page layout Tab in Word00:10:52
13 – References Tab in Word00:13:41
14 – Mailings Tab in Word00:13:42
15 – Review Tab in Word00:16:47
16 – View Tab and File Menu in Word00:11:52
17 – Option Settings in Word00:11:12
18 – Option Settings in Word 200:10:29
19 – File Option Settings 300:06:20
20 – Customize Ribbon in Word – Create your own tab00:08:10
21 – Mail merge with Excel Data in Word00:06:40
22 – Create Professional Resume in Word00:23:28
23 – Create Letter in Word Typing Exam00:04:38
24 – Word – Create Pro Visiting Card00:16:35
25 – Word -Create Pro ID Card00:12:45
26 – Word – Create Professional Certificate00:16:57
Demo Question & Answer Word Final Test
Advance Excel Full Course?
Excel Course
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
PowerPoint Full Course?
PPT Course
2 – Creating Slides in PowerPoint00:13:48
3 – Design Tab in PowerPoint00:08:39
4 – Transitions Tab in PowerPoint00:05:15
5 – Loop Slide in PowerPoint00:06:54
6 – Animation Tab in PowerPoint00:13:35
7 – Animation Pane in PowerPoint00:10:17
8 – Presenter View in PowerPoint00:04:50
9 – Slide Show Tab In PowerPoint00:03:16
10 – Create Photo album, Add Music & Videos00:17:14
11 – Excel To PPT Animation00:19:23
12 – Amazing PPT00:09:04
13 – Count down Timer in PowerPoint00:3:51
14 – Five Power Tips of PPT00:11:51
15 – Video Inside Text in PowerPoint00:07:16
PowerPoint Final Test Demo Questions with Answers
Microsoft Access Full Course?
Msaccess
2 – Creating Table in MS Access00:16:18
3 – Delete & Add Columns in Access00:07:26
4 – Create Lookup Wizard from List00:07:32
5 – Break Lookup Relationship00:06:10
6 – Calculation in Access00:08:14
7- IF Formula in Access00:08:28
8 – IF AND, IF OR in Access00:07:55
9 – Import Tables from Excel, Notepad in Access00:10:42
10 – Filter and Sort in Access00:07:59
11 – Advance Filter in Access00:08:09
12 – Records Group in Access00:09:08
13 – Find and Replace in Access00:07:03
14 – Access – Create Query using Query Wizard00:07:41
15 – Access – Design Query on Existing Query00:05:10
16 – Access – Create Parameter Query00:08:03
17 – Access – Query with Relationship00:10:19
18 – Access – Query with Calculated Field00:04:38
19 – Access – Pivot Table in Access – Cross Tab Query00:06:13
20 – Access – Find Duplicate Query00:05:44
21 – Access – Unmatched Query00:05:03
22 – Access – Export Access data00:08:08
23 – Access – Hide Table and Query from Navigation00:06:19
24 – Access – Add Totals in Query00:06:07
25 – Access – SQL View of Query00:06:54
26 – Access – Create form using Form Wizard00:09:52
27 – Access – Design Form using Design Tab00:11:22
28 – Access – Conditional Formatting in Form00:09:30
29 – Access – Customize Button in Forms00:11:37
30 – Access – Insert Charts in Form00:07:47
31 – Access – Create Reports from Report Wizard00:08:35
32 – Access – Design and Format Report00:07:37
33 – Access – Design and Conditional Formatting in Report00:09:09
34 – Access – Parameter Reports00:05:11
35 – Access – Create Print Preview Button of Report00:05:00
Demo Question & Answer Ms-Access Final Test
Microsoft Outlook Full Course?
You will learn complete outlook course, Configure Email, Create Appointment, Task and events and more