MS Office

• Introduction to computers
• Operating system basics (Windows)
• File and folder management
• Introduction to MS Office suite
• MS Office interface and tools
• Keyboard shortcuts and productivity basics

• MS Word interface and ribbon
• Creating, opening, and saving documents
• Text formatting tools
• Paragraph formatting
• Page setup and margins
• Bullets and numbering
• Basic shortcuts in Word

• Styles and themes
• Headers and footers
• Page numbers
• Tables creation and formatting
• Images, shapes, and icons
• Find and replace
• Spelling and grammar tools

• Advanced table formatting
• Mail merge (letters, labels, envelopes)
• Track changes and comments
• Document protection
• Templates and professional documents
• Resume and report formatting
• Exporting and sharing documents

• Excel interface and workbook structure
• Cells, rows, and columns
• Data entry and formatting
• Basic formulas
• AutoFill and Flash Fill
• Basic charts
• Page layout and printing

• Mathematical and statistical functions
• Logical functions (IF, AND, OR)
• Text and date functions
• Sorting and filtering data
• Conditional formatting
• Data validation
• Working with multiple sheets

• Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Pivot tables
• Pivot charts
• Advanced chart formatting
• Named ranges
• What-if analysis
• Error handling formulas

• Dashboard creation
• Business reports in Excel
• Financial and sales analysis
• Advanced Pivot table features
• Importing external data
• Protecting sheets and workbooks
• Excel productivity shortcuts

• PowerPoint interface
• Slide creation and layouts
• Text and image insertion
• Themes and templates
• Slide transitions
• Basic animations
• Presentation views

• Slide master
• Custom layouts
• Advanced animations
• Charts and SmartArt
• Multimedia integration
• Professional presentation design
• Presentation delivery techniques

• Outlook interface
• Email creation and management
• Calendar and scheduling
• Contacts and tasks
• Email rules and filters
• MS Office integration
• Time and task management tools

• Office automation basics
• Real-world business documents
• Data management workflow
• Professional formatting standards
• Collaboration using MS Office
• Office etiquette and best practices
• Interview-oriented MS Office tasks
• Final project and assessment