Microsoft Office

Course Syllabus

• Introduction of Microsoft Office
• Introduction of Word Processing Software Microsoft Word
• Creating and Saving Documents
• Opening and Closing Documents
• Editing Text
• Page Setup – Paper Size, Orientation, Margins, Gutter
• Moving around the document with keyboard shortcuts
• Protect Documents with password
• Text Formatting with keyboard shortcuts
• Advance Text Formatting
• Advance Paragraph Formatting
• Find, Replace and GoTo
• Change Case – Upper case, Lower case, Sentence case, Capitalize Each Word case, toggle case
• Headers and Footers
• Bullet and Numbering
• Borders and Shading
• Inserting Images, Shapes, 3D Model, SmartArts, Charts, Screenshot, WordArt
• Page Colour and Watermark
• Tabs
• Columns
• Spelling and Grammar
• Page Break and Section Break
• Table
• Table Keyboard Shortcuts
• Hyperlink, Cross Reference
• Mail Merge
• Printing Documents and many more.

• Introduction of Microsoft Excel
• Introduction of Worksheet or Spreadsheet or Sheet
• Parts or Components of Excel Window
• Moving around the Worksheet with keyboard shortcuts
• Inserting Row, Column and Sheet
• Deleting Row, Column and Sheet
• Formatting Cells, Row, Column and Sheet
• Hide and Unhide Row, Column and Sheet
• Rename Sheet, Change Tab Colour of Sheet
• Data Entry and Editing
• Creating and Managing Databases
• Protecting Worksheet with password
• Formula or Functions in Excel
• Mathematical Function
• Text Function
• Date and Time Function
• Logical Function
• Financial Function
• Inserting and Formatting Charts and Graphs (Column, Pie, etc.)
• Conditional Formatting
• Sorting and Filtering Data
• Auditing – Trace Precedent, Trace Dependent, Remove All
• Pivot Tables
• Data Validation
• Page Setup and Printing and many more.

• Introduction of Presentation Software
• Features of Microsoft PowerPoint
• Creating and Showing Presentation
• Creating Slides, Slide Layouts and Themes
• Inserting Text, Images, Shapes, SmartArts and Charts
• Slide Formatting
• Slide Transitions and Animations
• Slide Show, Custom Show
• Inserting Audio and Video in presentation
• Presentation Design Techniques
• Printing Handouts
• Exporting Presentation in mp4 video Format and many more.

Microsoft Access is a database management system (DBMS) developed by Microsoft. It is used to create, manage, and analyze structured data efficiently. This course provides a complete understanding of database concepts and practical skills to design and manage databases.
Course Contents:
Introduction to Database & MS Access
Basics of Database Management System (DBMS)
Features and uses of Microsoft Access
Understanding tables, records, and fields
Access interface and environment
Creating and Managing Tables
Creating tables in Design View and Datasheet View
Data types and field properties
Primary key and indexing
Data entry, editing, and validation
Queries (Data Retrieval & Filtering)
Introduction to queries
Creating Select Queries
Using criteria and sorting data
Parameter queries and calculated fields
Action queries (Update, Delete, Append)
Forms (User Interface Design)
Creating forms using Form Wizard
Designing and customizing forms
Adding controls (text box, combo box, buttons)
Data entry through forms
Reports (Data Presentation)
Creating reports using Report Wizard
Formatting and grouping data
Adding headers, footers, and calculations
Printing and exporting reports
Relationships & Data Integrity
Creating relationships between tables
One-to-One, One-to-Many relationships
Referential integrity and cascade options
Import, Export & Database Tools
Importing data from Excel and other sources
Exporting data to different formats
Compact and repair database
Backup and security basics

Course Contents:
Introduction to MS Outlook
Overview of Outlook features and uses
Understanding the Outlook interface
Setting up email accounts (IMAP/POP)
Email Management
Composing, sending, and receiving emails
Formatting emails (fonts, attachments, signatures)
Reply, Reply All, Forward
Organizing emails using folders
Advanced Email Features
Using CC and BCC
Email rules and filters
Search and categorization
Spam and junk mail management
Contacts Management
Creating and managing contacts
Contact groups and distribution lists
Importing and exporting contacts
Calendar & Scheduling
Creating appointments and events
Scheduling meetings and invitations
Sharing calendars
Reminders and notifications
Tasks & Notes
Creating and managing tasks
Setting priorities and deadlines
Notes and quick access tools
Productivity & Security
Email backup and archive
Data file management (.pst, .ost)
Password protection and security settings
Integration with other Microsoft Office apps

Scroll to Top