Ms Office Course and Syllabus
The MS Office course is a basic computer training program that teaches the use of essential Microsoft Office tools like MS Word, MS Excel, MS PowerPoint, and MS Outlook. The syllabus covers document creation, spreadsheet management, presentation design, and email handling, helping users build strong office productivity skills.
1. Introduction to MS Office
- Overview of MS Office Suite
- Versions of MS Office (2013, 2016, 2019, 2021, Office 365)
- Common Features in All Applications
- File Extensions and Saving Formats
2. Microsoft Word (Word Processing)
- Creating, Saving, Opening Documents
- Formatting Text, Paragraphs, and Pages
- Inserting Tables, Pictures, Shapes, and Charts
- Header, Footer, Page Numbers
- Mail Merge: Letters, Labels
- Reviewing Tools: Track Changes, Comments, Spell Check
3. Microsoft Excel (Spreadsheets)
- Understanding Rows, Columns, Cells
- Basic Formulas and Functions (SUM, AVERAGE, IF, etc.)
- Formatting Cells, Conditional Formatting
- Charts and Graphs
- Sorting, Filtering, and Tables
- Basic Data Analysis Tools (Pivot Tables)
- Using Templates
4. Microsoft PowerPoint (Presentations)
- Creating Slides and Presentations
- Using Themes and Layouts
- Adding Text, Images, Audio, and Video
- Slide Transitions and Animations
- Running and Customizing Slide Shows
5. Microsoft Outlook (Email & Scheduling)
- Introduction to Outlook Interface
- Sending and Receiving Emails
- Organizing Mail: Folders, Categories, Rules
- Contacts, Calendar, and Tasks
- Scheduling Meetings and Appointments
6. Microsoft Access (Optional - For Advanced Users)
- Introduction to Database Concepts
- Creating Tables, Queries, Forms, and Reports
- Relationships and Data Validation
7. Office Tools and Tips
- Using OneDrive for Cloud Storage
- Collaboration and Sharing Files
- Using Templates in Word, Excel, PowerPoint
- Keyboard Shortcuts for MS Office
Assessment and Practice
- Weekly Practice Assignments
- Final Project: Document, Spreadsheet and Presentation
- Certificate of Completion (online Test)