Microsoft Excel

Contact us for dates, pricing and how we can customise courses to your requirements: contact us

Introduction Level Training

Duration: 1 day

Databases drive nearly every Internet and Intranet Web site. Aspect’s Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is SQL Server Database, an open source product that is gaining in popularity in the industry. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.

Getting started with Word
  • Creating a document
  • Entering text
  • Saving a document
  • Getting help


Editing a document
  • Moving around the document
  • Selecting text
  • Finding and replacing text
  • Copying and pasting text
Formatting text
  • Text formatting
  • Paragraph formatting
  • Copying formatting
  • Removing formatting
Automatic features
  • Using AutoCorrect
  • Using AutoFormat as you Type
  • Using AutoText


Finishing the document
  • Spell checking and grammar checking
  • Using the thesaurus
  • Using hyphenation
  • Page breaks
  • Headers and footers for page numbering
  • Previewing the document
  • Page settings and margins
  • Print preview
  • Printing the document

Intermediate Level Training

Duration: 1 day

Word Revision
  • Working efficiently with Word
  • Shortcuts, hints and tips
Tabs and Tables
  • Using tabs
  • Formatting tabs
  • Creating tables
  • Formatting tables
  • Inserting, deleting and moving columns and rows
  • Splitting and merging cells
Long Documents
  • Working with columns
  • Column breaks
  • Working with sections
  • Advanced headers and footers
Formatting Styles
  • Using styles
  • Editing and deleting styles
  • Applying styles from a template
  • Outlining a document
  • Using the document map
  • Creating a Table of Contents
Mail Merge
  • Using mail merge
  • Using an address list
  • Printing labels
  • Working with templates
  • Using pre-prepared templates

Advanced Level Training

Duration: 1 day

On-Line Forms
  • Creating an on-line form
  • Working with form sections
  • Protecting the form


  • Creating a template
  • Modifying a template
  • Styles, AutoText and Toolbars in templates
Versions and Revision
  • Save a new version of a document
  • Tracking changes
  • Printing revisions
  • Comparing versions and documents
Automatic References
  • Building an index
  • Inserting bookmarks
  • Inserting captions
  • Inserting a cross reference
  • Inserting a comment
  • Review comments
  • Building a Table of Figures


  • Creating lines and shapes
  • Creating text boxes
  • Formatting shapes and text boxes
  • Enhancing drawing objects
  • Sizing and rotating objects
  • Aligning and distributing objects
  • Grouping and ungrouping objects
Web Pages
  • Creating Web Pages
  • Creating Hyperlinks
  • What is a macro?
  • Record a macro
  • Run a macro
  • Assign a macro to an icon, menu or keystroke