Excel XP 2002 & 2003 Intermediate 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  
One Day Scheduled Open Public Excel XP 2003 Courses running at our London SE1 Training Centre    @  £ 2 2 5  + V A T  per delegate        +  I N T R O D U C T I O N  T O  /  F O U N D A T I O N  L E V E L   -  Thursday 8 June 2006    +   I N T E R M E D I A T E   L E V E L   -  Friday 21 April 2006  -  Friday 26 May 2006  -  Friday 7 July 2006    +   A D V A N C E D   L E V E L    -  Friday 28 April 2006  -  Friday 2 June 2006  -  Thursday 27 July 2006    +   T O  E N R O L L   C H E C K  O U T  T H E   "  O P E N   P U B L I C   C O U R S E S  "   L I N K   A B O V E .   .   .   .   .   Spaces are limited - so book early to avoid disappointment.                                With prices starting from  £ 4 9 0 + V A T ,  higher level VBA, tailored company specific  and on-site courses available on request.
[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

 
 
 

EXCEL XP 2003 INTERMEDIATE LEVEL COURSE OUTLINE / CONTENT

 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 Introduction 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

 

Working with Multiple Worksheets

 

Format worksheet tabs

Name, insert, delete, move and copy sheets
Apply styles
Group worksheets
  Linking Worksheets and Workbooks Arranging workbook windows
Set up formulae across worksheets and between workbooks
Data consolidation
Creating a workspace
  Workgroup Collaboration Create Hyperlinks
View and edit comments
Modify passwords, protections and properties
Create a shared workbook
Merge workbooks
Range Names
Create and use explicit range names
Use named ranges in formulas
  Functions Functions that you can use
Protecting a file
Extending use of functions to include more complex functions including conditional expressions (the IF function)
  Database Features Set up a simple database in Excel
Use the Form feature to enter, locate and edit records in a list
Sort and filter a list
Generate totals and subtotals from a database
  Advanced Charting Revision of Basics
Create combination charts
Edit scales and use secondary axes
Add and remove data to/from charts
Add trendlines and moving average lines
All course contents are subject to change with prior notice.
 Course Delivery Options Available
Scheduled Open Public Course (OPC) Course Fee £225 + VAT per delegate
 - View the current schedule
Company Specific Course (CPC) From £490 + VAT - see below  
One-On-One Course (1O1) including mentoring, coaching and "Floor Walking" From £490 + VAT - see below  

 Pricing:  Company Specific & One-On-One Courses
Excel Company Specific Courses (CPC)
  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 (1O1) - 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