Ms-office

📘 Microsoft Word – Syllabus

🔹 1. Home Tab

  • Clipboard
    • Cut, Copy, Paste, Format Painter
  • Font
    • Font type, size, bold, italic, underline
    • Font color, highlight, strikethrough
    • Superscript, subscript, text effects
  • Paragraph
    • Bullets, numbering, multilevel lists
    • Alignments (left, center, right, justify)
    • Line and paragraph spacing
    • Borders and shading
    • Increase/decrease indent
  • Styles
    • Applying, modifying, and creating styles
  • Editing
    • Find, Replace, Select

🔹 2. Insert Tab

  • Pages
    • Cover Page, Blank Page, Page Break
  • Tables
    • Insert, draw, convert text to table
  • Illustrations
    • Pictures, Online Pictures, Shapes, Icons, 3D Models, SmartArt, Chart, Screenshot
  • Add-ins (if enabled)
  • Links
    • Hyperlink, Bookmark, Cross-reference
  • Header & Footer
    • Header, Footer, Page Number
  • Text
    • Text Box, Quick Parts, WordArt, Drop Cap, Signature Line, Date & Time, Object
  • Symbols
    • Equation, Symbol

🔹 3. Design Tab

  • Document Formatting
    • Themes, Colors, Fonts, Paragraph Spacing, Effects
  • Page Background
    • Watermark, Page Color, Page Borders

🔹 4. Layout (or Page Layout) Tab

  • Page Setup
    • Margins, Orientation, Size, Columns, Breaks, Line Numbers, Hyphenation
  • Paragraph
    • Indent, Spacing
  • Arrange
    • Position, Wrap Text, Bring Forward, Send Backward, Align, Group, Rotate

🔹 5. References Tab

  • Table of Contents
  • Footnotes (Insert, Next, Show Notes)
  • Citations & Bibliography
    • Insert Citation, Manage Sources, Style, Bibliography
  • Captions
    • Insert Caption, Cross-reference
  • Index
    • Mark Entry, Insert Index
  • Table of Authorities

🔹 6. Mailings Tab

  • Create (Envelopes, Labels)
  • Start Mail Merge (Letters, Emails, Labels, etc.)
  • Select Recipients (Type New List, Use Existing List, Outlook Contacts)
  • Write & Insert Fields (Address Block, Greeting Line, Merge Fields)
  • Preview Results
  • Finish & Merge (Print, Email, etc.)

🔹 7. Review Tab

  • Proofing
    • Spelling & Grammar, Thesaurus, Word Count
  • Accessibility
  • Language (Translate, Set Language)
  • Comments (New, Delete, Next, Previous)
  • Tracking (Track Changes, Reviewing Pane)
  • Changes (Accept/Reject changes)
  • Compare & Combine Documents
  • Protect Document

🔹 8. View Tab

  • Views (Read Mode, Print Layout, Web Layout)
  • Show (Ruler, Gridlines, Navigation Pane)
  • Zoom (Zoom In/Out, One Page, Multiple Pages)
  • Window (New Window, Split, View Side by Side)
  • Macros (Record, View, Run Macros)

📊 Microsoft Excel – Syllabus

🔹 1. Home Tab

  • Clipboard
    • Cut, Copy, Paste, Format Painter
  • Font
    • Font formatting, Fill color, Borders
  • Alignment
    • Merge & Center, Orientation, Wrap Text, Indent
  • Number
    • Formatting (Currency, Date, Percentage, etc.)
  • Styles
    • Conditional Formatting, Format as Table, Cell Styles
  • Cells
    • Insert/Delete Rows & Columns, Format (row height, column width, visibility)
  • Editing
    • AutoSum, Fill, Clear, Sort & Filter, Find & Select

🔹 2. Insert Tab

  • Tables
    • Table, PivotTable
  • Illustrations
    • Pictures, Shapes, Icons, SmartArt, Screenshot
  • Charts
    • Column, Line, Pie, Bar, Area, Scatter, Combo
  • Sparklines
    • Line, Column, Win/Loss
  • Filters (Slicer, Timeline)
  • Text
    • Text Box, Header & Footer, WordArt, Object, Signature Line
  • Symbols
    • Equation, Symbol

🔹 3. Page Layout Tab

  • Themes
    • Themes, Colors, Fonts, Effects
  • Page Setup
    • Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles
  • Scale to Fit
    • Width, Height, Scale
  • Sheet Options
    • Gridlines (view/print), Headings
  • Arrange
    • Bring Forward, Send Backward, Align, Group, Rotate

🔹 4. Formulas Tab

  • Function Library
    • Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, More
  • Defined Names
    • Name Manager, Define Name
  • Formula Auditing
    • Trace Precedents/Dependents, Evaluate Formula, Error Checking
  • Calculation Options
    • Auto/Manual Calculation

🔹 5. Data Tab

  • Get & Transform (Power Query)
    • Get Data, Recent Sources, Combine Queries
  • Connections, Queries & Connections
  • Sort & Filter
  • Data Tools
    • Text to Columns, Flash Fill, Remove Duplicates, Data Validation, Consolidate
  • Forecast
    • Forecast Sheet, What-If Analysis (Goal Seek, Scenario Manager)
  • Outline
    • Group, Subtotal

🔹 6. Review Tab

  • Proofing
    • Spelling, Thesaurus, Translate
  • Accessibility
  • Comments
  • Notes
  • Protect Sheet/Workbook
  • Share Workbook (legacy)
  • Track Changes

🔹 7. View Tab

  • Workbook Views
    • Normal, Page Layout, Page Break Preview, Custom Views
  • Show
    • Ruler, Gridlines, Formula Bar, Headings
  • Zoom
    • Zoom controls
  • Window
    • New Window, Arrange, Freeze Panes, Split, Hide/Unhide

🎤 Microsoft PowerPoint – Syllabus

🔹 1. Home Tab

  • Clipboard
  • Slides
    • New Slide, Layout, Reset, Section
  • Font
    • All basic formatting tools
  • Paragraph
    • Bullets, Numbering, Alignment, Line Spacing
  • Drawing
    • Shapes, Arrange, Quick Styles
  • Editing

🔹 2. Insert Tab

  • Slides, Tables
  • Illustrations
    • Pictures, Icons, Shapes, SmartArt, Chart, Screenshot
  • Add-ins
  • Links
    • Link, Action
  • Text
    • Text Box, Header & Footer, WordArt, Date/Time, Slide Number, Object
  • Media
    • Video, Audio

🔹 3. Design Tab

  • Themes
    • Variants
  • Customize
    • Slide Size, Format Background

🔹 4. Transitions Tab

  • Transition Effects
  • Effect Options
  • Timing
    • Duration, Sound, Apply to All

🔹 5. Animations Tab

  • Animation Gallery
  • Add Animation
  • Animation Pane
  • Effect Options
  • Timing (Start, Duration, Delay)

🔹 6. Slide Show Tab

  • Start Slide Show
    • From Beginning, From Current Slide
  • Set Up
    • Custom Show, Set Up Slide Show
  • Monitors
    • Use Presenter View

🔹 7. Review Tab

  • Proofing
    • Spelling, Thesaurus
  • Accessibility
  • Comments
  • Ink

🔹 8. View Tab

  • Presentation Views
    • Normal, Outline, Slide Sorter, Notes Page, Reading View
  • Master Views
    • Slide Master, Handout Master, Notes Master
  • Show
    • Ruler, Gridlines, Guides
  • Zoom
  • Window
  • Macros
Scroll to Top