To summarise data across multiple sheets with a Pivot Table
To consolidate data from across multiple sheets
To restrict how people input data into a spreadsheet
To carry out more advanced ways of filtering data
This course runs on multiple dates, when you apply please choose the date you would prefer.
Tuesday 3rd October – 9.30 – 12.30
Monday 20th November – 9.30 – 12.30
£100 plus GST (2 credits)
You will learn how to:
Use Pivot tables across multiple consolidation ranges
Use the consolidate tool & group sheets
Use further Slicer & Timeline options
Use Goal Seek & Scenario Manager
Use the Watch Window
Use Data Validation
Use the OR criteria to run advanced filters
Use New Data Types
ALX 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