Related Courses
Take your career to the next level with higher education that works for you
Course Overview
This half-day course is designed to assist those wishing to learn advanced Formulae of Microsoft Excel.
Delegates will learn to use VLOOKUP’s, HLOOKUP’s, error checking in Formulae, Protecting Cells and Validation Techniques.
Course Content
The course will cover the following topics:
- Naming Cells
- VLOOKUPS and HLOOKUP
- Troubleshooting Errors
- Protection
- Data Validation
- If, And, Or, Nested IF Formulae
Benefits
This course will equip delegates with a sound advanced level knowledge of Excel and is the third of our Excel series, the others being Excel Beginners, and Excel Intermediate.
Prerequisites
Ideally you will have completed the ‘Intermediate’ module or have a good working knowledge of other Excel versions to begin with.
Course Tutor
Susan Watson
Susan Watson is a senior consultant and director with over 15 years’ experience delivering business and technology solutions across finance and professional services. She specialises in making complex tools like Excel practical and accessible, with a focus on real-world application such as reporting, data analysis, and improving efficiency.
Sign In Required
Please sign in to book this course
Register interest
Enter your email to be notified when new dates are available.
Select which organisation you would like to book for
Select Attendees to Book
Booking Summary
Free Course Summary
Register Interest Summary
- Course
- Course Title
- Notification
- You will be notified when this course becomes available for booking