Where training face-to-face may still not be viable, we are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom. Do get in contact if we can help you in this way. Click for further details of upcoming sessions. We are also happy to do customised online training to meet your requirements. Contact us for further details.

We have now also resumed face-to-face training at client site.

Clients who have benefitted from our tailored online Microsoft Excel training include:

Advanced Excel 365 training – Provisional Course Outline

Advanced Excel 365 training

Our Advanced Excel 365 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 365 training course aims to give delegates an in-depth knowledge of Excel features.

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

  • AND, OR

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


  • 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:

Advanced Excel 365 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 365 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

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.