Home » Courses » Microsoft Excel Beyond Beginners

Microsoft Excel Beyond Beginners

Building on from the Excel beginners course, the beyond beginners has been developed to enable you to add logic into your spreadsheet using more advanced formulas and functions. This will represent the majority of the time spent on the course, finishing up with spark lines and an introduction to conditional formatting.

Entry Requirements

Ideally you should have completed the beginners course or have equivalent experience to the beginners course.

Course Content

On this course you will cover the following topics:
– Absolute and relative addressing
– Named ranges
– V&H Lookup
– IF Statements
– SumIF & CountIF
– Printing / Output options
– Sparklines
– Basic conditional Formatting

How will I be taught?

Each topic will be introduced with relevant tuition/demonstrations/handouts followed by tasks for practice.

How will I be assessed?

Students will be assessed through the development of a portfolio of work covered throughout this course.

What qualifications will I get?

You will be awarded with a College Certificate outlining the skills you have obtained during this course.

What will it allow me to do in the future?

After completing this course you could progress on to the manipulating and presenting data course.

Course Information

The course information is accurate at the time of printing but is subject to change.

Office Use: 09/07/2015

South Downs College Cookie Warning Cookies are enabled on this site to enhance your browsing experience and usability.