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 Advanced
This course will give delegates the ability to create advanced spreadsheets using the full range of Excel’s tools and features.
Course Topics
Data Tools
text to columns • database function
New Excel 2016 Features
quick data analysis • flash fill
Tables
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
Advanced Functions
Excel’s logical functions • creating conditional tests • using formulae within conditional tests • nesting conditional statements • V and H lookups
Macros
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
Follow on Courses
• Excel VBA
• Data Analysis with Pivot Tables and Power Pivot
• Power BI
Course Dates
Dates arranged on request for:
‘Live & Online’ Training
Course Duration
Online: 2 x half-day, or 4 x 90-minute sessions
Scheduled Course Fee
£720 + VAT* (covers up to 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 the Intermediate course or gained similar knowledge in the workplace.
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.
learner testimonial
“I felt the format of the training session was good to split into bitesize chunks, as it kept me engaged in the topic.”
Will Suttle
Suffolk County Council
learner testimonial
“Training is great.”
Sarah Dennis
Suffolk County Council
learner testimonial
“Trainer was very good – nice calm and relaxed sessions, I don’t think it needs improving. Easy to follow and always checked we were ok all the time.”
Debbie O’Neill
Suffolk County Council
learner testimonial
“No improvements required.”
Holly Sharman
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