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.
Intermediate Excel 2021 training – Provisional Course Outline
Our Intermediate Excel 2021 training course outlines can be tailored to meet the needs of the individuals or organisation. We train at your site in Dorset, Somerset, Wiltshire or Hampshire.
Aims of the course
This course aims to give delegates a greater understanding of Excel.
| 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 improved their skills in using Microsoft Excel. 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 tables
- 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, 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 basic knowledge of Excel.
Intermediate Excel 2021 training Provisional Course Outline
Formulas
- Revision of basic formulas
- Using absolute cell references
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
- Flash Fill
Functions
- The IF function
- Nested IF functions
- SUMIF, COUNTIF
- The TODAY function
- The NOW function
- COUNT functions
Excel databases and tables
- Creating an Excel list
- Editing an Excel list
- Creating an Excel table
- Sorting
- AutoFilter
- Filtering data
- Totalling and manipulating filtered data
- Grouping and outlining
- Creating subtotals
- Data validation
Charts
- Plotting non-contiguous data ranges
- Pie charts
- Adding new data to an existing chart
- Chart formatting techniques
The Quick Analysis button and how it relates to the above topics
Use of Excel with other applications
- Paste special option
- Linking vs Embedding
- Linking data from other worksheets
- Linking data from other applications
- Exporting to other applications
To request further details of any of our courses, or to make a booking, please contact us by ringing 01747 820396, 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, Somerset, Wiltshire and Hampshire villages, so please do get in touch.
Super useful! Handy tips and tricks for everyday use. Probably the most useful training I’ve had in a while!
Lauren Edwardson, The Newt in Somerset