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 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.
Hints and Tips
using named ranges of cells • copying & pasting techniques • adding cell comments • exploring the Fill handle • applying conditional formatting
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
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
adding and removing subtotals • using different subtotal functions • removing subtotals
Working with Worksheets
freezing areas of the worksheet • splitting the screen • hiding cells and worksheets • protecting worksheets and workbooks • adding a password to a workbook • Paste special • Go To special
Excel Tables – Time allowing (Sway alternative)
creating and naming tables • move between tables and ranges • modifying tables • define titles • sorting tables • filtering tables • table styles and formatting
Follow on Courses
Classroom: 22nd Apr 2020 – Postponed
Online: 24 Nov 2020, Session 1 (09.30 – 10.30)
Bring Your Own Device Option
All classroom based scheduled training sessions are BYOD (bring your own device) courses. Don’t have a laptop? No worries, we can provide a PC for training.
Classroom: 1 day
Online: 2 sessions
Scheduled Course Fee
£175 + VAT*
*Public Sector, please email us for pricing information.
Classroom: Maximum of 6 delegates
Online: Maximum of 6 delegates
Classroom: Ipswich or onsite at clients premises
Delegates should have attended the Introductory course or gained similar knowledge in the workplace.
Scheduled course · private course · tailored · 1 to 1
All formats available classroom based or online (all instructor led)
A comprehensive course manual provides support throughout the course. Available in PDF format for Online sessions.
“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
S Smith, Compliance & Finance
L Hakes, Import Documentation
Not found the course you are looking for?