Microsoft Office: Word, Excel & PowerPoint

Course Dates:

12, 13 & 14 Feb 2018

Course Specifications

Duration : 3 Days (9.00am to 5.00pm)

Course Fees : S$395.00 (Group Discount of 10% for 3 or more participants)

Course Objective:

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

Course Content

Day 1 : Excel

Lesson 1: Formulas and Functions

  • Entering Formulas
  • Excel Arithmetic Operators
  • Using AutoFill Options
  • Using Commonly Used Functions

Lesson 2: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table

Lesson 3: Working with Charts

  • Summarizing Data Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Creating a Pie Chart

Lesson 4: Working with Graphics

  • Adding Pictures into a Worksheet
  • Customizing Pictures and Objects
  • Adding Drawing Objects
  • Adding SmartArt into a Worksheet

Lesson 5: Managing Large Workbook

  • Managing Large Workbooks
  • Printing Worksheets
  • Setting Page Setup Options

Lesson 6: Customizing & Enhancing Workbooks

  • Customizing Excel to Your Work
  • Creating Hyperlinks
  • Customizing Quick Access Toolbar

Day 2 : Word

Lesson 1: Formatting Text & Paragraphs

  • Setting Tab Stops
  • Organizing List Information

Lesson 2: Formatting Documents to Print

  • Using Headers & Footers
  • Proofing
  • Preapring for Print

Lesson 3: Using Tables in Word

  • Inserting Tables
  • Modifying Tables
  • Sorting Lists

Lesson 4: Working with Illustrations

  • Inserting Pictures and Manipulating Images
  • Wrapping Text around a Picture

Lesson 5: Creating Mass Mailing Documents

  • How do I merge?
  • Setting Rules for Merging
  • Creating Simple Mailing Documents

Lesson 6: Referencing Information

  • Creating an Index
  • Creating a Table of Contents

Day 3 : PowerPoint

Lesson 1: Working With Text

  • Using an Outline
  • Adding Text
  • Using Bullets and Numbering
  • Formatting Text & Paragraphs
  • Using Text Boxes
  • Setting Tabs

Lesson 2: Adding Multimedia Elements

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

Lesson 3: Enhancing Presentations

  • Adding Audio & Video Media
  • Using Animation
  • Managing Multiple Transitions
  • Changing Animation Order
  • Using Slide Transitions

Lesson 4: Preparing The Slide Show

  • Reviewing The Presentation
  • Customizing the Presentation
  • Proofing the Presentation
  • Setting up a Slide Show
  • Using Presentation Tools
  • Using Presenter View
  • Rehearsing a Presentation
  • Presenting The Slide Show

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy