Microsoft Office

Course Details

  • Category: Microsoft Office
  • Basic Skill: Basic Computer
  • Course Duration: 2 Months

Microsoft Office Word allows you to create and edit personal and business documents, such as letters, reports, invoices, emails and books. By default, documents saved in Word are saved with the .docx extension. Microsoft Word can be used for the following purposes −

  • To create business documents having various graphics including pictures, charts, and diagrams.
  • To store and reuse readymade content and formatted elements such as cover pages and sidebars.
  • To create letters and letterheads for personal and business purpose.
  • To design different documents such as resumes or invitation cards etc.
  • To create a range of correspondence from a simple office memo to legal copies and reference documents.

    • Course Contents

    1. Basic concept of MS Word

    1.1 Introduction to Microsoft Office Word

    1.2 Word - Home

    1.3 Word - Getting Started

    1.4 Word - Explore Window

    1.5 Word - Backstage View

    1.6 Word - Entering Text

    1.7 Word - Move Around

    1.8 Word - Save Document

    1.9 Word - Opening a Document

    1.10 Word - Closing Document

    1.11 Context Help

    2. Editing Documents

    2.1 Word - Insert Text

    2.2 Word - Select Text

    2.3 Word - Delete Text

    2.4 Word - Move Text

    2.5 Word - Copy & Paste

    2.6 Word - Find & Replace

    2.7 Word - Spell Check

    2.8 Word - Zoom In-Out

    2.9 Word - Special Symbols

    2.10 Word - Undo Changes

    3. Formatting Text

    3.1 Word - Setting Text Fonts

    3.2 Word - Text Decoration

    3.3 Word - Change Text Case

    3.4 Word - Change Text Color

    3.5 Word - Text Alignments

    3.6 Word - Indent Paragraphs

    3.7 Word - Create Bullets

    3.8 Word - Set Line Spacing

    3.9 Word - Borders and Shades

    3.10 Word - Set Tabs

    3.11 Word - Apply Formatting

    4. Formatting Pages

    4.1 Word - Adjust Page Margins

    4.2 Word - Header and Footer

    4.3 Word - Add Page Numbers

    4.4 Word - Insert Page Breaks

    4.5 Word - Insert Blank Page

    4.6 Word - Cover Pages

    4.7 Word - Page Orientation

    5. Working with Tables

    5.1 Word - Create a Table

    5.2 Word - Rows & Columns

    5.3 Word - Move a Table

    5.4 Word - Resize a Tables

    5.5 Word - Merging Cells

    5.6 Word - Split a Table

    5.7 Word - Split Cells

    5.8 Word - Add Formula

    5.9 Word - Borders & Shades

    6. Advanced Operations

    6.1 Word - Quick Styles

    6.2 Word - Use Templates

    6.3 Word - Use Graphics

    6.4 Word - Auto Correction

    6.5 Word - Auto Formatting

    6.6 Word - Table of Contents

    6.7 Word - Preview Documents

    6.8 Word - Printing Documents

    6.9 Word - Email Documents

    6.10 Word - Translate Document

    6.11 Word - Compare Document

    6.12 Word - Document Security

    6.13 Word - Set Watermark

    7. Word Useful Resources

    7.1 Word - Quick Guide

    7.2 Word - Useful Resources

    7.4 Word - Discussion

    1. MS Excel Basics

    1.1 Excel - Home

    1.2 Excel - Getting Started

    1.3 Excel - Explore Window

    1.4 Excel - Backstage

    1.5 Excel - Entering Values

    1.6 Excel - Move Around

    1.7 Excel - Save Workbook

    1.8 Excel - Create Worksheet

    1.9 Excel - Copy Worksheet

    1.10 Excel - Hiding Worksheet

    1.11 Excel - Delete Worksheet

    1.12 Excel - Close Workbook

    1.13 Excel - Open Workbook

    1.14 Excel - Context Help

    2. Editing Worksheet

    2.1 Excel - Insert Data

    2.2 Excel - Select Data

    2.3 Excel - Delete Data

    2.4 Excel - Move Data

    2.5 Excel - Rows & Columns

    2.6 Excel - Copy & Paste

    2.7 Excel - Find & Replace

    2.8 Excel - Spell Check

    2.9 Excel - Zoom In-Out

    2.10 Excel - Special Symbols

    2.11 Excel - Insert Comments

    2.12 Excel - Add Text Box

    2.13 Excel - Undo Changes

    3. Formatting Cells

    3.1 Excel - Setting Cell Type

    3.2 Excel - Setting Fonts

    3.3 Excel - Text Decoration

    3.4 Excel - Rotate Cells

    3.5 Excel - Setting Colors

    3.6 Excel - Text Alignments

    3.7 Excel - Merge & Wra

    3.8 Excel - Borders and Shades

    3.9 Excel - Apply Formatting

    4. Formatting Worksheets

    4.1 Excel - Sheet Options

    4.2 Excel - Adjust Margins

    4.3 Excel - Page Orientation

    4.4 Excel - Header and Footer

    4.5 Excel - Insert Page Breaks

    4.6 Excel - Set Background

    4.7 Excel - Freeze Panes

    4.8 Excel - Conditional Format

    5. Working with Formula

    5.1 Excel - Creating Formulas

    5.2 Excel - Copying Formulas

    5.3 Excel - Formula Reference

    5.4 Excel - Using Functions

    5.5 Excel - Builtin Functions

    6. Advanced Operations

    6.1 Excel - Data Filtering

    6.2 Excel - Data Sorting

    6.3 Excel - Using Ranges

    6.4 Excel - Data Validation

    6.5 Excel - Using Styles

    6.6 Excel - Using Themes

    6.7 Excel - Using Templates

    6.8 Excel - Using Macros

    6.9 Excel - Adding Graphics

    6.10 Excel - Cross Referencing

    6.11 Excel - Printing Worksheets

    6.12 Excel - Email Workbooks

    6.13 Excel - Translate Worksheet

    6.14 Workbook Security

    6.15 Data Tables

    6.16 Pivot Tables

    6.17 Simple Charts

    6.18 Pivot Charts

    6.19 Keyboard Shortcuts

    1. MS Powerpoint Basics

    1.1 PPT - Home

    1.2 PPT - Getting Started

    1.3 PPT - Explore Window

    1.4 PPT - Backstage

    1.5 PPT - Create Presentation

    1.6 PPT - Add New Slides

    1.7 PPT - Adding Text in Boxes

    1.8 PPT - Adding New Text Boxes

    1.9 PPT - Deleting Existing Slide

    1.10 PPT - Rearranging Slides

    1.11 PPT - Adding Slide Notes

    1.12 PPT - Managing Sections

    1.13 PPT - Working with Outlines

    1.14 PPT - Powerpoint Sidebar

    1.15 PPT - Presentation Views

    1.16 PPT - Setting Backgrounds

    1.17 PPT - Slide Orientations

    1.18 PPT - Saving Presentation

    1.19 PPT - Review Presentation

    1.20 PPT - Adding Slide Numbers

    1.21 PPT - Adding Header & Footer

    1.22 PPT - Running Slide Show

    1.22 PPT - Keyboard Shortcuts

    1.23 PPT - Get Context Help

    2. Editing Presentation

    2.1 PPT - Copy & Paste Content

    2.2 PPT - Find & Replace Content

    2.3 PPT - Undo Edited Changes

    2.4 PPT - Spelling Check

    2.5 PPT - Content Translation

    2.6 PPT - Setting Language Type

    2.7 PPT - Duplicating Content

    2.8 PPT - Special Characters

    2.9 PPT - Slides Zoom In-Out

    2.10 PPT - Special Symbols

    3. Formatting Presentation

    3.1 PPT - Font Management

    3.2 PPT - Setting Text Fonts

    3.3 PPT - Text Decoration

    3.4 PPT - Change Text Case

    3.5 PPT - Change Text Size

    3.6 PPT - Change Text Color

    3.7 PPT - Text Alignments

    3.8 PPT - Indent Paragraphs

    3.9 PPT - Set Line Spacing

    3.10 PPT - Borders and Shades

    3.11 PPT - Apply Formatting

    3.12 PPT - Using Slide Master

    3.13 PPT - Save Design Template

    4. Working with Multimedia

    4.1 PPT - Add Pictures to Slide

    4.2 PPT - Editing Added Pictures

    4.3 PPT - Format Added Pictures

    4.4 PPT - Inserting a Screenshot

    4.5 PPT - Adding Shapes to Slide

    4.6 PPT - Editing Added Shapes

    4.7 PPT - Format Added Shapes

    4.8 PPT - Adding Text to Shapes

    4.9 PPT - Arrange Shapes/Images

    4.10 PPT - Group/Ungroup Objects

    4.11 PPT - Adding Audio & Video

    4.12 PPT - Add & Format Tables

    4.13 PPT - Add & Format Charts

    4.14 PPT - Add & Format SmartArt

    4.15 PPT - Add & Preview Animations

    4.16 PPT - Add & Preview Transitions

    5. Sharing Presentation

    5.1 PPT - Create a PDF File

    5.2 PPT - Create a Video File

    5.3 PPT - Create Image File

    5.4 PPT - Printing Presentation

    5.5 PPT - Broadcast Slide Show

    5.6 PPT - Packaging Presentation

    5.7 PPT - Setting Document Password

    5.8 PPT - Email Slide Show

    Basic Microsoft Office Word for practice

    1. Start with Basic MS Word

    • 1.1 Create a front page
    • 1.2 Write a resume of yourself
    • 1.3 Create a table of contents in word
    • 1.4 Use a chart in word

    1. Start with Basic MS Excel

    • 1.1 Excel electric bill calculator
    • 1.2 Attendance Tracking Excel Spreadsheet Project idea
    • 1.3 Daily Expense Tracking Microsoft Spreadsheet Project Ideas
    • 1.4 Event Registration Google SpreadSheet Project (Premium Project Idea)
    • 1.5 VBA to Consolidate data from multiple Excel Worksheets into a Single Sheet – By Row

    1. Start with Basic MS Powerpoint

    • 1.1 Make a Slide Show Presentation
    • 1.2 Make a video slide in powerpoint
    • 1.3 Make a video lecture using powerpoint
    • 1.4 Make a slide show of a text