We have now returned to full face-to-face training at client site. However, we are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom , if that is your preference. Click for further details of remote training.
Advanced Excel 2021 training – Provisional Course Outline
Our Advanced 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 and Hampshire.
Aims of the course
This Advanced Excel 2021 training 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. They will be able to:
- Use a variety of Excel functions
- Name cells and ranges
- Successfully manipulate workbooks
- Audit a worksheet
- Create and use PivotTables and reports
- Use Solver, Scenario Manager and Goal Seek tools
- 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.
Course Outline
New Features in Excel
- Quick Analysis Tool
- Flash Fill
- New Functions
- Using the new Charting features
Excel Functions
- IF, NESTED IF, IFS
- AND, OR
- SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, MAXIFS, MINIFS
- VLOOKUP, XLOOKUP
- IFERROR
- TODAY, DATEDIF
- UNIQUE
- TEXTJOIN, CONCAT
Naming Cells and Ranges
- The Name Box
- Using names instead of absolute cell references
- Using names across worksheets
- Using the Name Manager
PivotTables and Reports
- Creating an Excel table
- Creating a PivotTable report
- Creating a PivotChart report
- Grouping data in a PivotTable
- Refreshing data
- Filtering pivot data
- Row and column details
- % of Total
- Creating new fields
- Slicers
- Timelines
- Showing report filter pages
- Adding tables to the data model
Auditing a worksheet
- Tracing errors
- Tracing dependents
- Tracing precedents
- Displaying all formulas in a worksheet
Data Analysis Tools
- Sparklines
- Using one-input or two-input data tables
- Goal Seek
- Solver
- Scenario manager
Manipulating workbooks
- Custom Views
- Applying and removing worksheet and workbook protection
- Data Consolidation
Macros
- Recording macros
- Running macros
- Running macros from keyboard shortcuts
- Adding a macro button to the Quick Access toolbar
- Editing macros
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
Advanced Excel 2021 training Dorset locations include:
Bournemouth | Poole | Sherborne | Shaftesbury |
Gillingham | Christchurch | Ferndown | Wimborne |
Blandford Forum | Dorchester | Weymouth | Verwood |
Merley | Wareham | Bridport | Lulworth |
St Leonards |
Advanced Excel 2021 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.