Microsoft Office Applications

Course Objective

The skills and knowledge covered in this course are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts, and managing small lists in Excel. Word will allow you to create longer documents, automate many operations, perform advanced merges, outline document. PowerPoint to create a presentation, add animations, run a slide show, and print presentations.

Course Duration

5 Days

Who Should Attend
    • Accounts Clerks
    • Accounting Personnel
    • Office Administrators
    • Administrative Assistants
    • Secretaries
Course Leader
Course Modules

MS EXCEL

Unit 1 Microsoft Excel

  • The Ribbon
  • The Quick Access Toolbar
  • Backstage View
  • Creating and Opening Workbooks
  • Workbook Views
  • Zoom
  • Compatibility Mode

Unit 2 Cells And Contents

  • To Insert, Delete, Cut, Copy and Paste Cell Content
  • To Access Formatting Commands by Right-Clicking
  • To Drag and Drop Cells
  • To Use the Fill Handle to Fill Cells

Unit 3 Working With Columns, Rows And Cells

  • To Modify Column Width and Row Height
  • To Insert and Delete Rows and Columns
  • Wrapping Text and Merging Cells

Unit 4 Formatting Text

  • To Change the Font, Font Size and Color
  • To Use the Bold, Italic and Underline Commands
  • To Add a Border and Fill Color
  • To Change Horizontal and Vertical Text Alignment
  • Formatting Numbers and Dates

Unit 5 Saving Workbooks

  • To Use the Save Command
  • To Save As an Excel 97-2003 Workbook
  • To Save As a PDF

Unit 6 Formulas

  • Creating Simple Formulas
  • To Edit a Formula

Unit 7 Introduction To Worksheets

  • To Insert, Delete and Rename Worksheets
  • To Copy and Move a Worksheet
  • To Color Code Worksheet Tabs
  • Grouping and Ungrouping Worksheets
  • Freeze and Unfreeze Worksheet Panes
  • Split and Unsplit the Worksheet
  • Hide and Unhide Columns or Rows

Unit 8 Printing

  • To Print Active Sheets
  • Headers and Footers
  • Print Gridlines and Headings

Unit 9 Creating Complex Formulas

  • Order of Operations
  • Working with Relative, Absolute and Mixed Cell References

Unit 10 Working With Functions

  • Basic Functions
  • Function Library
  • Insert function Command

Unit 11 Sorting And Filtering Data

  • Custom Sorting
  • Sorting Multiple Levels
  • Filtering Data
  • Advanced Filtering

Unit 12 Charts

  • To Create and Resize a Chart
  • To Change the Chart Type, Layout and Style
  • To Add Data Labels
  • To Change the Color of a Pie Chart Segment
  • To Move a Pie Chart Segment

MS WORD

Unit 1 Introduction To Word

  • The Ribbon
  • Backstage View
  • The Quick Access Toolbar
  • The Ruler
  • Change Views
  • Quitting
  • Zoom Slider

Unit 2 Working With A Document

  • Creating and Opening Documents
  • Compatibility Mode

Unit 3 Working With Text

  • To Insert, Delete and Select Text
  • To Cut, Copy and Paste Text
  • Find and Replace

Unit 4 Formatting Text

  • To Use the Bold, Italic, and Underline Commands
  • To Change the Font, Font Size and Font Color
  • To Highlight Text
  • To Change the Text Case
  • To Add Text Effects
  • Format Painter
  • To Clear Formatting
  • To Change the Text Alignment

Unit 5 Saving The Document

  • How to Save Documents
  • To Save As Word 97 – 2003 Document
  • To Save As a PDF

Unit 6 Checking Spelling And Grammar

  • To Use the Spelling Check Feature
  • To Run a Spelling & Grammar Check
  • Thesaurus

Unit 7 Printing

  • Print Preview
  • Quick Print

Unit 8 Page Layout And Formatting

  • To Change the Page Orientation and Page Size
  • Page Margins
  • The Page Setup Dialog Box
  • Breaks

Unit 9 Indent And Tabs

  • Indenting Text
  • Show/Hide Formatting Marks
  • Adjusting Line Spacing and Paragraph Spacing
  • Tab Stops

