Tutor: Anthony Cox
This course builds on the Intermediate Excel course. This course provides a supportive environment for people who are comfortable with the fundamentals of Excel and using formulae and functions and wish to use more advanced Excel tools.
- Create pivot tables to summarise and report
- Use V Look Up and H Look Up tables
- Create If Statements
- Use absolute and relative referencing
- Use Excel to solve practical domestic and workplace problems
Your tutor will provide a mini-booklet with explanations and exercises for you to complete in class and take away. There will be a blend of computer-based exercises, theory, discussions, group and pair work. You are invited to ask questions at any time.
Observation of tasks by your tutor and question and answer sessions.
Completion of the South Thames College Intermediate Excel course. Or, you will need to be familiar with Excel fundamentals, formulae and functions.
Your tutor will provide a booklet with explanations and exercises. You should bring pen, pencil and rubber.
Take an advanced Excel course at another college.
Take Introduction to Excel Macros at South Thames College.
All courses run subject to demand and the content listed here should be used as a guide only. Course content may vary according to a range of factors such as course duration, campus, teaching staff and requirements from awarding bodies. Check our course and fee guidelines for further details.