MS-Office Full Course – Basic To Advanced
About Course
Learn Microsoft Office Course in Advance level – In this course, we have included all the topics of Microsoft office, there is a step-by-step explanation of Microsoft word, Excel, PowerPoint, Access, Outlook with this you will learn computer fundamentals and also the Internet.
Computer Fundamental + MS-Word Full Course + Advance Excel Full Course + PowerPoint Full Course + MS-Access Full Course + Microsoft Outlook + Internet + Publisher
Combine Package in Offer Include all the courses in Advance level
- 60+Hours Video Tutorials
- Practice files of Every Course
- Course Completion Certificate
- Course Test
In this course, You will complete Microsoft Office Package
इस टुटोरिअल के अंदर एक्सेल जॉब से रिलेटेड बहोत सारे फार्मूला को एक्सप्लेन किया है और प्रक्टिकली उसका कैसे इस्तेमाल करना है वो भी बताया है |
एक्सेल की बहोत सारी टिप्स भी हमने इस टुटोरिअल में शेयर कियी है |
200+प्रैक्टिस फाइल्स + 230+ वीडियो टुटोरिअल्स + 6 Test + Course Completion Certificate
What Will You Learn?
- निचे दिए गए 225+ टॉपिक्स आप सीखोगे।
- Computer Fundamental + MS-Word Full Course + Advance Excel Full Course
- PowerPoint Full Course + MS-Access Full Course + Microsoft Outlook
- Internet + Publisher बेसिक से एडवांस
Course Content
Computer Fundamental
-
1 – Computer Parts Introduction (Watch Free)
13:38 -
2 – CPU Hardware Parts (Watch Free)
09:19 -
3 – Desktop Icon Settings
08:44 -
4 – Keyboard and Mouse Information
11:14 -
5 – Software Installation
09:47 -
6 – Change Computer Password
09:17
Microsoft Word Full Course (26 video)
Word Course
-
1 – Introduction of Word (Watch Free)
12:09 -
2 – Home Tab Font Group
18:28 -
3 – Home Tab : Advance Font, Clipboard Group
11:17 -
4 – Word Paragraph group
11:46 -
5 – Create Page cover in Word
12:20 -
6 – Create and Design Table
27:59 -
7 – Insert and Format Picture
14:49 -
8 – Draw Shape, Insert Chart & Smart art
15:35 -
9 – Header and Footer in Word
11:57 -
10 – Insert Symbol and Object
07:32 -
11 – Design Tab in Word
10:16 -
12 – Page layout Tab in Word
10:52 -
13 – References Tab in Word
13:41 -
14 – Mailings Tab in Word
13:42 -
15 – Review Tab in Word
16:47 -
16 – View Tab and File Menu in Word
11:52 -
17 – Option Settings in Word
11:12 -
18 – Option Settings in Word 2
10:29 -
19 – File Option Settings 3
06:20 -
20 – Customize Ribbon in Word – Create your own tab
08:10 -
21 – Mail merge with Excel Data in Word
06:40 -
22 – Create Professional Resume in Word
23:28 -
23 – Create Letter in Word Typing Exam
04:38 -
24 – Word – Create Pro Visiting Card
16:35 -
25 – Word -Create Pro ID Card
12:45 -
26 – Word – Create Professional Certificate
16:57 -
Demo Question & Answer Word Final Test
Advance Excel Full Course (156 video)
Excel Course
-
1 – Excel Introduction (Watch Free)
13:55 -
2 – Basic Formula in Excel
20:14 -
3 – If Formula in Excel
18:13 -
4 – If and If or Formula
09:02 -
5 – Nested IF Formula in Excel
10:30 -
6 – Nested if Calculate Discount
14:51 -
7 – Salary Sheet Basic Formula
13:08 -
8 – Salary Sheet Nested if
15:32 -
9 – Attendance Sheet
14:03 -
10 – Attendacne Sheet Countif Formula
12:06 -
11 – Sort, Custom Sort & Filter
17:41 -
12 – Conditional Formatting Basic
13:23 -
13- Conditional Formatting Advance
10:17 -
14- C F Higlight Alt Rows
08:38 -
15 – Advance Filter
12:26 -
16 – Advance filter Macro
13:59 -
17 – Auto Sort Macro
07:38 -
18 – Text to Columns
04:58 -
19 – Flash Fill in Excel
13:29 -
20 – Remove Duplicate and Consolidate
08:39 -
21 – 3D Formula
07:15 -
22 – Data Validation
28:16 -
23 – Scenario Manager
06:21 -
24- Goal Seek
08:50 -
25 – Data Table
05:30 -
26 – Home Tab 1
12:23 -
27 – Home Tab 2
11:09 -
28 – Home Tab 3
06:32 -
29 – Home Tab 4
09:52 -
30 – Find and Replace
12:40 -
31 – Goto Special
12:13 -
32 – Paste Special
17:32 -
33 – Pivot Table Introduction
13:27 -
34 – Pivot Table Filter Use
08:23 -
35 – Pivot Table Options
11:42 -
36 – Slicer and Timeline
15:09 -
37 – Pivot Chart in Excel
10:56 -
38 – Auto Refresh Pivot Table
06:21 -
39 – Table in Excel
10:56 -
40 – Insert Tab – 1
08:48 -
41 – Insert Tab2
08:06 -
42 – Excel Chart
12:21 -
43 – Excel Chart and Formatting
08:15 -
44 – Excel Sparkline Chart
05:29 -
45 – Hyperlink in Excel
04:31 -
46 – Insert Tab 3
11:58 -
47 – Watermark in Excel
05:39 -
48 – Pagelayout Tab Themes and Margins
11:12 -
49 – Pagelayout Tab Print Settings
11:13 -
50 – Pagelayout Tab 2
07:02 -
51 – Pagelayout Tab3
11:39 -
52 – Formula Tab Name Manager
11:28 -
53 – Formula Tab Formula Auditing
09:01 -
54 – Data Tab Get External Data
08:09 -
55 – Data Tab SubTotal
07:22 -
56 – Data Tab Solver add ins
06:29 -
57 – Reveiw Tab
09:38 -
58 – View Tab
10:34 -
59 – Macro Recording
12:13 -
60 – Create your own Tab
05:56 -
61 – Vlookup 1 Intro
16:37 -
62 – Vlookup 2 Use of Range Lookup
13:02 -
63 – Vlookup 3 Double Vlookup
08:28 -
64 – Vlookup 4 Nested Vlookup
07:46 -
65 – Vlookup 5 Vlookup Project
09:24 -
66 – Vlookup 6- Unique Example of Vlookup
05:38 -
67 – CountA and Count Blank Formula
07:10 -
68 – Countif Formula
05:59 -
69 – Countifs Formula
11:33 -
70 – Sumif and Sumifs
07:21 -
71 – Averageif and Averageifs
06:56 -
72 – Frequency Formula
07:25 -
73 – Index and Match
07:10 -
74 – Lookup Formula
05:06 -
75 – SumProduct , Left and Find formula
07:13 -
76 – Right and Find
05:01 -
77 – Mid and Find Formula
09:56 -
78 – Repeat and Substitute Formula
04:26 -
79 – PMT, PV, FV Formula
10:50 -
80 – IPMT AND PPMT
08:34 -
81- V lookup with Match
10:19 -
82 – Text Formulas
06:45 -
83 – Date in Quarter
06:19 -
84 – Datedif Formula
06:44 -
85 – Date Formula
05:13 -
86 – Switch Date
06:32 -
87 – More Date Formulas
07:23 -
88 – Ranking Formula
05:20 -
89 – Concatenate and Vlookup
04:04 -
90 – Sheet Tips
06:32 -
91 – Excel To Powerpoint
06:14 -
92 – Change Excel Icon
06:25 -
93 – Number to Word
06:14 -
94 – Custom Cells Tips
08:00 -
95 – Picture Lookup
11:27 -
96 – Picture Game
08:21 -
97 – Data Entry form
04:22 -
98 – File Menu
06:05 -
99 – Excel Settings
10:59 -
100 – Short formulas
11:06 -
101 – Excel – Database function DGET Formula of Excel
10:36 -
102 – Excel – DSUM Formula in Excel
07:24 -
103 – Excel – DAVERAGE Formula
02:41 -
104 – Excel – DCOUNT, DCOUNTA Formula
04:11 -
105 – Excel -DMAX Formula, DMIN Formula, DPRODUCT Formula
06:10 -
106 – Excel – Vlookup on Multiple Tables
06:54 -
107 – Excel – Offset Formula Introduction
11:01 -
108 – Excel – Offset Formula Calculate Sum of Last 6 Days
09:37 -
109 – Excel – Offset Formula Real Job Use
05:21 -
110 – Excel – Sumifs, Index, Match Real Job Use
08:24 -
111 – Excel – Practical use of Isblank and Istext Formula
04:35 -
112 – Excel – Counting Words in Excel Interview Question
08:54 -
113 – Excel – Build Login in Excel Formula
05:55 -
114 – Excel – Create Dynamic List Using Index, Match Formula
04:08 -
115 – Excel – Conditional Formatting with Text and Or Formula
04:33 -
116 – Excel – Unique Example of Conditional Formatting
05:53 -
117 – Excel – Auto Sort data using Countif, Match and Index Formula
09:02 -
118 – Excel – Condition Inside Rank using CountIFS Formula
05:40 -
119 – Excel – Camera, Autofilter, Form – 3 Hidden Features
06:55 -
120 – Excel – Max IF and Min IF Formula using Array
05:39 -
121 – Excel – Choose Formula in Excel
07:15 -
122 – Excel – Swap range in Excel
04:19 -
123 -Excel- Reverse Lookup Using Choose Formula
05:37 -
124 – Excel – Reverse Lookup using Match and Index
06:40 -
125 – Excel – Find & Vlookup Real Job Query
09:41 -
126 – Excel – Vlookup Duplicate Names Issue
04:09 -
127 – Excel – Vlookup with Chooze formula and array
09:10 -
128 – Excel – Text Join Formula in Excel 2019
05:02 -
129 – Excel – IFS Formula in Excel 2019
04:47 -
130 – Excel – MaxIFS and MinIFS in Excel 2019
04:37 -
131 – Excel – Filter Formula of Office 365
05:19 -
132 – Excel – Sort Formula of Office 365
06:56 -
133 – Excel – Real Job use of Aggregate Formula in Excel
10:34 -
134 – Excel – Xlookup In Office 365 – 1-1
06:36 -
135 – Excel – Xlookup In Office 365 – 2-1
06:42 -
136 – Excel – Xlooup Work Reverse
09:47 -
137 – Excel – Xlooup In Office 365
05:29 -
138 – Excel – Xlooup In Office 365
09:56 -
139 – Excel – Xlookup in Office 365
08:39 -
140 – Excel – Xlookup in Office 365
06:18 -
141 – Excel – Xlookup in Office 365
05:06 -
142 – Excel – Xlookup in Office 365
05:35 -
143 – Excel – Xlookup in Office 365
05:20 -
144 – EXCEL – XMATCH Formula office 365
13:08 -
145 – Excel – Create Searchable Drop Down List In Office 365
09:44 -
146 – Excel – Analyze Data And Get Ideas Office 365
06:31 -
147 – Excel – Map Chart In Office 365
08:05 -
148 – Excel – Dynamic Conditional Formatting
09:53 -
149 – Excel – Unique Formula In Office 365
05:19 -
150 – Excel – Sequence And Random Array Formula In Office 365
04:35 -
151 – EXCEL – Assignment 1 With Answer 365
13:17 -
152 – EXCEL – Assignment 2 With Answer 365
06:40 -
153 – EXCEL – Assignment 3 With Answer 365
04:37 -
154 – EXCEL – Assignment 4 With Answer 365
03:14 -
155 – Excel Interview Questions-1
41:51 -
156 – Excel Interview Questions-2
26:12 -
157 – Use your Brain – Interview Question
35:49 -
158 – Interview Question – Mode Function
11:54 -
159 – Interview Question – Goto and Conditional Formatting
08:02
PowerPoint Full Course (15 video)
PPT Course
-
1- Introduction of PowerPoint
12:31 -
2 – Creating Slides in PowerPoint
13:48 -
3 – Design Tab in PowerPoint (Watch Free)
08:39 -
4 – Transitions Tab in PowerPoint (Watch Free)
05:15 -
5 – Loop Slide in PowerPoint
06:54 -
6 – Animation Tab in PowerPoint
13:35 -
7 – Animation Pane in PowerPoint
10:17 -
8 – Presenter View in PowerPoint
04:50 -
9 – Slide Show Tab In PowerPoint
03:16 -
10 – Create Photo album, Add Music & Videos
17:14 -
11 – Excel To PPT Animation
19:23 -
12 – Amazing PPT
09:04 -
13 – Count down Timer in PowerPoint
03:51 -
14 – Five Power Tips of PPT
11:51 -
15 – Video Inside Text in PowerPoint
07:16 -
PowerPoint Final Test Demo Questions with Answers
Microsoft Access Full Course (35 video)
Msaccess
-
1 – MS-Access Introduction
13:13 -
2 – Creating Table in MS Access
16:18 -
3 – Delete & Add Columns in Access
07:26 -
4 – Create Lookup Wizard from List
07:32 -
5 – Break Lookup Relationship
06:10 -
6 – Calculation in Access
08:14 -
7- IF Formula in Access
08:28 -
8 – IF AND, IF OR in Access
07:55 -
9 – Import Tables from Excel, Notepad in Access
10:42 -
10 – Filter and Sort in Access
07:59 -
11 – Advance Filter in Access
08:09 -
12 – Records Group in Access
09:08 -
13 – Find and Replace in Access
07:03 -
14 – Access – Create Query using Query Wizard
07:41 -
15 – Access – Design Query on Existing Query
05:10 -
16 – Access – Create Parameter Query
08:03 -
17 – Access – Query with Relationship
10:19 -
18 – Access – Query with Calculated Field
04:38 -
19 – Access – Pivot Table in Access – Cross Tab Query
06:13 -
20 – Access – Find Duplicate Query
05:44 -
21 – Access – Unmatched Query
08:03 -
22 – Access – Export Access data
08:08 -
23 – Access – Hide Table and Query from Navigation
06:19 -
24 – Access – Add Totals in Query
06:07 -
25 – Access – SQL View of Query
06:54 -
26 – Access – Create form using Form Wizard
09:52 -
27 – Access – Design Form using Design Tab
11:22 -
28 – Access – Conditional Formatting in Form
09:30 -
29 – Access – Customize Button in Forms
11:37 -
30 – Access – Insert Charts in Form
07:47 -
31 – Access – Create Reports from Report Wizard
08:35 -
32 – Access – Design and Format Report
07:37 -
33 – Access – Design and Conditional Formatting in Report
09:09 -
34 – Access – Parameter Reports
05:11 -
35 – Access – Create Print Preview Button of Report
05:00 -
Demo Question & Answer Ms-Access Final Test
Microsoft Outlook (10 video)
-
1 Outlook Introduction Configure
10:35 -
2 Outlook Email 1
09:17 -
3 Outlook Email 2
07:19 -
4 Outlook Create Appointment
08:01 -
5 Outlook Set Meeting
06:52 -
6 Outlook Create Contact
11:31 -
7 Outlook Set Task in Outlook
07:03 -
8 Outlook Create Contact Group
06:31 -
9 Outlook Mail Merge Outlook contacts
07:59 -
10 Outlook Create Folder and View Settings
07:24
Internet And Email (9 video)
-
1 – Google Search Engine
12:20 -
2 – Creating Email ID
11:50 -
3 – Sending Email
11:30 -
4 – Use Google Drive
12:50 -
5 – Network Information & Settings
11:20 -
6 – Govt. Websites
08:01 -
7 – Internet Security & Settings
07:47 -
8 – Hindi Typing In Chrome
07:41 -
9 – Hindi Typing In Chrome -2
05:20
Microsoft Publisher (10 video)
-
1 – Publisher – Introduction
14:17 -
2 – Publisher – Insert Text Box
10:42 -
3 – Publisher – Insert Picture
12:51 -
4 – Publisher – Insert Catalog Pages and Table
10:47 -
5 – Publisher – Insert Calendar and Page Parts
07:29 -
6 – Publisher – Create Advertisements
00:22 -
7 – Publisher – Insert file from word
06:58 -
8 – Publisher – Header and Footer
07:00 -
9 – Publisher – Page Design Tab
10:33 -
10 – Publisher – Mail Merge
12:27
MS Office Exam
-
How will You get Certificate?
04:13 -
Demo Question & Answer MS Office Final Test
-
Final Test