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.
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
– SumIF & CountIF
– Printing / Output options
– Basic conditional Formatting
Each topic will be introduced with relevant tuition/demonstrations/handouts followed by tasks for practice.
Students will be assessed through the development of a portfolio of work covered throughout this course.
You will be awarded with a College Certificate outlining the skills you have obtained during this course.
After completing this course you could progress on to the manipulating and presenting data course.
The course information is accurate at the time of printing but is subject to change.
Office Use: 09/07/2015