Microsoft Word
Starting Word
• Shortcut Menus
• Saving a Document
• Creating a New Document
• Ask for help using the Office Assistant
Basic Editing
• Cursors
• Cursor Movement
• Inserting Text
• Word Wrap
• Deleting Characters
• Undo and Redo
Formatting
• Selecting Text
• Applying a Font
• Font Size
• Font Attributes
• Font Colour
• Text Alignment
• Moving and Copying More Editing Features
Zooming
• Views of a Document
• Find and Replace
• Spell Checker
• AutoCorrect
• Case Conversion
• Format Painter
Paragraph Formatting
• What is a Paragraph?
• Selecting a Paragraph
• Indents
• Units of Measure
• Line Spacing
Tables
• Typing into the Table
• Moving around the Table
• Selecting Cells within a Table
• Inserting/Deleting Rows and Columns
• Altering Column Widths
• Adjusting Row Heights
• Borders and Shading
Bullets and Numbering
• Creating a Bulleted list
• Creating a Numbered list
• Page Set Up and Printing
Pagination
• Setting Margins
• Page Size and Orientation
• Automatic Page Numbering
Printing
• Print Previewing
Powerpoint
Creating New Presentations
• The Opening Screen
• Using the Ribbon
• Quick Access Toolbar
• Creating a new Presentation
• Saving a Presentation
• Closing and Opening a Presentation
• Printing a Presentation
Text Charts
• Title Pages
• Bullet Charts
• Editing and Enhancing bullet charts
Creating Chart Slides
• Creating a Chart
• Changing Chart Type
• Adding Chart Elements
• Formatting a Chart
• Quick Chart Elements
• Using Chart Designs
• Saving the Chart to a New Sheet
Diagrams
• Creating an Organisation Chart
• Entering Personnel Data
• Adding and Removing Boxes
• Formatting text, boxes and lines
• Other types of Diagrams
Creating Table Slides
• Creating Tables
• Adding text and numbers
• Formatting the data and table
• Inserting rows and columns
• Deleting rows and columns
Using Clipart & Pictures
• Inserting ClipArt or a Picture
• Sizing and Cropping images
• Re-colouring an Image
• Grouping & Un-Grouping Images
Printing
• Viewing the Slides
• Re-ordering the Slides
• Using Headers & Footers
• Spell Check
• Printing the Slides
On Screen Shows
• Running an On-Screen Show
• On-Screen Show with Transitions
Microsoft Excel
Introduction to Excel
• The Excel Screen
• Using the Ribbon
• The quick Access Toolbar
• Saving, Opening, Closing a Workbook
• Moving around the Worksheet
Entering Data
• Entering, editing and deleting data
• Undo and Redo
• Filling Cells
• Cut, Copy and Paste
• Using the Windows Clipboard
• Working with Rows and Columns
• Inserting and Deleting Columns and Rows
• Change Column Width & Row Height
• Hide and Un-Hide Columns
Formatting Cells
• Highlighting Methods
• Formatting Text & Numbers
• Alignment of Cells
• Merging Cells
• Wrapping Text
• Borders and Shading
Working with Worksheets
• Renaming Worksheets
• Inserting Worksheets
• Move and Copy Worksheets
• Delete Worksheets
AutoFill
• How to use the AutoFill Handle
• Using AutoFill to Copy Sequence
• Using AutoFill to Replicate
• Customer AutoFill Lists
Viewing Data
• Zooming a Workbook
• Freezing Panes
• Splitting a Window
Using Formulae and Functions
• How to Enter a Formula
• What are Functions
• Using Sum/Average/Max/Min
• Copying Formulas
• Relative and Absolute References
Printing
• Setting up the Page for Printing
• Using Different Views
• Adding Headers and Footers
• Using Print Titles
• Setting and Clearing Print Areas
Simple Charts
• Creating Simple Charts
• Changing Chart Type
• Formatting a Chart