Intermediate Excel Training Course

Our Intermediate Excel training course can be carried out in all versions of Microsoft.

All of our Microsoft Excel training 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
  • Highlighting and removing duplicates
  • Absolute References in formulas. Named cells and Ranges
  • Complex formulae e.g. IF
  • 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.

FAQs

Does the training cover the latest Microsoft Office 365 updates?
Yes it does. Most of the content of our Excel training courses transfers across and is compatible with any future updates of Microsoft 365. We also regularly review all of our Excel 365 training courses to ensure any new features and tools are not missed out.

 

How is the Intermediate Excel training course structured?
Our Intermediate course builds on and covers topics from the basic course in more detail. We do also cover some new topics too. The topics are organised to build on throughout the day. There are 2 short breaks, one mid morning and one mid afternoon, and lunch break planned in to break up the whole day course.

 

How do I know if this is the right level course for my Excel training needs?
As this is the Intermediate level course, you will be a regular user of Excel in your work. To know if this is the right level, have a look at the content on the basic course and if you know at least 80% of it confidently then you are ok to do this level. If you are unsure, we advise it is best to do the basic level first to make sure you are confident enough to benefit from this level.

 

How can Microsoft Excel training benefit my business?
Excel is used by businesses in all sectors and so any training will benefit your members of staff greatly. There are many benefits including increasing your team’s productivity, strengthening abilities for effective communication and developing existing data analysis skills further, all helping your business stand out in any industry.

 

Comments and Testimonials

The SL Shop – Training Staff in Microsoft Excel 365

JPL came out to the SL Shop to give us some Excel training, we were blown away at how much we learnt on the intermediate course. What we have learnt is already being put into action throughout the company to streamline our processes. Advanced course booked and we are very excited. Great courses and an even greater teacher, thanks John.

Read Full Testimonial

Build It International testimonial – helping those that help others

Thanks to @johnlegge for our recent Excel training session helping us to manipulate data quicker and more effectively 📊📈 Lots of really useful hints and tips that we’ve already been putting into practise! #MasterYourData 🤓 #BuildingBrighterFutures

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

Redwing Solutions – Training Staff in Microsoft 365

Both John & Rachel have provided 1-2-1 training for our team for several years and each time the training has been excellent and informative.
Both John & Rachel’s training skills and techniques are fantastic, and they are both extremely patient and conscientious throughout the day, ensuring that everyone understands each section before moving on to the next.
We would highly recommend JPL to anyone wishing to get themselves & their team up to date with any IT training!

Read Full Testimonial

Harvey and Brockless – working alongside JPL for training needs

We have worked with John for a number of years now in group environments from basic to masterclass levels, and in 121 sessions tailored around our specific requirements. We’ve seen in this time, our staff grow in confidence and ability through John’s tuition, which has in turn benefitted our company and our staffs’ own development.

Read Full Testimonial