excel 2002 (XP), 2003 and 2007
intermediate training course

Our Intermediate Microsoft Excel course is for spreadsheet users who want to expand their skills in creating and checking formula, and to develop skills for managing multiple spreadsheets, chart/graph making and working with substantial sets of data.

course duration

This course takes one day on-site, normally between 9:30am and 4:30pm.

course prerequisites

Completion of our Basic Introduction course or sound practical experience of the skills covered by that course.

course content

Charts/Graphs Creating; formatting; customising.

Functions Important Excel functions for incorporation in formulae.

Range names Their significance; creation; incorporation in formulae.

Verifying input Techniques for checking content of cells.

Spreadsheet auditing Techniques for checking formulae.

Multiple spreadsheets Viewing; arranging; organising.

Linking spreadsheets Why link; linking worksheets; linking workbooks.

Workspaces Collections of workbooks for easy filing.

Data consolidation Combining results from more than one set of data.

Outlining Applying structure to rows and columns.

Sorting Sorting lists.

Filtering Showing items in lists that match chosen criteria.

Sub-totals Creating automatic sub-totals.

london, kent, surrey and sussex

We regularly travel to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit clients throughout Kent, East and West Sussex, Surrey and London.

As we have done in Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells and Westerham.