📘 MS Office Syllabus

1. Introduction to MS Office

• Overview of Microsoft Office
• Features and applications
• Starting and navigating Office programs
• File handling (open, save, print)

2. MS Word (Word Processing)

Using Microsoft Word

Basics

• Creating, saving, opening documents
• Text editing (copy, paste, cut, undo/redo)
• Formatting text (font, size, color)

Formatting & Layout

• Paragraph formatting (alignment, spacing)
• Page setup (margins, orientation)
• Bullets and numbering

Advanced Features

• Tables and columns
• Insert images, shapes, symbols
• Headers, footers, page numbers
• Mail Merge (letters, labels)

3. MS Excel (Spreadsheets)

Using Microsoft Excel

Basics

• Workbook and worksheet concepts
• Data entry and editing
• Rows, columns, and cells

Formulas & Functions

• Basic formulas (SUM, AVERAGE, COUNT)
• Logical functions (IF)
• Charts and graphs

Data Handling

• Sorting and filtering
• Conditional formatting
• Pivot tables (basic introduction)

4. MS PowerPoint (Presentations)

Using Microsoft PowerPoint

Basics

• Creating presentations
• Slide layouts and themes

Design & Effects

• Adding text, images, charts
• Animations and transitions
• Slide show setup

Advanced

• Slide master
• Presentation tips and delivery

5. MS Access (Database – Optional)

Using Microsoft Access

• Introduction to databases
• Tables, queries, forms, reports
• Basic data management

6. MS Outlook (Email – Optional)

Using Microsoft Outlook

• Sending and receiving emails
• Managing contacts
• Calendar and scheduling

7. Practical & Project Work

• Create documents in Word
• Prepare Excel sheets with formulas
• Design PowerPoint presentations
• Mini project combining all tools