VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Microsoft Office (Word, Excel & PowerPoint)

Course Description

UTAP Funding
Funding available for this course

We use MS Word, MS Excel and MS PowerPoint on day to day basis. This is a fundamental course which covers fonts and formats, creating a table and few other basic functions. Besides that, formulas can be used for sorting a table or formatting. It also helps the people to use the various layouts, do slide formatting, provide special effects or select customized designs of templates for their presentation.

Course Objective

Participant will be able to pick up on the Microsoft Excel, Word & PowerPoint which are simple office productivity tools from Microsoft.

Training Methodologies

  • Training is hands-on using easy-to-follow step-by-step instructions.
  • Instructor-Led Training (ILT) on live exercises of each topic.

Trainer

Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.
 

Course Content

Microsoft Word

Lesson 1: Getting Started with Microsoft Word

  • Explore the User Interface and the Ribbon
  • Quick Access Toolbar
  • Creating Documents

Lesson 2: Editing Documents

  • Selecting Text
  • Deleting Text
  • Moving and Copying Text
  • Undoing and Redoing Changes
  • Finding and Replacing Text

Lesson 3: Formatting Documents

  • Formatting Text
  • Changing the Font and Font Size
  • Changing the Font Color and Highlighting Text
  • Applying Font Styles and Effects
  • Clearing Formatting
  • Copying Formatting
  • Formatting Paragraphs
  • Changing Paragraph Alignment
  • Changing Line and Paragraph Spacing
  • Changing Paragraph Indentation
  • Setting Tab Stops
  • Adding Borders and Shading
  • Creating Bulleted and Numbered Lists
  • Applying Styles
  • Formatting Headings

Lesson 4: Working with Tables

  • Inserting Tables
  • Navigating Tables
  • Selecting Table Parts
  • Adding Borders and Shading
  • Inserting Rows and Columns
  • Resizing Rows and Columns

Lesson 5: Working with Headers and Footers

  • Insert Headers and Footers
  • Insert the date or time into a header or footer
  • Inserting Page Numbers
  • Changing the Page Layout
  • Changing the Page Margins
  • Changing the Page Orientation
  • Changing the Page Size

Lesson 6: Using the Mail Merge Wizard

  • Use the Mail Merge Feature

Lesson 7: Printing Word Documents, Getting Help and Exiting Word Document

  • Printing and Previewing a Work Document
  • Getting Help
  • Exiting Word

Microsoft PowerPoint

Lesson 1: Getting Started with Microsoft PowerPoint

  • Explore the User Interface and the Ribbon
  • Quick Access Toolbar
  • Create a New Presentation
  • Using Templates
  • Saving Presentations
  • Slide Basics
  • Working with Text
  • Add a Text Box

Lesson 2: Adding Multimedia Elements

  • Using Multimedia Elements
  • Working with Pictures
  • Applying Styles & Effects
  • Modifying Hyperlinks
  • Working with SmartArt

Lesson 3: Enhancing Presentations

  • Insert Audio from a File
  • Insert a Video from a File
  • Using Animation
  • Applying Transitions

Lesson 4: Managing and Preparing the Slide Show

  • Create Slide Sections
  • Presenting a Slide Show
  • Presentation Tools and Features
  • Presenter View

Microsoft Excel

Lesson 1: Getting Started with Microsoft Excel

  • Explore the User Interface and the Ribbon

Lesson 2: Overview of Workbooks

  • Creating Workbooks
  • Saving Workbooks
  • Closing Workbooks
  • Opening Workbooks
  • Selecting Cells, Rows, and Columns
  • Using Templates

Lesson 3: Modifying a Worksheet

  • Entering Data
  • Editing Data
  • Moving and Copying Cells
  • Using Paste Special
  • Clearing Cells
  • Undoing and Redoing Changes

Lesson 4: Working with Rows and Columns

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Changing Row Heights
  • Changing Column Widths
  • Hiding and Unhiding Rows and Columns

Lesson 5: Formatting Worksheet

  • Changing the Font and Font Size
  • Changing the Font Color and Fill Color
  • Applying Font Styles
  • Adding Cell Borders
  • Formatting Numbers
  • Positioning Cell Contents
  • Copying Cell Formatting
  • Applying Cell Styles

Lesson 6: Performing Calculation

  • Using Formulas and Functions
  • Using Cell References in Formulas
  • Entering Formulas
  • Displaying Formulas
  • Using Functions in Formulas
  • Using the AutoSum Button
  • Inserting Functions
  • Using Formula AutoComplete

Lesson 7: Visualizing Data with Charts

  • Creating Charts
  • Selecting Chart Elements
  • Changing the Chart Type

Lesson 8: Getting Help and Exiting Excel Document

  • Getting Help
  • Exiting Excel

 


Related Courses:

Microsoft Excel Basic     

Microsoft Excel Intermediate   

Microsoft Excel Advanced

Course Duration

3 Days

Course Time

9am to 5pm

Course Fee

S$395.00

(Group Discount of 10% for 3 or more participants)

Course Dates