Excel: Data Analysis 2

This course covers essential Excel Data Analytics to consolidate data and work across multiple group sheets. Leave with a thorough understanding of how to arrange data effectively and develop a set of tools to enhance team performance.



Friday 16th December – Half Day – 1.30pm – 4.30pm


This course is fully funded as part of the Government’s Economic Recovery Plan.

Key features:

  • Summarise data across multiple sheets with a Pivot Table
  • Use the consolidate tool and group sheets
  • Restrict spreadsheet data editing and inputs
  • Learn advanced data filtering options using OR criteria
  • Learn enhanced Slicer and Timeline options
  • Use Goal Seek and Scenario Manager
  • Use the Watch Window
  • Use Data Validation
  • Use new data types

Meet the lecturers – AXL Training

We are a team of experienced IT Trainers & Software Adoption Specialists who deliver creative design-led learning to private & public sector organisations.

Driven by our clients’ needs, we help organisations realise the full potential of their IT investment.

ALX Training is part of BDO Jersey, working closely with BDO Advisory and C5 Alliance to help businesses and people succeed