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