Course Syllabus
Standard Syllabus Breakdown
Module 1: Fundamentals of Office Management
- Introduction to modern office administration and management.
- Roles, duties, and daily workflow optimization for office managers.
- Time management, workplace organization, and calendar scheduling.
- Inventory control, handling office supplies, and asset record-keeping.
Module 2: Business Communication & Correspondence
- Principles of professional verbal and written workplace communication.
- Drafting official business letters, memos, and formal reports.
- Professional email etiquette and telephone handling procedures.
- Meeting coordination, agenda preparation, and minute-taking.
Module 3: Office Technology & Administrative IT Skills
- Introduction to operating systems and digital filing structures.
- Essential word processing (MS Word) for drafting certificates and documents.
- Managing digital correspondence, Google Drive, and cloud tools.
Module 4: Basic Excel Refresher
- Interface overview, data entry, custom cell formatting, and basic tables.
- Essential mathematical and logical formulas (
SUM, AVERAGE, COUNT, IF). - Text manipulation tools like
TRIM and CONCATENATE.
Module 5: Advanced Excel for MIS & Reporting
- Advanced lookup functions (
VLOOKUP, HLOOKUP, INDEX-MATCH). - Data analysis using Pivot Tables, Pivot Charts, and Slicers.
- Data validation, conditional formatting, and sorting/filtering large sheets.
- Introduction to macros, automation basics, and dynamic dashboard creation
Bestseller
