CERTIFICATE IN OFFICE AUTOMATION & DATA MANAGEMENT (ADVANCE) ( M-MS PACKAGE-102 )

Module 1: MS Word Advance

• Advanced Table Designs

• Advanced Mail Merge (Labels, Letters, Envelopes)

• Table of Contents & Index Creation

• Section Breaks, Headers & Footers

• Review Tools (Track Changes, Comments, Compare Documents)

• Protection & Security in Word Files

• Advanced Printing & PDF Export

Module 2: MS Excel Advance

• Logical Functions (IF, AND, OR, IFERROR)

• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH)

• Data Validation & Conditional Formatting

• Pivot Tables & Pivot Charts

• Advanced Charting Techniques

• Data Cleaning Tools (Text to Columns, Remove Duplicates)

• Protecting Worksheets, Password Protection

• Working with Templates

Module 3: MS PowerPoint Advance

• Custom Animation Paths

• Advanced Slide Master Usage

• Hyperlinks & Action Buttons

• Multimedia Integration (Videos, Audio)

• Interactive Presentations

• Advanced Transition & Timings

• Designing Professional Presentations

Module 4: Data Management & Cloud Integration

• Google Workspace Introduction

• MS OneDrive Integration

• Sharing & Collaborating on Cloud

• Real-time Collaboration Tools

• File Backup & Security

Module 5: Project Work

• Complete Office Project:

  • Document Report (Word)

  • Financial Report (Excel)

  • Business Presentation (PowerPoint)