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
Printing
- 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
Templates
- 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
Templates
- 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
Drawing
- 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
Macros
- What is a macro?
- Record a macro
- Run a macro
- Assign a macro to an icon, menu or keystroke