ABOUT THE COURSE
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.
WHAT WILL I STUDY?
In particular you will be able to:
Get working with Microsoft Excel efficiently and effectively
Optimize your worksheets by creating and using formulas
Modify worksheets to manipulate and edit data
Format and style worksheets to get more impact from data
WHAT WILL I NEED?
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.
HOW WILL I BE ASSESSED?
Through class work, course work and assessment, Portfolio
WHAT WILL IT COST?
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.
WHAT CAN I DO AFTER?
Progression to Higher lvel courses