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