MS-OFFICE SYLLABUS

📘 MODULE 1: Introduction to MS-Office

• Introduction to Computer Fundamentals
• Overview of Microsoft Office Suite
• Versions of MS-Office (2016 / 2019 / 2021 / 365)
• Office Interface & Navigation
• File operations (Create, Save, Open, Print, Export)
• Keyboard shortcuts & productivity tips

📝 MODULE 2: Microsoft Word

Basics

• Creating, Opening & Saving Documents
• Text formatting (Font, Paragraph, Styles)
• Page Setup (Margins, Orientation, Size)
• Headers, Footers & Page Numbers

Intermediate

• Tables (Insert, Format, Calculate)
• Bullets & Numbering
• Find & Replace
• Spell Check, Thesaurus, Word Count
• Inserting Images, Shapes, Charts

Advanced

• Styles & Templates
• Mail Merge (Letters, Labels, Envelopes)
• Track Changes & Comments
• Table of Contents
• Document Protection & Printing

Practical Tasks:

✔ Resume creation

✔ Official letters

✔ Reports & notices

📊 MODULE 3: Microsoft Excel

Basics

• Excel Interface & Workbook Structure
• Data Entry & Formatting
• Rows, Columns & Cells
• Basic Formulas (+ - * /)

Functions

• Mathematical Functions (SUM, AVERAGE, MIN, MAX)
• Logical Functions (IF, AND, OR)
• Text Functions (LEFT, RIGHT, LEN)
• Date & Time Functions

Data Analysis

• Sorting & Filtering
• Conditional Formatting
• Charts & Graphs
• Pivot Tables & Pivot Charts

Advanced

• Data Validation
• What-If Analysis
• Introduction to Macros & VBA
• Dashboard Basics

Practical Tasks:

✔ Employee salary sheet

✔ Sales report

✔ Budget & expense tracker

📽️ MODULE 4: Microsoft PowerPoint

• Creating Presentations
• Slide Layouts & Themes
• Text, Images & SmartArt
• Charts & Tables
• Animations & Transitions
• Slide Master
• Presentation Tips & Slide Show Settings

Practical Tasks:

✔ Business presentation

✔ Project presentation

✔ Seminar slides

📧 MODULE 5: Microsoft Outlook

• Email Creation & Management
• Inbox Organization
• Attachments & Signatures
• Calendar & Scheduling Meetings
• Contacts & Tasks
• Email Etiquette