Microsoft Office Suite Comprehensive Syllabus

Module

Topics

Subtopics

Introduction

Overview of MS Word

• Introduction to MS Word
• Document Types and Templates
• Uses and Applications

Interface

• MS Word Interface
• Ribbon, Tabs, Groups
• Quick Access Toolbar
• Status Bar
• View Options

Getting Started

• Creating
• Opening
• Saving
• Saving As
• Using Templates

Basic Editing

Typing and Editing Text

• Typing
• Deleting Text
• Selecting Text
• Inserting
• Overwriting Text

Basic Commands

• Cut, Copy, Paste
• Undo, Redo
• Find, Replace
• Using the Clipboard

Formatting

Font Formatting

• Changing Font Type
• Size, Color, Applying Bold
• Italics, Underline
• Subscript, Superscript
• Strikethrough, Highlight

Paragraph Formatting

• Aligning Text
• Indents, Spacing
• Line and Paragraph Spacing
• Borders, Shading

Page Layout

• Margins
• Page Orientation
• Paper Size
• Columns

Working with Styles

Using Predefined Styles

• Applying Quick Styles
• Modifying Existing Styles

Creating Custom Styles

• Creating a New Style
• Saving, Managing Styles, Style Sets
• Themes

Working with Tables

Inserting Tables

• Creating Tables
• Converting Text to Tables
• Using Table Templates

Formatting Tables

• Adding, Deleting Rows, Columns
• Merging, Splitting Cells
• Applying Table Styles

Table Design

• Adjusting Table Size
• Position, Borders, Shading
• Sorting, Filtering Table Data

Inserting Graphics

Inserting Images

• Adding Pictures from File, Using Online Pictures, Screenshot, Screen Clipping

Formatting Images

• Resizing, Cropping
• Applying Picture Styles, Effects
• Wrapping Text

Inserting Shapes

• Drawing Shapes
• Formatting Shapes (Fill, Outline, Effects)
• Grouping, Aligning Shapes

Working with Lists

Creating Lists

• Bulleted Lists
• Numbered Lists
• Multilevel Lists

Customising Lists

• Modifying Bullet
• Number Styles, Changing List Levels
• Using Symbols, Pictures as Bullets

References and Citations

Footnotes and Endnotes

• Inserting
• Formatting Footnotes, Endnotes

Bibliography and Citations

• Adding Citations
• Creating Bibliography
• Managing Sources

Reviewing and Proofing

Proofing Tools

• Spelling, Grammar Check
• Thesaurus, Word Count

Track Changes

• Turning On/Off
• Accepting & Rejecting Changes
• Using Comments

Comparing Documents

• Comparing
• Combining Revisions

Preparing and Printing Documents

Page Setup

• Page Layout
• Headers & Footers
• Page Numbering

Printing

• Print Preview
• Print Options
• Printing Documents

Advanced Features

Mail Merge

• Setting Up Mail Merge
• Using for Letters, Labels, Envelopes
• Automate the process of creating personalised documents like letters and labels.

Macros

• Recording, Running, and Editing Macros
• Automate repetitive tasks by recording and running macros.

Forms

• Creating Forms
• Using Form Controls (Text Box, Check Box, Dropdown)
• Protecting & Distributing Forms

Templates

• Use and customize pre-designed templates for various document types.

Advanced Layout

• Control text flow and use sections, columns, and text boxes for complex layouts.

Module

Topics

Subtopics

Beginner

Introduction

Overview of MS Excel

• Introduction to MS Excel
• Workbook Types, Uses and Applications

Interface

• MS Excel Interface
• Ribbon, Tabs, Groups
• Quick Access Toolbar
• Status Bar

Getting Started

• Creating, Opening, Saving Workbooks
• Using Templates

Basic Editing

Entering and Editing Data

• Typing, Deleting Data
• Selecting Cells

Basic Commands

• Cut, Copy, Paste
• Undo, Redo
• Find & Replace
• Using the Clipboard

Formatting

Cell Formatting

• Font Styles
• Number Formats
• Borders
• Shading

Worksheet Formatting

• Row Height
• Column Width
• Hiding/Unhiding
• Merging Cells

Formulas and Functions

Basic Formulas

• SUM
• AVERAGE
• MIN & MAX

Common Functions

• IF
• VLOOKUP
• HLOOKUP
• COUNT & COUNTA
• SUMIF
• AVERAGEIF

Date and Time Functions

