Duration: 10 Weeks Total Fee- ₹4500/-
| Course Name | MS Office Professional Courses |
| Duration | 10 Weeks – 12 Weeks |
| Total Fee | 4500 |
| Admission Fee | 300 |
| Do you Provide a Certificate | Yes |
Week 1: Introduction to Computers
- Day 1:
- Definition, History, and Types of Computers
- Basic Components and Functions
- Day 2:
- Introduction to Operating Systems (Windows, macOS, Linux)
- Basic Operations: Booting, Logging In/Out, Shutdown
- Day 3:
- File Management: Creating, Saving, Deleting, Organizing Files and Folders
- Day 4:
- Basic Internet Usage: Browsers, Search Engines, Email Basics
- Day 5:
- Review and Practical Exercises
Week 2: Microsoft Word (Part 1)
- Day 1:
- Introduction to MS Word Interface: Ribbon, Toolbar, Menus
- Creating and Saving Documents
- Day 2:
- Formatting Text: Font Styles, Sizes, Colors, Alignment
- Paragraph Formatting: Indents, Spacing, Bullets, Numbering
- Day 3:
- Working with Tables: Inserting, Modifying, Formatting
- Day 4:
- Inserting Graphics and Objects: Pictures, Shapes, Text Boxes
- Day 5:
- Practical Exercises and Review
Week 3: Microsoft Word (Part 2)
- Day 1:
- Page Layout: Margins, Orientation, Size
- Day 2:
- Headers, Footers, and Page Numbers
- Day 3:
- Using Templates and Styles for Consistent Formatting
- Day 4:
- Advanced Features: Mail Merge, Track Changes, Comments
- Day 5:
- Review and Practical Exercises
Week 4: Microsoft Excel – Formulas and Practical Applications
- Day 1:
- Introduction to Excel Formulas and Functions: SUM, AVERAGE, MIN, MAX, RANK, COUNT, COUNTIF, SUMIF, POWER, SQRT
- Day 2:
- Logical Functions: IF, AND, OR, NOT
- Lookup Functions: VLOOKUP, HLOOKUP
- Day 3:
- Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM
- Date Functions: TODAY, NOW, DATE, DATEDIF, EOMONTH
- Day 4:
- Creating a Salary Sheet: Calculating Gross and Net Salary, Deductions, Taxes
- Using Formulas for Automatic Calculations
- Day 5:
- Creating a Product Table: Inventory Management, Sales Tracking, Price Calculations
- Applying Conditional Formatting and Data Validation
Week 5: Microsoft Excel (Part 2)
- Day 1:
- Sorting and Filtering Data
- Day 2:
- Advanced Formulas: IF, VLOOKUP, HLOOKUP, COUNTIF
- Day 3:
- Conditional Formatting
- Day 4:
- PivotTables and PivotCharts
- Day 5:
- Review and Practical Exercises
Week 6: Microsoft PowerPoint (Part 1)
- Day 1:
- Introduction to MS PowerPoint Interface: Slides, Layouts, Themes
- Creating a Basic Presentation: Adding Slides, Choosing Layouts
- Day 2:
- Working with Text: Adding, Formatting, Aligning
- Day 3:
- Inserting Images, Videos, and Other Media
- Day 4:
- Designing Slides: Themes, Backgrounds, Slide Transitions
- Day 5:
- Practical Exercises and Review
Week 7: Microsoft PowerPoint (Part 2)
- Day 1:
- Animations: Applying and Customizing
- Day 2:
- Slide Show: Setting Up and Running a Presentation
- Day 3:
- Tips for Effective Presentations
- Day 4:
- Creating Interactive Presentations: Hyperlinks, Action Buttons
- Day 5:
- Review and Practical Exercises
Week 8: Integration and Project Work (Part 1)
- Day 1:
- Integrating MS Office Applications: Linking Word, Excel, and PowerPoint
- Using Data from Excel in Word and PowerPoint
- Day 2:
- Project Work: Creating a Document with Embedded Excel Data
- Day 3:
- Project Work: Preparing a Presentation with Charts and Tables from Excel
- Day 4:
- Review and Feedback on Projects
- Day 5:
- Practical Integration Exercises
Week 9: Advanced Topics and Specialized Skills
- Day 1:
- Advanced MS Word Features: Macros, Advanced Styles, and Forms
- Day 2:
- Advanced MS Excel Features: Data Analysis Tools, Solver, and Scenarios
- Day 3:
- Advanced MS PowerPoint Features: Custom Shows, Recording Narrations
- Day 4:
- Working with Online and Cloud-based Versions of MS Office
- Day 5:
- Practical Exercises and Review
Week 10: Final Projects and Course Review
- Day 1:
- Final Project Work: Integrating Skills from MS Word, Excel, and PowerPoint
- Day 2:
- Final Project Work: Continued Development and Refinement
- Day 3:
- Final Project Presentations and Peer Reviews
- Day 4:
- Final Project Presentations and Instructor Feedback
- Day 5:
- Course Review, Q&A, and Certification Ceremony
Additional Resources:
- Practice Exercises: Regular assignments and practical tasks to reinforce learning.
- Supplementary Materials: Handouts, cheat sheets, and video tutorials.
- Assessment: Quizzes and practical tests to gauge understanding and progress
- Typing: Free English Typing Course