Microsoft Office: Word, Excel & PowerPoint

VTeach Pte Ltd


Course introduction

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 Benefits


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



Course Outline


Training Methodologies

  • Training is hands-on using easy-to-follow step-by-step instructions.
  • Instructor-Led Training (ILT) on live exercises of each topic.
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



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