Excel 97 & 2000 Advanced Level Course Outline - delivered in London and SE England
Home   About us   Contact   T & Cs   Search   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.

 

 

Institute of IT Training Logo ECDL Logo

 
 Overview
 

This 1-day course is for competent users who wish to use Excel extensively and enhance their working knowledge of the program. The course is intended as a natural progression from the Intermediate course.

 Course Prerequisites
 

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

 Course Content
  Improving Data Entry and Readability

 

Conditional formatting

Data validation
Custom formats

Add notes using a text box

  Pivot Tables

Create Pivot tables to summarize data
 

Group and Outline

 

Apply an AutoOutline to a worksheet

Apply grouping to pivot table fields
  Scenarios, Views and Reports

Define and save "what if" scenarios

Save different worksheet views

Create reports based on views and scenarios
  Advanced Functions

Logical, Financial, Lookup and Date Calculations
  Auditing and Troubleshooting

Use the Audit Toolbar
  Macros

Write, edit and run macros

Determine where a macro should be stored and whether absolute or relative actions are involved

Run a macro from the keyboard, a menu or a toolbar button, menu or a shape generated using the Drawing Toolbar
  Templates 

Create and use workbook templates
  Advanced Database Functions Revision of Basics
Advanced Filters

Data Validation

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 £490 per day for up to 6 delegates, plus £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

  To discuss individual requirements, or  to book a course, please do not hesitate to contact us.  
  E-mail: site.enquiry@computerliteracy.co.uk  
  Telephone: 0870 240 6160  
 
  View a printer friendly version of this page in a new window. View a printer friendly version of this page in a new window

 

 

[Tutor Led Courses] [Open Course Schedule]
 

 
 General Coverage Area
 
London Area
Central London - South London - Greater London - Hillingdon - Harrow - Barnet - Enfield - Waltham Forest - Redbridge - Havering - Hounslow - Ealing - Brent - Camden - Islington - Hackney - Tower Hamlets - Newham - Barking - Hammersmith - Westminster - City - Richmond - Wandsworth - Lambeth - Southwalk - Lewisham - Greenwich - Bexley - Kingston - Merton - Sutton - Croydon - Bromley - Kensington and Chelsea

London Postal Codes - HP - AL - SG - WD - EN - CM - SL - UB - HA - NW - N - E - IG - RM - SS - W - WC - EC - TW - SW - SE - DA - ME - GU - KT - SM - CR - BR - RH - TN

South East England
East Sussex - West Sussex - Hampshire - Bedfordshire - Northamptonshire - Oxfordshire - Buckinghamshire - Cambridgeshire - Surrey - Essex - Hertfordshire - Suffolk - Norfolk - SE / South East England
 
© 1988 - 2008 Computer Literacy. All rights reserved