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 2016 Upgrade Course for Power Users

This half day course is for proficient users of Excel who wish to know about the enhanced advanced features within version 2016.

Course Topics

New Functions

 New Date & Time functions: DAYS and ISOWEEKNUM
 New Logical functions: IFNA, IFS, MAXIFS, MINIFS, and SWITCH

* CONCAT and TEXTJOIN are currently only available in Excel 2016 online but are expected to be rolled out into the desktop version of Excel 2016 shortly

Excel Tables

•  Adding slicers to Excel tables
 Customising slicers
 Filtering data using slicers

Pivot Tables

•  Recommended Pivot Tables
 Timeline filters
•  Quick Explore ‐ enhanced Drill Down and Around facilities
 Stand Alone Pivot Charts
•  Automatic relationship detection
 Creating, editing and deleting custom measures
 Automatic time grouping
 PivotChart drill‐down buttons
 Smart rename
 Usability improvements

New Chart Types

 Box and Whiskers
 Statistical: Histogram and Pareto
 Hierarchical: Treemap and Sunburst

Course Dates

Course Dates

On Request

Bring Your Own Device Option

All classroom based scheduled training sessions are BYOD (bring your own device) courses. Don’t have a laptop? No worries, we can provide a PC for training.

Course Duration

Classroom: Half-day
Online: 1 session

Scheduled Course Fee

£95 + VAT*

*Public Sector, please email us for pricing information.

Class Size

Classroom: Maximum of 6 delegates
Online: Maximum of 6 delegates


Classroom: Ipswich or onsite at clients premises


Delegates should have attended an earlier version of our Excel Advanced course (2010 or 2013) or are working at an equivalent level.

Training Formats

Scheduled course · private course · tailored · 1 to 1
All formats available classroom based or online (all instructor led)


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.

Blue Novation - bespoke software and training solutions


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

Please contact us by email:

or by using the contact us form