Microsoft Excel Beyond Beginners
- Course code
- Type of study
- Examination board
Building on from the Excel beginners course, the Beyond Beginners course has been developed to enable you to add logic into your spreadsheet using more advanced formulas and functions.
Ideally you should have completed the beginners course or have equivalent experience to the beginners course.
On this course you will cover the following topics:
- Absolute and relative addressing
- Named ranges
- V&H lookup
- IF statements
- Sum IF and count IF
- Output options
- Basic conditional formatting
Each topic will be introduced with demonstrations and handouts followed by tasks for practice.
Students will be assessed through the development of a portfolio of work covered throughout this course.
I got into both of the Universities I wanted to. It happens so fast and it’s an amazing feeling when you think that all of the work you’ve done has paid off in the best way possible.Anton Sukhorukov, A Level student
South Downs College is a bright and happy place, everyone is kind and friendly to each other.Megan Hall, A Level student
My experience at South Downs has been decent, I’ve met lots of people, its been great to be honest, I’ve really enjoyed it.Oliver Smith, A Level student
After completing this course you could progress on to further qualifications in Excel.