Office Management & MS Office

Week 1 — Computer Basics and Typing

• Computer parts and Windows basics
• Files, folders and shortcuts
• Internet, browsers and safe online habits
• Touch typing: home row and posture
• Daily typing practice plan

Week 2 — Microsoft Word Part 1

• Creating and formatting documents
• Paragraphs, lists and styles
• Tables and images
• Page setup and printing
• Practical: office letter and application

Week 3 — Microsoft Word Part 2

• Headers, footers and page numbers
• Letterheads and templates
• Mail merge
• Track changes and comments
• Practical: CV and company letterhead

Week 4 — Microsoft Excel Part 1

• Workbook, cells and data entry
• Formatting and number formats
• Basic formulas: SUM, AVERAGE, MIN, MAX
• Sorting and filtering
• Practical: expense sheet

Week 5 — Microsoft Excel Part 2

• IF, COUNTIF, SUMIF and VLOOKUP / XLOOKUP
• Charts
• Pivot tables
• Data validation and protecting sheets
• Practical: salary sheet and stock register

Week 6 — PowerPoint and Google Workspace

• Designing clean presentations
• Animations and slide shows
• Google Docs, Sheets and Drive
• Sharing files and working together
• Practical: company presentation

Week 7 — Email and Office Administration

• Professional email writing
• Outlook and Gmail: folders, rules, calendar
• Record keeping and filing systems
• Scheduling meetings and handling visitors
• Basic accounts: vouchers, petty cash and invoices

Week 8 — Job Readiness and Final Project

• Communication and phone etiquette
• Using AI tools for office work
• Interview preparation
• Final project: complete office file set
• Typing test, review and certificate