Module 1: Computer Fundamentals

• Introduction to Computers
• Hardware and Software Concepts
• Operating System Basics
• File and Folder Management
• Keyboard Shortcuts
• Internet and Email Basics
• Data Security and Backup

Module 2: Microsoft Word

Introduction to MS Word

• Word Interface and Navigation
• Creating, Saving, and Opening Documents
• Formatting Text and Paragraphs
• Page Setup and Layout

Advanced Word

• Headers, Footers, and Page Numbers
• Tables and Table Formatting
• Images, Shapes, and SmartArt
• Mail Merge
• Find and Replace
• Hyperlinks and Bookmarks
• Document Review and Track Changes
• Printing and PDF Creation

Module 3: Microsoft Excel

Excel Fundamentals

• Excel Interface
• Workbook and Worksheet Management
• Data Entry and Formatting
• Rows, Columns, and Cells

Formulas and Functions

• Basic Formulas
• AutoSum
• Mathematical Functions
• Logical Functions (IF, AND, OR)
• Date and Time Functions
• Text Functions

Advanced Excel

• Sorting and Filtering
• Conditional Formatting
• Data Validation
• Charts and Graphs
• Pivot Tables
• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Dashboard Basics
• Data Analysis Tools
• Printing and Report Generation

Module 4: Microsoft PowerPoint

PowerPoint Basics

• Creating Presentations
• Slide Layouts and Themes
• Text Formatting
• Inserting Images and Icons

Advanced PowerPoint

• SmartArt and Charts
• Audio and Video Integration
• Animations and Transitions
• Slide Master
• Presentation Views
• Hyperlinks and Action Buttons
• Presentation Delivery Techniques
• Exporting to PDF and Video

Module 5: Microsoft Outlook

• Introduction to Outlook
• Email Configuration
• Sending and Receiving Emails
• Email Formatting
• Attachments Management
• Calendar and Meeting Scheduling
• Contacts Management
• Tasks and Notes
• Email Rules and Filters

Module 6: Microsoft Access

• Introduction to Database Concepts
• Access Interface
• Creating Databases
• Tables and Relationships
• Queries
• Forms
• Reports
• Data Import and Export
• Database Security

Module 7: Microsoft OneNote

• Introduction to OneNote
• Creating Notebooks and Sections
• Notes Management
• Adding Images and Files
• Sharing Notes
• Collaboration Features

Module 8: Microsoft Teams

• Introduction to Teams
• Creating Teams and Channels
• Chat and Collaboration
• File Sharing
• Online Meetings
• Screen Sharing
• Team Management

Module 9: Cloud & Productivity Tools

• Introduction to Microsoft 365
• OneDrive Basics
• Online Collaboration
• Document Sharing
• Real-Time Editing
• Cloud Storage Management

Module 10: Project & Practical Assignments

Word Project

• Create Professional Resume
• Business Letter
• Invoice Design

Excel Project

• Sales Report
• Payroll Sheet
• Inventory Management
• Dashboard Creation

PowerPoint Project

• Company Presentation
• Product Presentation
• Training Presentation

Outlook & Teams Project

• Professional Email Communication
• Online Meeting Management

Module 11: Interview & Job Readiness

• Microsoft Office Practical Assessment
• Business Documentation Skills
• Corporate Email Writing
• Report Preparation
• Presentation Skills
• Interview Preparation
• Office Productivity Best Practices

Course Duration

• Basic Course: 3 Months
• Advanced Course: 3 months
• Project Work: 10 Hour

Certification

• Microsoft Office Professional Certification
• Course Completion Certificate
• Practical Project Certificate

HINDI AND ENGLSH TYPING