🧩 COURSE SYLLABUS (MODULE-WISE)

🔹 Module 1: Advanced Computer & Office Environment

• Advanced file and folder management
• Data storage, backup, and security basics
• Office workflow and digital documentation
• Keyboard shortcuts for productivity

🔹 Module 2: Advanced MS Word

• Advanced document formatting and styles
• Headers, footers, watermarks, and page layouts
• Tables, templates, and forms creation
• Table of contents and indexing
• Mail merge (letters, notices, certificates)
• Professional reports and official documents

🔹 Module 3: Advanced MS Excel – Data Management

• Advanced formulas and functions
• (IF, Nested IF, VLOOKUP, HLOOKUP, XLOOKUP, COUNTIF, SUMIF)
• Data validation and conditional formatting
• Pivot tables and pivot charts
• Advanced charts and dashboards
• Data analysis for MIS reports
• Attendance, payroll, inventory, and performance sheets
• Data cleaning and organization

🔹 Module 4: MS PowerPoint – Professional Presentations

• Advanced slide design and layouts
• SmartArt, charts, and infographics
• Animations and transitions
• Corporate, business, and client presentations
• Presentation delivery techniques

🔹 Module 5: Data Management Concepts & Tools

• Data organization and structuring
• Introduction to databases (MS Access – basics)
• Data accuracy, validation, and security
• Data reporting standards
• Introduction to cloud-based data storage

🔹 Module 6: Internet, Email & Digital Collaboration

• Professional email writing and management
• Online forms and surveys
• Google Workspace tools (Docs, Sheets, Drive)
• File sharing and collaboration tools

🔹 Module 7: MIS & Office Reporting

• Management Information System (MIS) basics
• Daily, weekly, and monthly reports
• Data presentation for management decisions
• Office documentation standards

🔹 Module 8: Employability & Professional Skills

• Business communication skills
• Resume and email etiquette
• Interview preparation
• Workplace ethics and time management