Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS Office
Section 1: MS Word Training
How to Use LMS & Start Learning? (6:19)
1.Introduction (8:02)
2.Grammar and Spell Checker Vocabulary of Word (3:39)
3.Smartly use Auto Correct for Auto Typing (3:00)
4.Creating Mail Merge Connecting Word With Excel (3:52)
5.Configuring Gmail Account on Outlook for Mail Merge (7:48)
6.Send Individual Emails to persons (1:22)
7.Letter formatting and word Spacing F (9:00)
8.Working on Non Printing Characters on Word Document1 (2:51)
9.Line Spacing Settings on Word (1:38)
10.Save as Types in Microsoft Word (2:13)
11.Manage Multiple documents with Split and View Options (2:49)
12. Amazing Short keys of Word Part 1 (8:24)
Assessment Exercise- 01
Resources
Section 2: MS Word Training - Part 2
13.Amazing Shortkeys of Word (4:02)
14.Find and Replace Options (4:08)
15. Formatting techniques (3:56)
16.Using Style Function to format with Navigation (6:15)
17.Selection Techniques in Microsoft Word (3:23)
18.Working With tabs for Auto Spacing final (4:53)
19.Dealing With Bullets and Numbers (5:01)
20.Sorting Data in Ms Word (3:39)
21.Demote and Promote Functions in Word (1:34)
22.Creating and Working on Tables in Ms Word (6:03)
23.Insert and Deleting Rows and Columns in a Table (3:13)
Assessment Exercise- 02
Resources
Section 3: MS Word Training - Part 3
24.Tables Layout and Design (4:20)
25.Creating Custom Design In Tables (1:16)
26.Sorting Data in a Table (2:02)
27.Creating a Custom Table (4:37)
28.Saving Custom Table templates in Word (4:03)
29.Converting Raw Text to a Table (3:13)
30.Inserting Formulas to Tables (3:54)
31.Inserting Hard Page Breaks in Document (2:36)
32.Column Breaks in Word (1:21)
33.Columns Break Settings (4:17)
Assessment Exercise- 03
Resources
Section 4: MS Word Training - Part 4
34.Inserting Watermarks (3:16)
35.Applying Page Borders (1:32)
36.Headers and Footers (8:06)
37.Working With Pictures (6:20)
Assessment Exercise- 04
Section 5: Microsoft Excel Training - Part 1
38.Fill Series (7:35)
39.Editing Custom List (3:20)
40.Excel Short keys Golden Key (4:22)
41.Introduction to Absolute Relative References (Fixed Variable) (7:20)
42.The Marksheet (4:08)
43.Random Number Generation (2:21)
44.Clearing Formula With Intact Values (3:37)
45.Key Components of Marksheet (4:28)
Assessment Exercise- 05
Section 6: Microsoft Excel Training - Part 2
46.Introduction to IF Then Conditions (3:27)
47.Nested IFs (Looping Function) (6:17)
48.Ranking Positions (5:46)
49.Conditional Formatting Data Bars (7:27)
50.Freeze Panes (3:19)
51.Table Formatting Range Conversion (4:52)
52.Sort Filters (8:31)
53.Max Min Average Countblank Count if and Much More (12:39)
Assessment Exercise- 06
Section 7: Microsoft Excel Training - Part 3
54.Prepare a Sales and Bonus Report With Manual Totaling (8:28)
55.Grouping and Auto totaling (7:29)
56.Hiding and Unhiding Rows Grouping and Auto Totaling (5:41)
57.Removing Duplicates and Sales Summary With Sum if Function (5:12)
58.Understanding Absolute and Relative Referencing (9:09)
59.Applying Sum if With Absolute and Relative Referencing (5:19)
60.Sumif with External Sheet References (3:48)
Assessment Exercise- 07
Resources
Section 8: Microsoft Excel Training - Part 4
61.IF Conditions With Multiple Logics (12:00)
62.Introduction to Aged Debtors Analysis (5:27)
63.Arranging the data to get Started (7:52)
64.Automate data arrangement (8:15)
65.Quick Trick Formatting (3:15)
66.Conditional formatting Advance (8:31)
Assessment Exercise- 08
Section 9: Microsoft Excel Training - Part 5
67.Applying Advance Formatting Tricks (6:59)
68.Formula Analysis for Aging (19:40)
69.Absolute Relative Functions Date values (11:55)
70.Live Aging (8:06)
71.Introduction to VLOOKUP (8:58)
72.Using Named Ranges and IF ERROR (3:01)
73.Simplifying Even More With data Validation (2:34)
Assessment Exercise- 09
Section 10: Microsoft Excel Training - Part 6
74.Using Combo Boxes (6:14)
75.The Hlookup Function (5:56)
76. Lookup for Inverse Data (10:15)
77.Introduction To Index Match (7:38)
78.Quiz Assignment Remington Pharma Explanation (2:21)
79.Invoicing System Remington Pharmaceuticals (12:20)
80.Sum If and IFS (8:47)
Assessment Exercise- 10
Resources
Section 11: Microsoft Excel Training - Part 7
81.Forget filters use DSUM Search Box (4:30)
82. Amazing Advance Filters Macros (20:05)
83.Introduction to Pivot tables (8:24)
84.Grouping In Pivot Tables (8:17)
85.Calculated Fields (5:59)
Assessment Exercise- 11
Resources
Section 12: Microsoft Excel Training - Part 8
86. Pivot Charts (9:11)
87. Dashboard Reporting (9:36)
88.Automated Cheque Printing System (Using Mail Merge) (13:29)
89.Introduction to Hyperlinks (4:45)
90.Hyperlinks With External Sheet References (2:09)
91. Columns Separation Concatenation (6:10)
Assessment Exercise- 12
Resources
Section 13: Microsoft Excel Training - Part 9
92.Excel Flash Fill Saves The day (4:03)
93.Creating Blank Presentation and PowerPoint Interface (6:04)
Assessment Exercise-13
Section 14: Microsoft PowerPoint Training - Part 1
94.Inserting New Slides and Working with Layouts (4:18)
95.Changing Layout and Arrangement of Slides (2:40)
96.Designing Slides in Powerpoint (4:38)
97.Inserting and Customizing Pictures In Powerpoint (6:53)
98.Logo Insert in Presentation and Online Images (2:36)
99. Use Smart Art to Enhance Graphical Look of Presentation (5:12)
Assessment Exercise- 14
Resources
Section 15: Microsoft PowerPoint Training - Part 2
100.Using Charts In Powerpoint Presentations (8:37)
101.Inserting Audio to your Slides (4:22)
102.Introduction and Configure Gmail on Outlook (6:20)
Assessment Exercise- 15
Section 16: Microsoft Outlook Training - Part 1
103.Understanding Microsoft Outlook Interface (2:55)
104.Using Calendar feature for Appointments and Meetings (6:12)
105. Sending Meeting Invites to Attendees (2:38)
106.Using Auto Correct Function to Automate Email Typing (3:25)
107.Using Quick Access Toolbar (1:19)
Assessment Exercise- 16
Section 17: Microsoft Outlook Training - Part 2
108.Use of Voting Buttons (2:00)
109.Enable Blind Carbon Copy (1:11)
110. Change Reply to Address in Outlook (1:55)
111.Using Search Folders for Email Management (4:43)
112.Inserting Signature in Outlook (4:47)
113.Adding Calendar to Email (1:14)
114.Adding Calendar to Email (1:14)
115.Working in Offline Mode (1:49)
116.Delay Delivery (1:26)
Assessment Exercise- 17
Section 18: Microsoft Outlook Training - Part 3
117.Insert Attachments and Pictures in Email (1:51)
118. Send Emails to Multiple Recipients (2:08)
119.Creating and Managing Folders in Outlook (2:10)
120.Creating Rules for Managing Emails (3:19)
121. Managing Emails By Color Categories (2:24)
122. How to Add Contacts in Outlook (1:04)
123. Managing and Importing Contacts in Outlook (4:19)
124.Congratulations on Completion of Outlook (0:04)
Assessment Exercise- 18
Section 19:Final Exam
Final Exam
76. Lookup for Inverse Data
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock