This site requires Javascript for general functionality regarding searches and applying/validation for courses. Please enable Javascript for this purpose. Computing for Work and Leisure - Excel Intermediate to Advanced | Wiltshire College & University Centre Skip to Content
  • Search Courses
  • Search Website

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

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
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.

This course runs on one day per week at the Chippenham Campus and the dates are:
03.11.20-01.12.20 Tuesday 18:30-21:00
08.06.21-06.07.21 Tuesday 18:30-21:00
This course also runs on one day per week at the Trowbridge Campus and the dates are:
02.11.20-30.11.20 Monday 18:30-21:00

What Could I Do Next?

On completion of your course you may choose to progress onto these following courses

Computing and Information Technology


Career Opportunities

  • Project Manager
  • Network Engineer
  • Support Technician

  • Systems Analyst
  • Software Developer
  • Web Developer

The UK Tech sector is valued at over £180billion

© 2020 All rights Limited.