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.
This course includes:
- Training from an experienced Microsoft trainer
- Computer / Laptop to use for the duration of the course (classroom & onsite courses only)
- Detailed course notes and sample exercises
- Full colour course manual
- Free online training videos
- Refreshments (classroom courses only)
- A recording of the training course (virtual courses only)
Course Key Points
Duration: 1 day
Practice Exam(s): N/A
Type: Available as Classroom, Virtual Live and In-house
Learn new skills from our expert instructors in your own time and at your own pace.
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.
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.
Can't find the course dates, location or delivery type you are looking for? Fill out the Request Dates form above and we'll try our best to accommodate.