This course builds on the intermediate Excel course and is a great way to improve your skills if your looking to get ahead at work. 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.
By the end of the course you'll be able to:
Create pivot tables to summarise and report
Use V Look Up and H Look Up tables
Create If Statements and conditional formatting
- Use absolute and relative referencing* Use Excel to solve practical domestic and workplace problems
Your tutor will provide a booklet with explanations and exercises. You should bring a pen, pencil and rubber.
Completion of the South Thames intermediate Excel course. Or, you will need to be familiar with Excel fundamentals, formulae and functions.
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.