Computing for Work and Leisure - Excel Intermediate to Advanced

Key course information

Computing and Information Technology

08/06/2021

5 weeks

Part time

88.00

Apply for this course

Apply

Course Overview

This course is suitable for learners who have a good knowledge of using a computer or laptop, with some experience of Microsoft Excel. As a minimum they should have completed the Beginners to Intermediate course, or be at that level. This is a five week course comprising 2.5 hours per week.

Several students sat behind their computers

What will I learn?

The aim of the course is to give the learners more advanced skills to enable them to use Excel to create a variety of professional spreadsheets suitable for personal or business use.

The following topics will be covered during the course: Hiding, Splitting and Freezing Panes and Worksheets; Using Relative, Absolute and Mixed Formulae; Using a range of automatic functions; Learning how to design and nest functions, including IF; Create and use Pivot Tables; Use VLookup and HLookup; Create Dropdown Lists; Save to appropriate folders and print work

Entry Requirements

As a minimum learners should have completed. Computing for Work and Leisure - Beginners to Intermediate course or be at an equivalent level.

Study, Assessment and Qualifications

Assessment is informal, based on your personal targets and the learning outcomes and will be undertaken regularly with you by the course tutor.

Additional Costs and Information

You should bring with you a notebook and pen, or other method of taking notes. There will be handouts and workbooks provided during the course. Please note that the course is a combination of lecturer taught and individual learning using the workbook with lecturer support.