Module 1: Computer & MS Office Fundamentals

• Introduction to computers
• Hardware and software basics
• Operating system fundamentals
• Introduction to MS Office
• MS Office applications and uses
• File and folder management
• Creating, saving, opening and printing files
• Common keyboard shortcuts

Module 2: MS Word – Document Creation

• Introduction to MS Word
• Word interface and workspace
• Creating and editing documents
• Text selection and editing
• Fonts and text formatting
• Paragraph formatting
• Alignment, indentation and spacing
• Bullets and numbering
• Find and Replace
• Page setup and margins

Module 3: MS Word – Advanced Features

• Tables and table formatting
• Images and shapes
• SmartArt and WordArt
• Headers and footers
• Page numbers
• Styles and templates
• Columns and page breaks
• Mail Merge
• References and hyperlinks
• Printing and PDF conversion
• Practical: Resume, business letter and official report

Module 4: MS Excel – Basics

• Introduction to MS Excel
• Workbook and worksheet
• Rows, columns and cells
• Data entry and editing
• Cell formatting
• Number, date and currency formats
• Basic formulas
• Relative and absolute cell references
• AutoFill and Flash Fill
• Basic worksheet management

Module 5: MS Excel – Formulas & Functions

• SUM, AVERAGE, COUNT, MIN and MAX
• IF function
• AND and OR functions
• COUNTIF and SUMIF
• VLOOKUP/XLOOKUP basics
• Text functions
• Date and time functions
• Sorting and filtering
• Conditional formatting
• Data validation

Module 6: MS Excel – Data Analysis

• Charts and graphs
• Column, bar, pie and line charts
• Pivot Tables
• Pivot Charts
• Subtotals
• Basic data analysis
• Page layout and printing
• Protecting worksheets
• Practical: Marksheet, salary sheet, invoice and expense report

Module 7: MS PowerPoint – Presentation Basics

• Introduction to PowerPoint
• Creating presentations
• Slide layouts
• Themes and templates
• Adding and formatting text
• Images and shapes
• Tables and charts
• SmartArt and WordArt
• Slide organization

Module 8: MS PowerPoint – Advanced Presentation

• Slide transitions
• Animations
• Audio and video
• Hyperlinks and action buttons
• Slide Master
• Headers and footers
• Presentation and slideshow settings
• Professional presentation techniques
• Practical: Business/educational presentation

Module 9: MS Office Productivity Tools

• Office templates
• Document sharing
• Basic cloud/file management concepts
• PDF creation and conversion
• Printing and page setup
• Common Office keyboard shortcuts
• Basic data protection and document security

Module 10: Practical Projects

• MS Word: Resume, application letter and business report
• MS Excel: Marksheet, payroll/salary sheet and sales report
• MS PowerPoint: Company profile or educational presentation
• Integrated MS Office project
• Final practical assessment

Course Outcome

After completing the course, learners will be able to create professional documents in MS Word, prepare calculations and reports using MS Excel, and design effective presentations using MS PowerPoint, along with essential office productivity skills.