Microsoft Excel 97 2000 Training Course - Intermediate Course Content

Home

About us

Contact

T & Cs

Sitemap

News

Room Hire

Links

Tutor Led Courses | Open Course Schedule

[Back]
[Up]
[Next]

Course Options

Open Public Courses

Tutor led public courses which are scheduled on a regular basis at our SE1 London training centre.

Company Specific Courses

Company specific courses are available for organisations that have several employees who all need training at the same time or the course required is not part of our normal Open Public Course schedule. .

These closed courses are ideal where tailoring of the standard course content is required. When compared to the Open Public Course option, they typically provide cost benefits when there are three or more employees who need training simultaneously.

Courses can be run on-site if suitable facilities exist or at our SE1 London training centre.

One-On-One Mentoring - Personal Coaching

Ideal for individual delegates who have a specific requirement from the software or where previous knowledge makes group training inappropriate. The pace and the content of the course can then be adjusted to the individuals exact needs.

Floor - Walking

Where attendance on a course may not be considered appropriate, our trainers will visit clients offices on an ad-hoc or regular basis, resolving individual issues on a case by case basis - delivering quick training sessions on the "front line" at the desk.

Other Options

In addition to classroom based courses, we also offer a substantial range of computer (CBT) and web (WBT) based training courses. C/WBT are alternative education methods for those individuals looking for perhaps a cheaper alternative to traditional instructor led (ILT) training.

Overview

This 1-day course is for users who have gained a good understanding of the basic features of Excel and now wish to learn further functions and gain productivity skills. The course is intended as a natural progression from the Foundation course.

Course Prerequisites

Delegates require a good understanding of the features detailed in our Foundation / Introduction course. Good keyboard skills are essential.

Course Content

Revision of Basics

Basic Principles

	Worksheet Management		Name, insert, delete, move and copy sheets
			Group sheets
			Transfer sheets between workbooks or use to generate new workbooks

Protection

Protect sheets and workbooks

Linking Worksheets and Workbooks

Set up formulae across worksheets and workbooks

Range Names

Create and use range names

Functions

More complex functions including conditional expressions, lookups and date calculations

	Database Features		Set up a simple database
			Use the Form facility to enter, locate and edit records in a list
			Sort and filter a list
			Generate totals and subtotals from a database

	Advanced Charting		Create combination charts
			Edit scales
			Use secondary axes
			Add data to charts
			Add trendlines and moving averages

Data Transfer

Transfer data into other Office applications, eg Word or Access

All course contents are subject to change with prior notice.

ILT Course Options Available

Company Specific Course

One-On-One Course

including mentoring, coaching and "Floor Walking"

Company Specific & One-On-One Course Pricing

Excel Company Specific Courses

The price for company specific courses is £590 per day for up to 6 delegates, plus from £65 per day for each additional delegate. If the course is run at our SE1 London Training Centre, there is an additional charge of £170 per day for use of the training facilities, lunch etc.

Prices include all course materials and are exclusive of VAT. For courses run outside the Greater London Area at a customer's site, the trainer's travel and and any required accommodation expenses are charged extra at cost.

Request a Quote

Excel One-On-One Tuition - Mentoring, Coaching & " Floor-Walking "

The price for One-On-One Tuition and "Floor-Walking" engagements is £490 per day.

Prices are stated exclusive of VAT. For courses run outside the Greater London Area at a customer's site, the trainer's travel and and any required accommodation expenses are charged extra at cost.

Request a Quote

View a printer friendly version of this page in a new window

[Tutor Led Courses] [Open Course Schedule]