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
Follow on Courses
• Excel VBA Introduction
• Data Analysis with PivotTables and PowerPivot
• Power BI
Course Dates
Dates arranged on request for:
‘Live & Online’ Training
Course Duration
Online: 1 x half-day
Course Fee
£360 + VAT* (covers a maximum of 6 delegates)
*Public Sector, please email us for pricing information.
Class Size
Online: Maximum of 6 delegates
Location
Online
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
Private course · tailored
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:
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