MS OFFICE

MS OFFICE

Module 1: MS Word

• Basics:
  • Introduction to MS Word
  • Creating, saving, and opening documents
  • Text formatting (font, size, color, style)
  • Paragraph formatting (alignment, line spacing, indentation)
  • Bullet points and numbering
  • Working with tables
  • Page layout and design
• Intermediate:
  • Headers, footers, and page numbers
  • Insert images, shapes, and WordArt
  • Mail merge (letters, labels)
  • Using templates
• Advanced:
  • Track changes and comments
  • Creating and formatting tables of contents
  • Adding references (footnotes, endnotes, citations)
  • Document protection and security

Module 2: MS Excel

• Basics:
  • Introduction to Excel
  • Workbook and worksheet management
  • Data entry and formatting
  • Basic formulas and functions (SUM, AVERAGE, MIN, MAX)
  • Cell references (absolute, relative, mixed)
• Intermediate:
  • Data sorting and filtering
  • Charts and graphs (bar, line, pie, etc.)
  • Conditional formatting
  • Pivot tables and Pivot charts
• Advanced:
  • Advanced functions (IF, VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Data validation
  • Macros and automation basics
  • Advanced charting techniques

Module 3: MS PowerPoint

• Basics:
  • Creating a new presentation
  • Adding slides and layouts
  • Formatting text and images
  • Slide transitions and animations
• Intermediate:
  • Working with SmartArt and charts
  • Using multimedia (audio, video)
  • Slide master and templates
• Advanced:
  • Custom slide shows
  • Hyperlinks and action buttons
  • Presentation rehearsal and timing
  • Collaboration and sharing