This course is delivered by Halesowen College

Learning Aim

To enable learners to understand:

• How to exteend basic sorting and filtering using Excel
• How to use the advanced filter to extract specific data and unique values
• How to use the subtotal function
• How to create and re-use custom views

Outcomes

The learner will be able to go back to their workplace and:-

• Be able to use and integrate excel more effectively
• Be able to manipulate data for management reports

Exercises are designed for those with a basic knowledge of Excel

• Under the EU funding rules, eligibility will be checked before the course commences
• People currently undertaking a modern apprenticeship are not eligible for this funded course
• Your business must be based in the Black Country to be eligible for this course