Course Brief
About this 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.
Eligibility
Requirements
- Basic computer knowledge.
- A computer with Microsoft Office Suite installed.
- Willingness to learn and practice Microsoft Office tools.
Training Plan
Learning Roadmap
01
Foundation Studio: MS Word Training
- Practice introduction through a guided digital skills practice activity.
- Grammar and Spell Checker Vocabulary of Word
- Smartly use Auto Correct for Auto Typing
- Creating Mail Merge Connecting Word With Excel
- Configuring Gmail Account on Outlook for Mail Merge
- Send Individual Emails to persons
- Letter formatting and word Spacing
- Working on Non Printing Characters on Word Document
- Line Spacing Settings on Word
- Save as Types in Microsoft Word
- Manage Multiple documents with Split and View Options
- Amazing Short keys of Word Part_1
- guided portfolio activity Exercise- 01
02
Practical Lab: MS Word Training - Part 2
- Amazing Shortkeys of Word
- Find and Replace Options
- Formatting techniques
- Using Style Function to format with Navigation
- Selection Techniques in Microsoft Word
- Working With tabs for Auto Spacing final
- Dealing With Bullets and Numbers
- Sorting Data in Ms Word
- Demote and Promote Functions in Word
- Creating and Working on Tables in Ms Word
- Insert and Deleting Rows and Columns in a Table
- guided portfolio activity Exercise- 02
03
Applied Workflow: MS Word Training - Part 3
- Tables Layout and Design
- Creating Custom Design In Tables
- Sorting Data in a Table
- Creating a Custom Table
- Saving Custom Table templates in Word
- Converting Raw Text to a Table
- Inserting Formulas to Tables
- Inserting Hard Page Breaks in Document
- Column Breaks in Word
- Columns Break Settings
- guided portfolio activity Exercise- 03
04
Professional Practice: MS Word Training - Part 4
- Inserting Watermarks
- Applying Page Borders
- Headers and Footers
- Working With Pictures
- guided portfolio activity Exercise- 04
05
Portfolio Sprint: Microsoft Excel Training - Part 1
- Practice fill series through a guided digital skills practice activity.
- Editing Custom List
- Excel Short keys Golden Key
- Introduction to Absolute Relative References
- Practice the marksheet through a guided digital skills practice activity.
- Random Number Generation
- Clearing Formula With Intact Values
- Key Components of Marksheet
- guided portfolio activity Exercise- 05
06
Career Readiness: Microsoft Excel Training - Part 2
- Introduction to IF Then Conditions
- Practice nested ifs through a guided digital skills practice activity.
- Practice ranking positions through a guided digital skills practice activity.
- Conditional Formatting Data Bars
- Practice freeze panes through a guided digital skills practice activity.
- Table Formatting Range Conversion
- Practice sort filters through a guided digital skills practice activity.
- Max Min Average Countblank Count if
- guided portfolio activity Exercise- 06
07
Foundation Studio: Microsoft Excel Training - Part 3
- Prepare a Sales and Bonus Report With Manual Totaling
- Grouping and Auto totaling
- Hiding and Unhiding Rows Grouping and Auto Totaling
- Removing Duplicates and Sales Summary With Sum if Function
- Understanding Absolute and Relative Referencing
- Applying Sum if With Absolute and Relative Referencing
- Sumif with External Sheet References
- guided portfolio activity Exercise- 07
08
Practical Lab: Microsoft Excel Training - Part 4
- IF Conditions With Multiple Logics
- Introduction to Aged Debtors Analysis
- Arranging the data to get Started
- Automate data arrangement
- Quick Trick Formatting
- Conditional formatting Advance
- guided portfolio activity Exercise- 08
09
Applied Workflow: Microsoft Excel Training - Part 5
- Applying Advance Formatting Tricks
- Formula Analysis for Aging
- Absolute Relative Functions Date values
- Practice live aging through a guided digital skills practice activity.
- Introduction to VLOOKUP
- Using Named Ranges and IF ERROR
- Simplifying Even More With data Validation
- guided portfolio activity Exercise- 09
10
Professional Practice: Microsoft Excel Training - Part 6
- Excel Flash Fill Saves The Day
- Practice using combo boxes through a guided digital skills practice activity.
- The Hlookup Function
- Lookup for Inverse Data
- Introduction To Index Match
- Quiz Assignment Remington Pharma Explanation
- Invoicing System Remington Pharmaceuticals
- guided portfolio activity Exercise- 10
11
Portfolio Sprint: Microsoft Excel Training - Part 7
- Practice sum if and ifs through a guided digital skills practice activity.
- Forget filters use DSUM Search Box
- Amazing Advance Filters Macros
- Introduction to Pivot tables
- Grouping In Pivot Tables
- guided portfolio activity Exercise- 11
12
Career Readiness: Microsoft Excel Training - Part 8
- Practice calculated fields through a guided digital skills practice activity.
- Practice pivot charts through a guided digital skills practice activity.
- Dashboard Reporting
- Automated Cheque Printing System (Using Mail Merge)
- Introduction to Hyperlinks
- Columns Separation Concatenation
- guided portfolio activity Exercise- 12
13
Foundation Studio: Microsoft Excel Training - Part 9
- Hyperlinks With External Sheet References
- guided portfolio activity Exercise- 13
14
Practical Lab: Microsoft PowerPoint Training - Part 1
- Creating Blank Presentation and PowerPoint Interface
- Inserting New Slides and Working with Layouts
- Changing Layout and Arrangement of Slides
- Designing Slides in PowerPoint
- Inserting and Customizing Pictures In PowerPoint
- Logo Insert in Presentation and Online Images
- guided portfolio activity Exercise- 14
15
Applied Workflow: Microsoft PowerPoint Training - Part 2
- Use Smart Art to Enhance Graphical Look of Presentation
- Using Charts In PowerPoint Presentations
- Inserting Audio to your Slides
- guided portfolio activity Exercise- 15
16
Professional Practice: Microsoft Outlook Training - Part 1
- Introduction and Configure Gmail on Outlook
- Understanding Microsoft Outlook Interface
- Using Calendar feature for Appointments and Meetings
- Sending Meeting Invites to Attendees
- Using Auto Correct Function to Automate Email Typing
- guided portfolio activity Exercise- 16
17
Portfolio Sprint: Microsoft Outlook Training - Part 2
- Using Quick Access Toolbar
- Use of Voting Buttons
- Enable Blind Carbon Copy
- Change Reply to Address in Outlook
- Using Search Folders for Email Management
- Inserting Signature in Outlook
- Adding Calendar to Email
- Working in Offline Mode
- Practice delay delivery through a guided digital skills practice activity.
- guided portfolio activity Exercise- 17
18
Career Readiness: Microsoft Outlook Training - Part 3
- Insert Attachments and Pictures in Email
- Send Emails to Multiple Recipients
- Creating and Managing Folders in Outlook
- Creating Rules for Managing Emails
- Managing Emails By Color Categories
- How to Add Contacts in Outlook
- Managing and Importing Contacts in Outlook
- Congratulations on Completion of Outlook
- guided portfolio activity Exercise- 18
19
Portfolio Sprint: Digital Skills Practice Review
- Review the major digital skills practice concepts through a guided recap.
- Organize class practice into a simple portfolio-ready workflow.
- Apply the learned process on a realistic task with instructor guidance.
- Prepare next-step notes for continued practice after course completion.