Unit 10 Managing Documents

  • To Create a List
  • Multilevel Lists

Unit 11 Working With Tables

  • To Insert and Delete a Table
  • To Add a Column or Row
  • To Apply and Change the Table Style Options
  • To Add Borders to a Table
  • Modifying a Table Using the Layout Tab

Unit 12 Working With Graphics

  • To Insert, Delete and Resize Shapes
  • To Change the Order of Shapes
  • To Change to a Different Shape and the Shape Style
  • To Change the Shape Fill Color, Outline, Shadow Effects and 3-D Effects
  • Insert, Delete, Move and Resize Text Boxes
  • Creating WordArt
  • Insert Picture/Clip Art
  • Changing the Text Wrapping Settings
  • To Crop a Picture
  • To Add a Border to a Picture, Make Image Corrections
  • To Adjust the Color in an Image
  • To Apply an Artistic Effect and Picture Style
  • Compressing Pictures
  • Removing the Background from an Image

 MS POWERPOINT

Unit 1 Introduction To PowerPoint

  • Starting Up
  • The Ribbon
  • The Quick Access Toolbar
  • Backstage View
  • Creating and Opening Presentations
  • Compatibility Mode

Unit 2 Working With Slides

  • To Change the Layout of an Existing Slide
  • To Delete a Placeholder
  • To Insert, Delete and Move a Slide
  • To Copy, Paste and Duplicate a Slide

Unit 3 Managing Slides And Presentation

  • Slide Views
  • Adding Notes to Slides

Unit 4 Working With Text

  • To Insert, Delete and Select Text
  • To Copy, Cut and Paste Text
  • To Add a Text Box
  • To Move and Resize a Placeholder or Text Box
  • Formatting Text
  • To Insert a Bulleted List
  • To Change Horizontal and Vertical Text Alignment and Text Direction
  • Find and Replace

Unit 5 Modifying Lists

  • To Modify the Bullet Style and Numbered List
  • Modifying the List’s Appearance
  • Customizing Bullets

Unit 6 Indentation And Line Spacing

  • To Indent Using the Tab Key and Indent Commands
  • Line Spacing

Unit 7 Spelling Check

  • To Run a Spell check

Unit 8 Introduction To Themes

  • Applying and Saving Theme
  • Background Styles

Unit 9 Working With Graphics

  • To Insert an Image from a File
  • To Locate and Insert Clip Art
  • Creating WordArt
  • To Insert and Resize a Shape or Text Box
  • To Change to a Different Shape, Style, Fill color, Outline, Shadow and 3-D Effects
  • Formatting Graphics
  • Ordering and Rotating Objects
  • Grouping and Ungrouping Objects

Unit 10 Working With Tables And Charts

  • To Insert and Move a Table
  • Modifying the Table Style
  • Modifying a Table Using the Layout Tab
  • Charts
  • Copying and Pasting Existing Excel Data
  • Modifying Charts with Chart Tools

Unit 11 SmartArt Graphics

  • To Insert a SmartArt Graphic
  • To Add Text and Convert Existing Text to SmartArt
  • To Add a Shape, Move and Rearrange Shapes
  • To Change the SmartArt Layout, Style and Color Scheme

Unit 12 Applying Transitions

  • To Apply, Preview and Remove a Transition
  • To Modify the Duration
  • To Add Sound and Insert Audio from a File on Your Computer
  • Formatting the Audio Icon
  • To Advance Slides Automatically

Unit 13 Working With Animations

  • To Open the Animation Pane, Reorder and Preview Effects from the Animation Pane
  • To Open the Effect Options Dialog Box and Change the Effect Timing

Unit 14 Presenting Slide Show

  • To Start, Stop or End Slide Show
  • To Advance and Reverse Slides
  • Presenting Tools and Features
  • Slide Show Set Up Options

Unit 15 Saving And Printing Presentations

  • To Use the Save Command
  • To Save As PowerPoint 97 – 2003 Presentation
  • Printing

 

WELCOME TO LCCM ASIA

Master new skills, LCCM Asia simply empowering everyone with a growth mind-set in today’s digital world.

Want to learn more about our corporate training programs?

Contact us today!