Intermediate Excel Training Course

Our intermediate Excel training course can be carried out in the following versions: 2010, 2013, 2016 and 365.

All of our courses are full day courses, typically running from 9:30am to 4pm with two coffee breaks and a lunch break throughout to break up the course. Timings can be slightly flexible though to fit in with your needs. We can also create a bespoke course to tailor the contents of the course to your needs. Just ask, we’d be happy to help.

Key Content

The key content that is covered in the course can be found below:

 

  • Charts – chart sheets, formatting and protection
  • Sorting and Custom Lists. Advanced sorting
  • Subtotalling using command button
  • Auto, Custom and Advanced Filtering of a list
  • Miscellaneous features remove duplicates, evaluate formulas
  • Absolute References in formulas. Named cells and Ranges
  • Complex formulae e.g. IF, Problem Solving
  • Formula auditing
  • Group sheet selection
  • Multi File linking and consolidation
  • Using SUMIF and COUNTIF functions
  • Locking Cells and password protection
  • Exercises throughout

Course Objectives

The objective of this course is to enable the trainee to understand regularly used features in business including the creation of Charts. Data Analysis functions like Sorting, Sub Totalling and Filtering will be covered. Extensive practices will be given in the use of problem techniques like relative and absolute referencing and the IF statement. We will then cover multi sheet and workbook summaries.

Comments and Testimonials

Shrewsbury Food Hub Testimonial – training those helping their community

Thank you John for an engaging session. It has opened our eyes to many shortcuts and features that will make our working days run smoother.
Being a small charity, we do a lot of data collection and evaluation, to show the impact of our work. John showed us useful ways to record, sort and display our data in Excel. This will save us a lot of time! Thanks John.
A clear, well-structured course that catered for every level of computer literacy!

Read Full Testimonial

IKON Dental Suite Testimonial – helping train staff in Microsoft Office

We wanted to share a quick note and let you know that you did a really good job on giving us the training that we need for Excel and PowerPoint.

As we all know these both are big topics which suit every company differently. We cannot thank you enough for taking the time to tailor this course to our needs.

John is an excellent trainer and very generous with his tips. We were also very impressed by the excellent and efficient before and after communication in between us.

The whole team benefitted greatly from the day. We are looking forward booking more courses provided by you.

Read Full Testimonial

Rea Valley Tractors – Excel training courses to enhance staff skills

John delivered the session in a relaxed manner. He ensured that all abilities were catered for and that people were learning at their own pace.
For the employees that needed a little more time, they did not feel pressured to move on and for the employees that were a little more advanced, John demonstrated some great tips and tricks!!
The day sessions were interesting, enjoyable and well planned. We can totally recommend this course and have booked for future intermediate training and an advanced bespoke course.

Read Full Testimonial

Ashorne Hill – Training staff in Excel, Word and PowerPoint

Excellent training delivery, courses being small in numbers worked very well for our staff, giving them time for any additional questions/content.
Smooth process from start to finish and excellent that trainers could provide individual laptops for staff that didn’t have their own.
Very informative training – we like the fact we can keep notes to refer back to while at work

Read Full Testimonial

Microsoft training experts for you | JPL IT Training Limited

John and Rachel developed some customised training to meet a particular need (computer awareness). I was impressed with the service we received from start to finish, the training met our needs and we had extremely positive feedback from the delegates, in particular about the trainers’ style and delivery.

Read Full Testimonial