The Word Window

Moving Around the Screen (Mouse or Keyboard)

Entering Text

Formatting Text

Using Undo and Redo

Saving and retrieving a Document

Spell Checking

Previewing a Document Before Printing

Printing a Document

Selecting Text

Formatting Paragraphs

Formatting Pages

Cut, Copy and Paste

Working with Tabs

Creating Tables and formatting Tables

Using Formulae in Tables

Creating and Using Sections

Headers & Footers, First Page and within Sections

Using Columns

Mail Merge; creating a Form Letter, Data Source and Merging the Document

Using the Drawing Toolbar, Clip Art and Word Art

AutoCorrect and AutoText

Creating Shortcut Keys

Creating Styles & Style Management

Creating Document Templates

Advanced Mail merge including Interactive Merge

Using Field Codes for Automating Documents

Creating Table of Contents and Indexes

Defining and Creating Cross References

Creating and Using Macros

Managing Macros

The Excel Window

Moving Around the Screen (Mouse or Keyboard)

Entering Labels and Values

Formatting Labels and Values

Entering Formula

Saving and retrieving a Work Book

Previewing a Sheet Before Printing

Printing a Sheet

Selecting Cells and Ranges

Copying Formula and Text

Automatically fill in data based on adjacent cells

Preventing cell reference replicating

Spread Sheet Principles; organisation, enhancing data

Setting Titles, Splitting Windows

Cell Referencing; naming ranges, absolute and relative referencing

Annotating a Cell

The IF Function

Working with Dates

Building, Sorting and Filtering Databases

Finding Records and Data Queries

Vertical and Horizontal Lookup Tables

Creating, Editing and Formatting Charts

DDE and OLE

Protecting Cells and Sheets

Inserting Hyperlinks

Customising the Toolbars

Creating and Using Basic Templates

Working with Multiple Worksheets

Exploring more Math & Trig, Financial and Statistical Functions

Formula using 3D Ranges

Creating File Links

Using Goal Seeker

What If Analysis

Creating and Using Templates

Inserting a new sheet based on a Template

Using the Query Add-in

Developing Macros

View Managers

Advanced Charting; saving chart formats, pictograms and trendlines

The Access Window

Wizards and Cue Cards

Creating a Database

Defining a Field, Data Types and Field Properties

Setting up a Primary Key

Datasheet View.  Adding, Finding and Sorting Records

Creating a Form

Using Form to View Records

Filtering Records

Creating a Query

Query Design, Selecting Records

Running and Saving the Query

Creating a Report

Report Design

Previewing and Printing the Report

Validation Techniques

Relationships; Types and Referential Integrity

Adding Tables to the Relationship Window

The Relationship Window, Defining, Editing and Closing Relationships

Relationships in Queries

Relationships within Forms

Combo and List Boxes in Forms

Indexing Fields

The Groups/Totals Report

Headers and Footers

Creating Summary Fields

Page Breaks and Page Numbering

Using Wizards