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

Jennifer Lye

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

← Track Records Microsoft Excel PowerPivot →

WELCOME TO LCCM ASIA

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