Course Overview

This training is designed for users wishing to extend their knowledge of the features and functions available within this program.

How will it help you?
By attending this workshop, you will learn –
– How to build complex spreadsheets which link via formulae, together with being able to construct functions which incorporate logic into the statement. An element of automation is also examined so that repetitive sheets can be recreated with minimal effort.
– How to manipulate data to give various outputs.

What you need to know beforehand:
You should know how to produce basic formulas and how to use dollar signs in formulas prior to this training.

Course Content

• Rounding
• Notes
• Templates/Auto Templates
• Multiple Worksheets -v- Multiple Workbooks
• Group editing
• 3D Formulas
• Linking Worksheets/Workbooks
• Protection
• Consolidating Data
• Watch Window
• FlashFill
• Text to Columns
• Concatenation
• Basic IF Functions
• Date/Time Functions
• Basic Lookup Functions
• Data Validation

 

Have a question?

Let’s get this conversation started. Tell us a bit about your requirements and we’ll be in touch.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

I really enjoyed the sessions, I’ve learnt a lot and discovered many new tricks that I immediately started using in my day to day work, I feel more confident now with microsoft excel, i found the training to be very valuable and informative.

Ferrero UK, May 2026

The course was really well put together. It was very insightful, and the trainer Clare was clearly very knowledgeable! Overall, a really positive experience.

Ferrero UK, June 2026

Thank you so much for the time and patience from the trainer. I thought the sessions were excellent, paced well and ultra clear on the explanations. The trainer was very patient with any questions, re-explaining the steps and making sure everyone was following along. I learned lots of clever short cuts that will help me ongoing. The follow up document is also really helpful. Thank you again!

Thorntons Ltd, August 2025

What you need to bring for these courses when delivered as a virtual classroom.

For virtual classroom courses, you will need:

  • Computer with Internet Access
  • Microphone and Headset
  • Webcam
  • Microsoft Teams
  • A dual monitor setup is recommended for IT training
Upcoming Courses
Get in touch via our contact form or call us on 01473 414 414