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 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

Course Dates

Course Dates

Book two places on the same course and get the second place half price!* 

*Applies to non-discounted fees only
5th Dec 2019 – FULL
19th Feb 2020 – Spaces Available

Bring Your Own Device Option

This is a BYOD (bring your own device) course.
Don’t have a laptop? No worries, we can provide a PC for training. 

Course Duration

1 day

Scheduled Course Fee

£190 + VAT*

*Public Sector, please email us for pricing information.

Course Timings

9:30-16:30

Location

Ipswich

Prerequisites

Delegates should have attended the Intermediate course or gained similar knowledge in the workplace.

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.

learner_testimonial_icon

company testimonial

“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
Movac Group

learner_testimonial_icon

company testimonial

“The feedback was excellent.

Everyone really enjoyed the course and found it very useful in terms of using Excel within their daily roles”

Nickie Roberts, Lead Technical Support Assistant
The County Inclusive Resource
Suffolk County Council

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 usinfo@bluenovation.co.uk