MS Office

📖

Course Outline

Month 01: MS Office & Essentials

Week 01: Computer Basics & Windows Setup ▶

• Introduction to Computer Hardware & Software
• Mastering Windows 10/11 & File Management
• Basic Troubleshooting & Keyboard Shortcuts

Week 02: Microsoft Word (Part 1) ▶

• Document Formatting & Professional Letter Writing
• Table Creation, Header/Footer & Page Layouts
• Working with Shapes, Images & SmartArt

Week 03: Microsoft Word (Advanced) ▶

• Mail Merge & Auto-Generation of Documents
• References, Citations & Table of Contents
• Converting PDF to Word & Document Security

Week 04: Typing Mastery & Speed ▶

• Touch Typing Techniques (English & Urdu)
• Improving Speed (WPM) & Accuracy
• Data Entry Best Practices

Month 02: MS Excel & PowerPoint

Week 05: Excel Basics & Data Entry ▶

• Rows, Columns & Cell Formatting
• Basic Formulas (SUM, AVERAGE, COUNT)
• Filtering & Sorting Large Data Sets

Week 06: Advanced Excel Formulas ▶

• VLOOKUP, HLOOKUP & IF Statements
• Pivot Tables & Charts for Data Reporting
• Data Validation & Conditional Formatting

Week 07: PowerPoint Presentations ▶

• Creating Engaging Slides & Templates
• Animation & Slide Transitions Mastery
• Business Presentation Skills & Pro Tips

Week 08: Outlook & Email Communication ▶

• Professional Email Writing & Etiquettes
• Setting up Outlook, Signatures & Folders
• Managing Calendars & Meeting Scheduling

Month 03: Online Tools & Management

Week 09: Google Workspace Tools ▶

• Working with Google Docs & Sheets (Online Collaboration)
• Google Drive Management & File Sharing
• Creating Professional Google Forms & Surveys

Week 10: Internet Security & Office Tools ▶

• Safe Browsing, Password Managers & Antivirus
• Online Meetings (Zoom, Google Meet, Teams)
• Basic Image Editing for Social Media & Office Posts

Week 11: Office Ethics & Soft Skills ▶

• Effective Communication & Time Management
• Office File Systems & Record Keeping
• Professional CV/Resume Design & Interview Tips

Week 12: Capstone Project & Assessment ▶

• Final Project: Complete Business Proposal Design
• Excel Advanced Data Analysis Test
• Final Viva, Certification & Job Placement Guide