Training at Blue Novation

 

 

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
 

Course Dates

Course Dates

Dates arranged on request for:
Face to Face (client premises only)
Live & Online

Course Duration

Face to Face: 90-minutes
Online: 90-minutes

Course Fee

£180 + VAT (covers up to six delegates)

Class Size

Face to Face: Maximum of 6 delegates
Online: Maximum of 6 delegates

Location

Online 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.

Training Formats

Private course · tailored 
All instructor led

Manuals

A comprehensive PDF course manual provides support throughout the course.

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.

Blue Novation - bespoke software and training solutions

Address:

G6, The Ross Building, Adastral Park,
Martlesham Heath, Ipswich, IP5 3RE

Please contact us by email:

Email iconinfo@bluenovation.co.uk
or by using the contact us form