Improving your Application Skills

This unit is about the skills and knowledge required by an IT user to select and use a wide range of advanced spreadsheet software tools and techniques to produce, present and check complex and non-routine spreadsheets. Spreadsheet software tools and techniques will be described as ‘advanced’ because: the range of data entry, manipulation and outputting techniques will be complex and non-routine; the tools, formulas and functions needed to analyse and interpret the required information require complex and non-routine knowledge and understanding (for example, data restrictions, data validation using formula, pivot tables, data maps); and the user will take full responsibility for setting up and developing the functionality of the spreadsheet.

In particular you will be able to:Get working with Microsoft Excel efficiently and effectivelyPerform calculationsOptimize your worksheets by creating and using formulasModify worksheets to manipulate and edit dataFormat and style worksheets to get more impact from data

You do not need to have any previous qualifications.All applicants must have an initial assessment and interview to confirm that the course is suitable for them.

Through class work, course work and assessment, Portfolio

Adults

Entry Level, Level 1, Level 2
If you will be aged 19 or older on 31 August in the year you begin your course, and have been resident in the UK/EU/EEA for the past 3 years, your course will be FREE, regardless of your age or income. Some courses will have other costs associated, such as for materials and trips. Many of our students are eligible for financial support when studying at college – please click here for more information.

Progression to Higher level courses