All ICT courses for Local Association Officers are held on a residential basis at Hillscourt Education Centre. Attendance at the courses is restricted to those holding elected positions at Local Association, Federation or national level. There is no course fee and travelling expenses are paid. Please note that special conditions are attached to some courses.
Excel (Stage 2) builds on what has been learnt in the Stage 1 course, moving onto the more advanced features.
It covers the use of:
- functions, particularly the ‘if’ function;
- conditional formatting;
- named ranges;
- vertical lookup tables; and
- spreadsheet design techniques.
The database facility within Excel is covered in detail including pivot tables.
Applicants must have attended the Excel (Stage 1) course.