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
 New TEXT functions: NUMBERVALUE, CONCAT* and TEXTJOIN*

* 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
 Waterfall
 Hierarchical: Treemap and Sunburst
 Funnel

Course Dates

Course Dates

25th Mar 2019 – Spaces available

Course Duration

Half day

Scheduled Course Fee

£90 + VAT

Course Timings

13:30-16:30

Location

Ipswich

Prerequisites

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 instructor led)

Manuals

A comprehensive course manual provides support throughout the course and upon your return to the office.

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.

BlueNovation_logo_WA

 

 

Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email us[email protected]