MS-Office Full Course – Basic To Advanced
rating:
Enrolment validity: Lifetime
Login
Course Benefits
materials include
course content
Ratings & Reviews
course description
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
Course Benefits
- निचे दिए गए 225+ टॉपिक्स आप सीखोगे।
- Computer Fundamental + MS-Word Full Course + Advance Excel Full Course
- PowerPoint Full Course + MS-Access Full Course + Microsoft Outlook
- Internet + Publisher बेसिक से एडवांस
materials include
- 250+ Video Tutorials
- 200+ Practice Files
- 6 Test on MS-Office
- Course Completion Certificate
- Keyboard Shortcuts PDF
- 50+ Hours Course
course content
Computer Fundamental
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 (26 video)
2 – Home Tab Font Group18:28
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 (156 video)
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
155 – Excel Interview Questions-100:41:51
156 – Excel Interview Questions-200:26:12
157 – Use your Brain – Interview Question00:35:49
158 – Interview Question – Mode Function00:11:54
159 – Interview Question – Goto and Conditional Formatting00:08:02
PowerPoint Full Course (15 video)
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 (35 video)
2 – Creating Table in MS Access16: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:8: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 (10 video)
1 Outlook Introduction Configure00:10:35
2 Outlook Email 100:09:17
3 Outlook Email 200:07:19
4 Outlook Create Appointment00:08:01
5 Outlook Set Meeting00:06:52
6 Outlook Create Contact00:11:31
7 Outlook Set Task in Outlook00:07:03
8 Outlook Create Contact Group00:06:31
9 Outlook Mail Merge Outlook contacts00:07:59
10 Outlook Create Folder and View Settings00:07:24
Internet And Email (9 video)
1 – Google Search Engine00:12:20
2 – Creating Email ID00:11:50
3 – Sending Email00:11:30
4 – Use Google Drive00:12:50
5 – Network Information & Settings00:11:20
6 – Govt. Websites00:08:01
7 – Internet Security & Settings00:07:47
8 – Hindi Typing In Chrome00:07:41
9 – Hindi Typing In Chrome -200:05:20
Microsoft Publisher (10 video)
2 – Publisher – Insert Text Box00:10:42
3 – Publisher – Insert Picture00:12:51
4 – Publisher – Insert Catalog Pages and Table00:10:47
5 – Publisher – Insert Calendar and Page Parts00:07:29
6 – Publisher – Create Advertisements00:00:22
7 – Publisher – Insert file from word00:06:58
8 – Publisher – Header and Footer00:07:00
9 – Publisher – Page Design Tab00:10:33
10 – Publisher – Mail Merge00:12:27
MS Office Exam
Student Ratings & Reviews
4.9
Total 33 Ratings
Way of delivering content is too good . Meanwhile your joke makes attractive class .
Sham Bhalerao
2 months ago
Your teaching method is so easy any one can understand. Fully satisfied. thanks for providing us this course such a affordable price.
Dhananjay Hage
2 months ago
VERY NICE TEACHING STYLE SIR....
Lets_learn01
3 months ago
Thanks to you give me a chance to know myself ☺️
Dibyajyoti Das
3 months ago
Thnq u sir...
Harsh verma
3 months ago
Excellent..... Please upload SAP FICO course videos
Muhammad sahil
3 months ago
My name is Muhammad Sahil Rajpoot .I belong to Pakistan punjab .I am very happy to get enrolled for this course .Hope so will help me a lot .To day is my first day .i have listened three lectures today .teaching method is just awesome .just salute to u sir .
Patelsaloni12
4 months ago
Thank you so much sir....I really enjoying your way of teaching .
Saddam Husen
4 months ago
Nice
Sayed Shamim Ahamed
4 months ago
exellent course
Riteshchaudhary
5 months ago
Thanks for making this biggest Course for us I was waiting for this really enjoined your way of teaching
Vinod Rathod
6 months ago
Learn MS Office - Basic To Advance In One Course, Thank You, Sir.
Vivek Gupta
6 months ago
No One can be teach like you sir.....very easy method to learn everything.....
Sk. Abdul khader jeelani
6 months ago
Super super course sir tq
Bharat_sonagara
7 months ago
Very Good course ☺️
Imran Khan
9 months ago
HOW DO DOWNLOAD VIDEOS
AMOL DWIVEDY
10 months ago
An excellent course designed to help beginners get a grasp of what are some of the advanced features of Microsoft Office & Computer Fundamentals in one robust and complete package. The teaching style of Satish Sir is simply magnificent, intended to focus on students from any educational background. I would definitely recommend this course to anyone who aspires to know the basics as well as advanced features of MS Office in a detailed and intriguing manner. All 8 courses included in this package are user-friendly & tend to impart practical skills to the students which would help them in their quest to find a suitable job. My personal favorite is the Advanced Excel Course. Overall, I had a wonderful experience and I am fully satisfied with this course. Thank you very much, Satish Sir, for helping me acquire such gainful knowledge.
Shreya Nimje
11 months ago
Overall course is nice , plz also make more courses related to VBA and MACRO basic to advanced course .Hope these will come too soon :)
Aritra Sarkar
11 months ago
Sir, hard course hai
Zafer Hashmi
11 months ago
Excellent sir ji ☺️
KRISHNA PARSHOTTAMBHAI
1 year ago
Fully satisfied ,,,,thanks for providing us this course such a affordable THANKS SIR
Abid Hossain Mohammed
1 year ago
It\'s very easy to learn and learn more
Satnam Singh
1 year ago
Bohat sahi explain karte ho aap. Or joke bhi ache karte ho bech bech main but thek hai thoda njoy bhi hona chahiye
Ramesh Wani
1 year ago
Basically itna bada course aapne lifetime access rakha iske liye bahut danyawad mai job karke ise complete karna chahta tha aur ab ye aapki wajah se possibel hai sirji dilse danyawad.
Jyoti Bhushan Pathak
1 year ago
Fully satisfied ,,,,thanks for providing us this course such a affordable price....
SMILE SHAIK
2 years ago
Fully satisfied, Thanks #Satish #Dhawale(#Respected #Sir) for providing us such this Course at Affordable #Price
I Just Seen One Video & I am Truly Satisified
May #God Blesses Always
BISWAMOHAN GAHIR
2 years ago
Fully satisfied ,,,,thanks for providing us this course such a affordable price....
Iqbal Khan
2 years ago
You are giving a awesome knowledge to entire world, this course is very help full for me to learn office tools at one place.
Raj Sharma
2 years ago
Thanks for Making this biggest course for us I was waiting for this really enjoying your way of teaching.