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 – new SPILL functions
Excel’s dynamic array update has bought a host of new capabilities centred around the concept of “spilling”. Spill functions can fill neighbouring cells with their results, unlike standard Excel functions which are anchored to the cell they are entered in. The dynamic arrays that the Spill functions generate can be of variable size and are extremely flexible and powerful.
• Working with Spill functions
• Combining Spill functions
• Using Spill functions with data validation
• How to resolve #SPILL errors
• How to turn off Spill
Spill Functions
• UNIQUE Function
• SORT Function
• SORTBY Function
• FILTER Function
• SEQUENCE Function
Course Dates
Dates arranged on request for:
Live & Online Training
Course Duration
Online: 90-minutes
Course Fee
£180 + vat (covers up to six delegates)
Class Size
Online: Maximum of 6 delegates
Location
Online
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.
Address:
The Ross Building, Adastral Park,
Martlesham Heath, Ipswich, IP5 3RE
Please contact us by email:
info@bluenovation.co.uk
or by using the contact us form