TODAY, NOW, DATE, TIME

Text Functions

CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM

Logical Functions

AND, OR, NOT

Lookup and Reference Functions

LOOKUP, INDEX, MATCH

Reviewing and Sharing

Comments and Notes

Adding, Editing, Deleting Comments

Protecting Workbooks and Worksheets

Password Protection, Allowing Specific Actions

Sharing Workbooks

Track Changes, Merging Workbooks

Advanced Chart Features

• Combo Charts
• Sparklines
• Trendlines

Intermediate 

Data Tools

Sorting and Filtering

• Sorting Data
• Multi-level Sorting
• Filtering Data

Data Validation

• Setting Data Validation Rules
• Input Messages
• Error Alerts

Consolidating Data

• Using Consolidate Tool
• Linking Data from Multiple Sheets

Text to Columns

• Splitting Data into Columns
• Using Delimiters

Remove Duplicates

• Identifying and Removing Duplicate Data

Tables and Ranges

Creating Tables

• Inserting Tables, Table Styles
• Adding and Deleting Rows/Columns

Working with Ranges

Naming Ranges, Using Named Ranges in Formulas

PivotTables

Creating PivotTables

Inserting PivotTables, Selecting Data Sources, Layout Options

Analyzing Data with PivotTables

Filtering, Sorting, Grouping Data

PivotCharts

Creating PivotCharts, Formatting PivotCharts

Conditional Formatting

Applying Conditional Formatting

Highlight Cell Rules, Top/Bottom Rules, Data Bars, Color Scales, Icon Sets

Custom Conditional Formatting

Using Formulas for Conditional Formatting

Advanced

Data Analysis

What-If Analysis

Scenario Manager, Goal Seek, Data Tables

Data Analysis Tools

Descriptive Statistics, Histogram, Regression, ANOVA

Macros

Basics of Macros

• Understanding what a macro is and its benefits
• Recording and running macros
• Introduction to VBA (Visual Basic for Applications)
• VBA code structure and syntax
• Working with variables, data types, and operators
• Using control flow statements (if, then, else, loops)

Object Model

• Understanding the Excel object model
• Working with objects, properties, and methods
• Accessing and manipulating Excel objects (workbook, worksheet, range, etc.)

Common Macro Tasks

• Data manipulation (formatting, sorting, filtering)
• Automating repetitive tasks
• Creating custom functions
• Interacting with other applications
• Identifying and handling errors in macros

Printing and Page Setup

Page Setup

Setting Print Area, Page Orientation, Margins, Scaling

Printing

Print Preview, Print Titles, Printing Selections

Advanced Features

Advanced Functions

Array Formulas, Dynamic Arrays, INDIRECT, OFFSET

Data Import and Export

Importing Data from Text Files, Databases, Web, Exporting Data

Category

Feature

Description

Introduction

PowerPoint Overview

• Understanding PowerPoint's role in creating presentations. 
• Overview of key features 
• Introduction to presentation design principles.

Interface Navigation

• Navigating the ribbon, toolbars, and menus.
• Customising the Quick Access Toolbar for efficiency. 
• Understanding the slide pane and notes pane.

Creating a New Presentation

• Steps to start a new presentation from scratch or template. 
• Saving and naming presentations. 
• Setting up the slide size and orientation.

Basic Presentation Skills

Adding and Formatting Text

• Inserting text boxes and placing text.
• Applying text formatting: font, size, colour, and style.
• Using bullet points and numbered lists for the organisation.

Inserting and Managing Slides

• Adding new slides and choosing slide layouts.
• Organising slides by rearranging and deleting.
• Duplicating slides to maintain consistency.

Using Themes and Templates

• Applying built-in themes for a cohesive look.
• Customising templates to match branding. 
• Saving custom themes for future use.

Working with Objects

Inserting Images, Shapes, and Icons

• Adding and resizing images.
• Drawing and formatting shapes. 
• Using icons and symbols to enhance visual appeal.

Working with SmartArt

• Creating SmartArt for structured diagrams. 
• Formatting and customising SmartArt graphics.
• Converting bullet points to SmartArt for clarity.

Using Tables and Charts

• Inserting tables and customising their appearance.
• Creating charts to visualise data. 
• Formatting chart elements for better readability.

Design and Layout

Slide Layouts

• Choosing appropriate slide layouts for content.
• Modifying layouts to fit presentation needs.
• Using placeholders effectively.

Applying Backgrounds

