Intermediate Excel 2010 training – Provisional Course Outline

Intermediate Excel 2010 training

Our Intermediate Excel 2010 training course outlines can be tailored to meet the needs of the individuals or organisation. Therefore, the training is extremely relevant as we can even use your workbooks. We train at your site in Dorset, Wiltshire or Hampshire. Hence staff do not need to travel anywhere else to get to the training.

Aims of the course

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

Number on coursePrice per day
1 - 1 training£295 + VAT
2 - 4 people£475 + VAT
5 - 8 people£595 + VAT

Course Objectives

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

  • Manipulate worksheets
  • Use templates
  • Apply conditional formatting
  • Use various functions, including 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. Furthermore, there is plenty of opportunity for delegates to practise the new skills they learn at the computer. As a result, learners will rapidly become more productive.

Pre-requisites – Familiarity with the Windows environment, and a basic knowledge of Excel.

Course Outline

Formulas

  • Revision of basic formulas
  • Using absolute cell references
  • Creating % of Totals

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
  • The TODAY function
  • The NOW function
  • Text functions
  • COUNT functions

Excel tables and lists

  • Creating an Excel table
  • Editing an Excel table
  • Sorting
  • AutoFilter
  • Filtering data
  • Totalling and manipulating filtered data
  • Creating subtotals
  • 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
  • Importing data from other applications
  • Exporting to other applications

Organisations who have benefitted from our Intermediate Excel 2010 training include:

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:

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
Burlesdon 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.