Advanced Microsoft Excel 2003 Training Courses

If you're looking for really great Advanced Microsoft Excel 2003 training you're in the right place.

Companies large and small choose us - why? Your own tailored, Advanced Microsoft 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 - Advanced 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 £295
2 to 4 delegates £455
5 to 8 delegates £595

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

Other Microsoft Excel training courses

Aims of the Advanced Excel 2003 course

This course aims to give delegates an in-depth knowledge of Excel 2003 features.

Course Objectives

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

  • Link multiple workbooks
  • Print workbooks
  • Work with named ranges
  • Audit a worksheet
  • Create and use PivotTables and reports
  • Use Solver, Scenario Manager and Goal Seek tools
  • Use Excel workgroup features
  • Create and use macros

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 reasonable knowledge of Excel. Prior attendance of the Intermediate Excel course would be an advantage.

Using multiple workbooks

  • Using a workspace
  • Linking workbooks

Printing workbooks

  • Printing and previewing multiple worksheets
  • Using the Report Manager

Named ranges

  • Add a named range
  • Delete a named range
  • Use a named range in a formula
  • Use Lookup Functions

Auditing a worksheet

  • Using the Auditing Toolbar
  • Tracing errors
  • Tracing dependents
  • Tracing precedents

PivotTables and Reports

  • Creating a PivotTable report
  • Creating a PivotChart report
  • Resetting a summary function in a PivotTable report
  • Creating a PivotTable report for the World Wide Web

Data Analysis Tools

  • Goal Seek
  • Solver
  • Scenario manager

Excel workgroup features

  • Changing workgroup properties
  • Creating a shared workbook
  • Merging workbooks
  • Tracking changes
  • Creating, editing and removing comments
  • Applying and removing file passwords
  • Applying and removing worksheet and workbook protection

Macros

  • Recording macros
  • Running macros
  • Editing macros

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 Advanced Excel 2003 training courses Sydney, Australia, please visit our sister site http://www.jmdtraining.com.au/microsoft-office-training/microsoft-excel-training/advanced-excel-2003-training