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 Intermediate

This training course has been designed to give delegates a solid understanding of more advanced Excel tools and concepts in order to increase their knowledge and productivity.

Course Topics

Hints and Tips

using named ranges of cells • copying & pasting techniques • adding cell comments • exploring the Fill handle • applying conditional formatting freezing areas of the worksheet • Paste special • Go To special 

Multiple Worksheets & Files 

moving between worksheets • inserting and deleting worksheets • moving and copying worksheets • group mode • linking worksheets with formulae • printing multi worksheets • moving and copying worksheets between workbooks • creating formulas between workbooks • editing linked formulae

Charts

creating a chart • recommended charts • changing the chart type • adding data • improving the appearance of a chart • using AutoFormat • creating custom formats • simple sparklines

Working with Lists of Data 

creating & editing a data list • sorting data in a list • using AutoFilter • quick data analysis

Automatic Subtotalling

adding and removing subtotals • using different subtotal functions • removing subtotals

Excel Tables – Time allowing  

creating and naming tables •  move between tables and ranges • modifying tables • define titles • sorting tables • filtering tables • table styles and formatting

 

Follow on Courses

Excel Advanced

Course Dates

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

company testimonial

“Blue Novation have 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

learner testimonial

“Very valuable and has given me a lot of useful information to use within my job.  Really good course, Jan made it informative but very enjoyable”

L Hakes, Import Documentation
K-Line (Europe) Ltd

learner_testimonial_icon

learner testimonial

“It was a really interactive course given it was via Teams. Really enjoyed it!”

Stephanie Peck
Suffolk County Council

learner_testimonial_icon

learner testimonial

What subject did you find most useful: “Moving across workbooks, formulas in multiple worksheets, tables and lists”

Your overall opinion of the course: “Amazingly useful. Practical and interesting”

S Smith, Compliance & Finance
ROL Cruise

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.

Blue Novation - bespoke software and training solutions

Address:

The Ross Building, Adastral Park,
Martlesham Heath, Ipswich, IP5 3RE

Please contact us by email:

Email iconinfo@bluenovation.co.uk
or by using the contact us form