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.
This course will give delegates the ability to create advanced spreadsheets using the full range of Excel’s tools and features.
text to columns • database function
New Excel 2016 Features
quick data analysis • flash fill
creating and naming tables • move between tables and ranges • modifying tables • define titles • sorting tables • filtering tables • table styles and formatting • using slicers
Pivot Tables & Pivot Charts
creating a pivot table • recommended pivot tables • modifying a pivot table • formatting data • using the drill down facility • sorting & filtering data • adding calculated fields • grouping data • using slicers • pivot table timelines • sparklines
Excel’s logical functions • creating conditional tests • using formulae within conditional tests • nesting conditional statements • V and H lookups
recording/running simple macros • macro storage • absolute and relative references • assigning shortcuts to macros • creating a macro button
Customising Excel (v2016) – Time allowing (Sway alternative)
modifying the ribbon • creating custom groups and buttons • exploring the options commands • custom views
31st Jul 2019 – Spaces available
Scheduled Course Fee
£190 + VAT*
*Public Sector, please email us for pricing information.
Delegates should have attended the Intermediate course or gained similar knowledge in the workplace.
Scheduled · course private course · tailored · 1 to 1 (all instructor led)
A comprehensive course manual provides support throughout the course and upon your return to the office.
“Blue Novation has supplied our Microsoft Office training since 2003 and we have been consistently pleased with the extremely positive feedback from our staff and the obvious improvements in staff skill levels.
The post-course support has always been good and we will continue to use Blue Novation for our training in the future. I would recommend them to any organisation hoping to improve staff skills with the Microsoft Office software”.
Brian Welton, Procurement and Marketing Assistant
Not found the course you are looking for?