Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
Excel Advanced Functions
Excel’s functions are many and various … and sometimes confusing! Get to grips with IF, LOOKUP and the DATE functions, discover the benefits of range names, ways of validating your data results and even how to design custom functions specific to your data.
Course Topics
• Using IF and OR functions
• nested IF
• Vlookup & Hlookup functions
• date and time functions
• calculating with range names
• editing range names
• using data validation
• custom functions
Course Dates
Classroom: 20th May 2020 – To be confirmed
Online: Dates coming soon!
Course Duration
Classroom: 90-minutes
Online: 1 Session
Scheduled Course Fee
£50 + VAT
Class Size
Classroom: Maximum of 6 delegates
Online: Maximum of 6 delegates
Location
Classroom: Ipswich or onsite at clients premises
Prerequisites
Delegates should have a good understanding of basic functions within Excel, or have attended our Basic Formulas & Functions workshop.
Scheduled course · private course · tailored · 1 to 1
All formats available classroom based or online (all instructor led)
Manuals
A comprehensive course manual provides support throughout the course. Available in PDF format for Online sessions.
Not found the course you are looking for?
We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.
| Address: | Contact us on: |
| NG7 Columba House, Adastral Park, | 0345 11 88 150 |
| Martlesham Heath, Ipswich, IP5 3RE |  info@bluenovation.co.uk |