The skills and knowledge acquired on this course are sufficient to be able to use and operate the software at a competent level, and is designed for users who are keen to extend the use of the software.
You will learn how to use processes available in Excel to analyse data to provide statistics, subtotals and other useful information.
Using Maths functions including rounding, PRODUCT, SUMIF
Using statistical functions including COUNTIF
Generate random numbers to test functions
Summarising data using subtotals
Using Pivot Tables to generate and collate totals
Creating a macro to insert text
Please choose your preferred study option below (subject to change).
This course costs: £40.00
If you are aged 19 and over at the start of the course, you may have options to help fund your studies with us. The funding you can receive depends on your personal circumstances, and could mean you are entitled to fully subsidised or reduced tuition fees.
This course is fully funded for 16-18 year olds (if applicable to the course).
You may also be entitled to support with travel, childcare and equipment.
To find out exactly what you could receive, contact our Helpzone team on 08000 380 123 for a free, impartial appointment, with no commitment necessary.
This course costs: £
If you are aged 19 and over at the start of the course, you may have options to help fund your studies with us. The funding you can receive depends on your personal circumstances, and could mean you are entitled to fully subsidised or reduced tuition fees.
This course is fully funded for 16-18 year olds (if applicable to the course).
You may also be entitled to support with travel, childcare and equipment.
To find out exactly what you could receive, contact our Helpzone team on 08000 380 123 for a free, impartial appointment, with no commitment necessary.
“I have really enjoyed my time at the College, and have made some great friends whilst studying here. The tutors are really supportive and it's great that they have industry experience. Learning the fundamentals of programming has been a highlight for me.”Reece Tarrant
We have courses to suit everyone so if you haven’t found exactly what you’re looking for yet, we recommend you take a look at the following courses. We’ve selected these for you based on your interests.
At South Devon College, we offer a wide range of adult education courses and qualifications, so whatever you want to do, you can achieve it with us. The only question is how far do you want to go?
With so many courses available, we understand that finding the right one for you isn’t always easy. Our Helpzone team offer dedicated careers advice and are open all year round. Drop in or call us if you would like to have a chat about your options.
If the idea of cost is holding you back from committing to a course, there is a wide range of financial support available for adults to help fund your studies with us.