SCO Level 2

Advanced Excel

This is an advanced course aimed at those with a working knowledge of spreadsheets and using Microsoft Excel.

This short one-day course will develop your knowledge of how to use Microsoft Excel to create spreadsheets.

The course content will cover using more complex functions, including:

Use and apply Conditional Formatting

Use the Flash Fill function

Apply Passwords and Protection to sheets and cells

Create and apply Data Validation rules to cells

Create and manipulate Pivot Tables

Use Subtotals

Create and use named ranges

Use lookup/match, and if error functions

There are no formal entry requirements, however, you must be aged 19+ the previous August and a resident in the UK/EU for three years or longer

There are no formal assessment or exams

£20

Please contact for further details

tel: 01522 876258 or email [email protected]

Related Courses