Key course information
Computing and Information Technology
08/06/2021
5 weeks
Part time
88.00
Apply for this course
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.
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.
This course runs on one day per week at the Chippenham Campus and the dates are:
08.06.21-06.07.21 Tuesday 18:30-21:00
What Could I Do Next?
On completion of your course you may choose to progress onto these following courses
You could enrol on our Computing for Work and Leisure – Word Basics to Intermediate and Intermediate to Advanced, or Computing for Work and Leisure - PowerPoint to further develop your skills.