← Back to Computer Courses

01

COURSE SYLLABUS

MS Office

Explore the complete course syllabus, topics and practical learning areas.

WHAT YOU WILL LEARN

Course Syllabus

A structured learning path covering the topics included in this course.

01

MS Word

Introduction to MS Word
Creating, editing & formatting documents
Font, paragraph & page formatting
Tables and table formatting
Headers, footers & page numbers
Page setup & printing
Images, shapes, icons & SmartArt
Mail Merge
Find & Replace
Styles, Templates & Themes
Resume / CV preparation
Official letters & business documents
Practical document projects

02

MS Excel

Introduction to Excel
Workbook, worksheets, rows & columns
Data entry & formatting
Basic formulas & functions
SUM, AVERAGE, MIN, MAX, COUNT
IF, AND, OR
COUNTIF, SUMIF
VLOOKUP / HLOOKUP
XLOOKUP
Sorting & Filtering
Tables
Conditional Formatting
Data Validation
Charts & Graphs
Pivot Tables
Basic data analysis
Printing & Page Setup
Practical Excel projects
Salary / Payroll & Attendance sheets
Invoices & basic business reports

03

MS PowerPoint

Creating presentations
Slide layouts & themes
Text & image formatting
Shapes, icons & SmartArt
Tables, charts & graphs
Transitions
Animations
Audio & video
Slide Master
Presentation design
Presentation & slideshow settings
Professional business presentations
Practical presentation project

04

MS Outlook

Setting up an email account
Sending & receiving emails
Professional email formatting
Attachments
Email folders & organization
Contacts
Calendar & meetings
Tasks & reminders
Email signatures
Professional email communication

05

MS Office Practical Skills

Professional resume preparation
Office letters & reports
Attendance management
Salary / payroll sheet
Invoice preparation
Employee database
Monthly reports
Business presentations
Email communication
Printing & PDF conversion
Real-world office documentation