Browse courses

Book your training course

Feefo logo

In-house training

  • This training course can be tailor-made and delivered in-house for up to 8 people. Held online via our virtual classroom or where safe to do so, at your premises or a nearby venue.
  • £1245 (+VAT & Travel)

Scheduled course

  • Sorry, there’re no scheduled courses at the moment. Get notified via email when a course at a one of our venues takes place.
Get notified

Why book this course?

Many of us are familiar with the basic functions of Microsoft Excel, but few realise how flexible the software is, and the range of situations it can be used for. Even if you have a solid grasp on how to use Excel, it’s likely that you’re missing out on tricks and tips that could elevate your productivity.

Our action-packed Intermediate Training course builds on our Microsoft Excel Beginners course, extending your skills and further improving your confidence with the software. Learners will delve into the facilities of data tables and databases, learn even more powerful formulae, and manage and finish their spreadsheets in a way that stands out from the crowd.

Who is the course for?

Our Microsoft Excel - Intermediate Training course assumes a good level of prior knowledge of the basics of Excel, equivalent to our Microsoft Excel Beginners Introduction course.

This will include anyone who has taken that course with us, or who uses Excel on a day-to-day basis for basic calculations and organisation.

What content will the course cover?

Recap on some basic formulae 

  • Absolute and Relative Cell Referencing

  • Average/Max/ Min Functions 

  • Custom Lists and Creating Own

  • BODMAS – order of calculation

  • Shortcuts

  • Quick Fill

Working with Sheets and Workbooks

  • Worksheet administration

  • Work on multiple workbooks – 3d Formulae

  • Freeze panes/Split Screen

  • Use Styles, Creating and Merging 

  • Use borders and shading effectively

Conditional Formatting 

  • Icon Sets and Managing Rules

Data Lists

  • Creating data lists

  • Simple and custom sorts

  • Maintain lists with data forms

  • Use Subtotals

  • AutoFilter lists

  • Advanced Filtering

Range Names

  • Why you would use them?

  • Using Range Names in Formulae 


  • Creating and editing charts

  • Changing chart location and adding data

  • Change/customise the chart type

  • Auto format and customised auto Sparklines

Creating Hyperlinks

What will I get out of the training?

Learners on our Microsoft Excel - Intermediate Training course will gain an understanding of how to use Microsoft Excel for database purposes, including how to store and analyse data within spreadsheets. You’ll also learn to use and understand a greater variety of formulas and functions, and how to manage and finish your spreadsheets quickly, easily and professionally.

At Kent Trainers, we’re proud to offer courses that take the needs of businesses into account. All of the learners on our Microsoft Excel courses will benefit from in-depth practical exercises, as well as being able to ask questions and gain feedback from our trainers - tailoring your learning experience to the skills you need.

What is the duration of this course?

This is a 1 day course.

The timings and format for our courses are as follows:

  • Scheduled training courses held virtually

Unless specified, courses commence at 9:30am and finish at approximately 4:00pm.  The day is broken up into modules, both online and offline to ensure engagement and interaction.  We also ensure that there are plenty of comfort breaks throughout the day.

  • Scheduled training courses held at one of our venues

Courses commences at 9:30am and finish at approximately 4:30pm. On all our scheduled courses, a hot lunch is included, and refreshments are provided throughout the day.

  • In-house & bespoke courses, held virtually or at a venue of your choice

For all in-house training courses, we will adapt the timings and format for the day around the needs of your team and business. Please contact us to discuss your requirements.

Ready to book onto your course?

Let get you started by choosing what booking option is the best option for you.

Choose booking

Want 10% off your first scheduled course?

Sign up to our newsletter and receive 10% off any of our scheduled courses as a thank you! Our monthly newsletters are filled with features, advice and information about our forthcoming courses.