Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Microsoft Office Suite
Section 1: MS Word Training
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
All 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
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
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
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.Excel Flash Fill Saves The day (4:03)
75.Using Combo Boxes (6:14)
76.The Hlookup Function (5:56)
77.Lookup for Inverse Data (10:15)
78.Introduction To Index Match (7:38)
79.Quiz Assignment Remington Pharma Explanation (2:21)
80.Invoicing System Remington Pharmaceuticals (12:20)
Assessment Exercise- 10
Section 11: Microsoft Excel Training - Part 7
81.Sum If and IFS (8:47)
82.Forget filters use DSUM Search Box (4:30)
83.Amazing Advance Filters Macros (20:05)
84.Introduction to Pivot tables (8:24)
85.Grouping In Pivot Tables (8:17)
Assessment Exercise- 11
Section 12: Microsoft Excel Training - Part 8
86.Calculated Fields (5:59)
87.Pivot Charts (9:11)
88.Dashboard Reporting (9:36)
89.Automated Cheque Printing System (Using Mail Merge) (13:29)
90.Introduction to Hyperlinks (4:45)
92.Columns Separation Concatenation (6:10)
Assessment Exercise- 12
Section 13: Microsoft Excel Training - Part 9
91.Hyperlinks With External Sheet References (2:09)
Resources
Assessment Exercise- 13
Section 14: Microsoft PowerPoint Training - Part 1
94.Creating Blank Presentation and PowerPoint Interface (6:04)
95.Inserting New Slides and Working with Layouts (4:18)
96.Changing Layout and Arrangement of Slides (2:40)
97.Designing Slides in Powerpoint (4:38)
98.Inserting and Customizing Pictures In Powerpoint (6:53)
99.Logo Insert in Presentation and Online Images (2:36)
Assessment Exercise- 14
Section 15: Microsoft PowerPoint Training - Part 2
100.Use Smart Art to Enhance Graphical Look of Presentation (5:12)
101.Using Charts In Powerpoint Presentations (8:37)
102.Inserting Audio to your Slides (4:22)
Assessment Exercise- 15
Section 16: Microsoft Outlook Training - Part 1
103.Introduction and Configure Gmail on Outlook (6:20)
104.Understanding Microsoft Outlook Interface (2:55)
105.Using Calendar feature for Appointments and Meetings (6:12)
106.Sending Meeting Invites to Attendees (2:38)
107.Using Auto Correct Function to Automate Email Typing (3:25)
Assessment Exercise- 16
Section 17: Microsoft Outlook Training - Part 2
108.Using Quick Access Toolbar (1:19)
109.Use of Voting Buttons (2:00)
110.Enable Blind Carbon Copy (1:11)
111.Change Reply to Address in Outlook (1:55)
112.Using Search Folders for Email Management (4:43)
113.Inserting Signature in Outlook (4:47)
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
🎉 Apply for Certificate!
Get Certificate
86.Calculated Fields
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock