Microsoft Office: Word, Excel & PowerPoint

VTeach Pte Ltd


Course introduction

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



Course Outline


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

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



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


ACTA and Microsoft Certified

VTeach appoints experienced trainers who are knowledgeable on wide range of topics and skillful at teaching in the interesting and simple way. We invest a lot of time finding the right trainers and have fantastic team working for us.
Our trainers are all qualified who are ACTA and Microsoft Certified.



 

Top