Intermediate Microsoft Excel 2003 Training Courses

If you’re looking for really great Intermediate Excel 2003 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Intermediate Excel 2003 training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

  • We come to you - your Microsoft Excel 2003 training will be given on your site
  • You get to keep the manuals - Intermediate Excel 2003 training manuals are provided as PDFs
  • We can train using your own Microsoft Excel workbooks
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Request Course Now »

Course TypeCost per day
1 to 1 training £275
2 to 4 delegates £425
5 to 8 delegates £550

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £550. All prices exclude VAT

Other Microsoft Excel training courses

Aims of the Intermediate Excel 2003 course

This course aims to give delegates a greater understanding of MS Excel 2003.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Excel 2003. They will be able to:

  • Manipulate worksheets
  • Use templates
  • Apply conditional formatting
  • Use various functions, including financial, logical and date/time functions
  • Manage Excel databases and lists
  • Customise charts
  • Use Excel in conjunction with other applications

The course is of one day’s duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a basic knowledge of Excel.

Manipulating Worksheets

  • Renaming worksheets
  • Inserting worksheets
  • Deleting worksheets
  • Splitting worksheet window into panes
  • Freezing panes
  • Hiding rows and columns
  • Grouping and ungrouping worksheets
  • Copying data between worksheets
  • Formatting multiple worksheets in one operation
  • Entering a formula to link related worksheets

Templates

  • Applying templates
  • Editing templates
  • Creating templates

Formatting

  • Applying number formats
  • Creating conditional number formats
  • Using conditional formatting

Functions

  • The IF function
  • Nested IF functions
  • Financial functions, including PMT, FV
  • The DATE function
  • The NOW function

Excel databases and lists

  • Creating an Excel database
  • Editing an Excel database
  • Sorting
  • AutoFilter
  • Filtering data
  • Totalling and manipulating filtered data
  • Creating subtotals
  • Using data forms
  • Data validation

Charts

  • Plotting non-contiguous data ranges
  • Pie charts
  • Adding new data to an existing chart
  • Chart formatting techniques

Use of Excel with other applications

  • Paste special option
  • Linking vs Embedding
  • Linking data from other worksheets
  • Linking data from other applications
  • Exporting to other applications

Request Course Now »

We provide Microsoft Excel training courses, Microsoft Office training courses, other IT training courses  and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Intermediate Excel 2003 training courses Sydney, Australia, please see our sister site http://www.jmdtraining.com.au/microsoft-office-training/microsoft-excel-training/intermediate-excel-2003-training