OFFICE PROFICIENCY COURSE

Course Objective

This course is designed to develop practical computer and office-management skills required for modern workplaces. Students will learn MS Office, internet, email, data management, documentation and professional office automation.

Module 1: Computer Fundamentals

• Introduction to Computers
• Hardware and Software
• Input and Output Devices
• Windows Operating System
• Desktop, Taskbar and Start Menu
• File and Folder Management
• Installing and Uninstalling Software
• Basic Computer Troubleshooting

Module 2: MS Word – Document Processing

• Creating and Saving Documents
• Text Formatting and Paragraph Formatting
• Page Setup and Page Layout
• Tables and Tabulation
• Headers and Footers
• Page Numbers
• Bullets and Numbering
• Find and Replace
• Mail Merge
• Printing and PDF Creation
• Resume, Letter and Report Preparation

Module 3: MS Excel – Spreadsheet Management

• Excel Interface and Workbook Management
• Rows, Columns and Cells
• Data Entry and Formatting
• Basic Formulas and Functions
• SUM, AVERAGE, COUNT, MAX and MIN
• IF, AND, OR and Nested IF
• VLOOKUP/XLOOKUP
• Sorting and Filtering
• Conditional Formatting
• Data Validation
• Charts and Graphs
• Pivot Tables
• Basic Data Analysis
• Professional Salary, Attendance and Sales Sheets

Module 4: MS PowerPoint – Presentation Skills

• Creating Presentations
• Slide Layouts and Themes
• Text, Images, Shapes and Icons
• Tables and Charts
• Transitions and Animations
• Slide Master
• Presentation Design
• Adding Audio and Video
• Professional Business Presentation
• Presentation and Practical Project

Module 5: MS Outlook & Professional Email

• Creating and Managing Emails
• To, CC and BCC
• Email Attachments
• Email Formatting
• Email Signature
• Contacts Management
• Calendar and Meetings
• Professional Email Writing
• Email Etiquette

Module 6: Internet & Digital Office Skills

• Internet Basics
• Search Techniques
• Downloading and Uploading Files
• Google Search
• Online Forms
• Cloud Storage
• Google Drive
• Google Docs
• Google Sheets
• Google Forms
• Online File Sharing

Module 7: Office Automation

• Printing and Scanning
• PDF Creation and Management
• PDF Merging and Splitting
• Document Conversion
• Photocopy and Scan Management
• File Backup
• Digital Document Management
• Office Data Organization

Module 8: Typing & Data Entry

• English Typing Practice
• Typing Speed and Accuracy
• Keyboard Shortcuts
• Data Entry Techniques
• Copy, Paste and Formatting
• Basic Data Verification
• Practical Data Entry Projects

Module 9: Advanced Office Skills

• Advanced Excel Functions
• Advanced Tables and Charts
• Pivot Tables and Reports
• Data Cleaning
• Professional Templates
• Automated Office Reports
• Basic MIS Reporting
• Office Documentation

Module 10: Practical Projects

Students will prepare practical projects such as:

• Professional Resume
• Business Letter
• Office Report
• Employee Attendance Sheet
• Salary Sheet
• Sales Report
• Inventory Sheet
• Customer Database
• PowerPoint Business Presentation
• Professional Email Assignment

Course Duration

2–3 Months

Training Method

Theory + Practical Training + Assignments + Projects + Assessment

Suitable For

Students | Job Seekers | Office Employees | Beginners | Professionals

Career Opportunities

Computer Operator | Office Assistant | Data Entry Operator | Back Office Executive | Admin Assistant | MIS Executive