Learn from home - we offer this course as a live instructor-led virtual session delivered by the same expert trainers as our classroom courses
High quality training courses
We'll match like-for-like prices*
In this Microsoft Excel training course, delegates will explore the vast range of Excel Formulas and Functions and learn how to apply these to their own work. This course is designed for students who want to gain the necessary skills to create, edit and utilise Excel’s formulas and functions.
After completing this course delegates will be able to:
- Creating formulas and using BODMAS Rules
- Absolute Cell Referencing & Mixed Cell Referencing
- Named Cells and Named Range Formulas
- Consolidated Formulas and Grouping Formulas
- Conditional Formatting Formulas
- Auditing Formulas and Functions
Date Formulas and Functions
- Creating Date Formulas
- Match and Index
- IF, AND, OR
- IF & Vlookup
- IF & Sumif
NILC reserves the right to improve the specification and format of its courses for the benefit of its customers without prior notice to the customer.
Course Key Points
Duration: 1 day
Practice Exam(s): N/A
Type: Available as Classroom, Virtual Live and In-house
Save time and money by letting our expert trainers come to your offices.
Enter your onsite training requirements below and a member of our team will be in contact with you to discuss them further.
Looking to book 4 or more delegates onto a single course?
Enter your group training requirements below and a member of our team will be in contact with you to discuss them further.
Learn new skills from our expert instructors in your own time and at your own pace.
Can’t find the course dates or training location you are looking for? We’ll try our best to accommodate.
Enter your training requirements below and a member of our team will be in contact with you to discuss them further.