We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.
Advanced Excel 2010 training – Provisional Course Outline

Our Advanced Excel 2010 training course outlines can be tailored to meet the needs of the individuals or organisation. We train at your site in Dorset, Somerset, Hampshire or Wiltshire.
Aims of the course
This course aims to give delegates an in-depth knowledge of Excel features.
Number on course | Price per day |
---|---|
1 - 1 training | £315 + VAT |
2 - 4 people | £495 + VAT |
5 - 8 people | £645 + VAT |
Course Objectives
On completion of the course delegates will have advanced skills in using Microsoft Excel 2010 . 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.
Advanced Excel 2010 training Provisional Course Outline
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
To request further details of any of our courses, or to make a booking, please contact us by ringing 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.
We provide:
- Microsoft Excel training Dorset
- Microsoft Excel training Wiltshire
- Microsoft Excel training Hampshire
- Microsoft Excel training Somerset
Excel training Dorset locations include:
Bournemouth | Poole | Sherborne | Shaftesbury |
Gillingham | Christchurch | Ferndown | Wimborne |
Blandford Forum | Dorchester | Weymouth | Verwood |
Merley | Wareham | Bridport | Lulworth |
St Leonards |
Excel training Wiltshire locations include:
Salisbury | Swindon | Trowbridge | Chippenham |
Devizes | Marlborough | Warminster | Tisbury |
Melksham | Westbury | Corsham | Amesbury |
Tidworth | Bradford-on-Avon | Bulford Camp | Porton |
Calne | Highworth | Wootton Bassett | Wroughton |
Malmesbury |
Excel training Hampshire locations include:
Southampton | Winchester | Portsmouth | Basingstoke |
Andover | Petersfield | Ringwood | Havant |
Gosport | Farnborough | Aldershot | Romsey |
Eastleigh | Fleet | Alton | Fareham |
Totton | Hedge End | Stubbington | |
Hythe | New Milton | Emsworth | Romsey |
Bordon | Tadley | South Hayling | Lymington |
Yateley | Blackfield | Hook | Blackwater |
Bursledon | North Baddesley | Liphook | Netley |
Bishop’s Waltham | Liss | Marchwood | Denmead |
New Alresford | Oakley |
Excel training Somerset locations include:
Bath | Yeovil | Wincanton | Frome |
Taunton | Weston-Super-Mare | Midsomer Norton | Shepton Mallet |
Radstock | Paulton | Bridgwater | Burnham-on-Sea |
Chard | Cheddar | Clevedon | Crewkerne |
Glastonbury | Portishead | Nailsea | Keynsham |
Street | Minehead | Wellington | Wells |
Yatton | Ilminster | Long Ashton |
We have also trained home-based businesses and users in some of the Dorset, Wiltshire and Hampshire villages, so please do get in touch.