Office Productivity Tools – Syllabus

Office Productivity Tools – Syllabus

Module 1: Computer & Operating System Basics
Introduction to computers, input/output devices, understanding Windows/Linux interface, file & folder management, shortcut keys, control panel settings, system utilities, software installation/removal, update management, and secure system handling.
Module 2: MS Word / Google Docs – Document Creation & Formatting
Creating and editing documents, formatting text & paragraphs, page setup, margins, headers/footers, tables, images, shapes, styles, templates, bullets & numbering, smart arts, mail merge, report creation, resume formatting & professional documentation.
Module 3: MS Excel / Google Sheets – Data Handling & Analysis
Basic to advanced formulas, cell formatting, data validation, sorting & filtering, conditional formatting, charts & graphs, pivot tables, lookup functions, sheet protection, macros introduction, business reports, financial sheets, and Excel automation basics.
Module 4: MS PowerPoint / Google Slides – Presentation Creation
Slide design principles, themes & templates, transitions & animations, multimedia slides, charts & tables inside slides, business presentation skills, pitch deck creation, branding slides, interactive slides, delivering presentations confidently.
Module 5: Email & Online Communication Tools
Creating a professional email account, email writing etiquette, subject line importance, CC/BCC usage, attachments, cloud attachments, email security, spam identification, Gmail & Outlook features, calendar scheduling, meeting invitations.
Module 6: Productivity & Collaboration Tools
Google Drive cloud storage, file sharing permissions, Google Calendar planning, Google Keep notes, Zoom & Google Meet usage, collaborative document editing, Trello/Notion basics, task management techniques, real-time team collaboration.
Module 7: Office Professional Skills
Digital communication etiquette, using templates for office tasks, maintaining spreadsheets for attendance/payroll, creating business reports, preparing office letters, documentation workflow, data entry accuracy, printing & PDF creation.