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

Our Advanced Microsoft Excel course focuses on using Excel as an efficient tool to create, maintain and enhance complex spreadsheets .

Also, we examine those features of Excel with which to manage, summarise and draw conclusions from large sets of data.

course duration

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

course prerequisites

Completion of our Intermediate Microsoft Excel course or sound practical experience of applying the skills covered by that course.

course content

For clients preferring topics from the Intermediate course to be included for revision purposes, we will adjust the Advanced course syllabus accordingly.

Advanced functions Examination of an appropriate selection of Excel's built-in calculation functions applying to maths, look-up and reference, databases, finance, engineering, statistics, date and time, text, logic and information.

Advanced formulae Constructing and checking complex formulae; embedding functions in formulae.

Look-ups How to make Excel look-up entries in lists and tables.

Auditing Checking spreadsheets for missing and incorrect formulae.

Scenarios Feeding spreadsheets with sets of differing values to compare outcomes.

Custom views Keeping a variety of interchangeable formats and layouts for the same spreadsheet.

Report Manager Add-in Combining views and scenarios to produce different 'reports' from the same spreadsheet.

Databases Setting up a database; sorting; querying; outputting filtered subsets.

Pivot tables Powerful technique for taking different perspectives on a complex set of data.

Recording macros How to capture sequences of keystrokes and mouse actions for repetitive use.

Editing macros A look at the VBA (Visual Basic for Applications) programming language.

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.