• Adding solid colour, gradient, or image backgrounds.
• Adjusting transparency and positioning of backgrounds.
• Removing backgrounds from images.

Using Slide Masters

• Creating and modifying slide masters for consistency.
• Applying slide master changes to all slides. Managing multiple slide masters.

Customizing Slide Designs

• Using design ideas and suggestions. 
• Customising colours, fonts, and effects. 
• Applying consistent branding elements.

Multimedia Integration

Adding Audio and Video

• Inserting audio clips and background music. 
• Adding video files and controlling playback. 
• Editing multimedia within PowerPoint.

Recording Narrations

• Recording slide-by-slide narrations. 
• Syncing audio with slide content. 
• Saving narrations for future use.

Inserting and Managing Hyperlinks

• Creating hyperlinks to other slides, documents, or websites. 
• Formatting and editing hyperlink appearance. 
• Managing broken links.

Animations and Transitions

Applying Animations to Objects

• Adding entrance, emphasis, and exit animations.
• Customising animation paths and effects.
• Setting trigger events for animations.

Using Transition Effects

• Applying transitions between slides. 
• Customising transition duration and direction.
• Using subtle transitions for professional presentations.

Customizing Animation Timing and Order

• Managing the animation timeline. 
• Reordering animations for logical flow.
• Adjusting animation timing for smooth transitions.

Advanced Slide Techniques

Creating Interactive Slides

• Adding interactive elements like hyperlinks and buttons. 
• Creating non-linear navigation paths.
• Designing quizzes and interactive assessments.

Using Action Buttons

• Inserting action buttons for navigation and interaction. 
• Customising button actions and appearance. 
• Linking buttons to slides, files, or URLs.

Slide Zoom and Morph Transitions

• Using Slide Zoom for dynamic navigation.
• Applying Morph transition for seamless animations. 
• Creating advanced visual effects with Morph.

Collaboration and Sharing

Collaborating with Others

• Sharing presentations with colleagues.
• Co-authoring and editing presentations in real-time.
• Managing version history and changes.

Reviewing and Adding Comments

• Adding and replying to comments.
• Managing comment threads and resolving issues.
• Using the preview pane for efficient collaboration.

Sharing and Exporting Presentations

• Exporting presentations in various formats (PDF, video, etc.).
• Sharing presentations via email or cloud services. 
• Protecting presentations with passwords.

Presentation Delivery

Setting Up Slide Shows

• Configuring slide show settings (loop, timings, etc.).
• Setting up custom slide shows for different audiences. 
• Practising delivery with rehearsal tools.

Using Presenter View

• Utilizing Presenter View for speaker notes and slide previews. 
• Managing slide timings and annotations.
• Switching between slides seamlessly.

Rehearsing Timings

• Practicing presentations with timing rehearsals.
• Adjusting slide timings based on rehearsal feedback.
• Saving rehearsed timings for live presentation.

Creating Custom Shows

• Creating tailored slide shows for different purposes.
• Managing multiple custom shows within one presentation. 
• Switching between custom shows during delivery.

Advanced Features

Using Slide Sections

• Organising slides into sections for better management. 
• Collapsing and expanding sections for easy navigation. 
• Renaming and rearranging sections.

Embedding Excel Data

• Integrating Excel charts and data into slides.
• Linking Excel data for automatic updates.
• Formatting embedded Excel content for consistency.

Importing Content from Word

• Importing and formatting Word document content.
• Linking Word outlines to PowerPoint slides. 
• Managing imported content for consistency.

Using PowerPoint Add-ins

• Enhancing functionality with PowerPoint add-ins.
• Installing and managing add-ins. 
• Exploring popular add-ins for productivity.

Presentation Tips and Best Practices

Designing Effective Slides

• Principles of good slide design. 
• Using visual aids effectively. 
• Avoiding common design mistakes.

Presentation Techniques

• Effective public speaking tips.
• Engaging the audience with interactive elements.
• Using body language and voice effectively.

Avoiding Common Mistakes

• Identifying and correcting common presentation errors.
• Ensuring technical setup is reliable. 
• Preparing for potential issues during delivery.

Final Project

Creating a Comprehensive Presentation

• Applying all learned skills in a final project. 
• Designing a presentation from start to finish.
• Incorporating feedback and making revisions.

Peer Review and Feedback

• Reviewing peer presentations and providing constructive feedback.
• Receiving feedback on your presentation. 
• Finalising the presentation based on reviews.