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

Snow Business testimonial – working alongside staff in Excel

The session was very well structured with a good combination of theory and practical work. It was very useful to do individual examples of each task and the course notes are thorough without being confusing. John was a great teacher and catered for all knowledge levels. The pace of the day was great, at no point did we feel John was moving on too quickly but the sessions didn’t ‘drag’.

Read Full Testimonial

Microsoft Excel Courses at AFH Wealth Management

John is an excellent trainer and has helped many of our staff members become competent users of Excel, which has ultimately improved efficiencies when performing their job roles. John’s “learn by doing” style of teaching is very effective as it enables the trainees to get hands-on experience while they develop their skills within the system.

Read Full Testimonial

Fatherson Bakery Testimonial – swapping baking for Excel & PowerPoint!

I worked with John and the team at JPL who created a bespoke training program for us. This was across Excel and PowerPoint to train all our teams up to a standard we needed in the business.

They have developed a Bronze, Silver & Gold 1 day course for us. This allows our team to develop their IT and use practical examples for the their day to day roles.

Feedback has been positive and we look forward to rolling out more with John in the coming months.

Read Full Testimonial

MonoSol AF Limited – Helping train staff in Microsoft 365 packages

“We would highly recommend JPL IT Training. We have been using JPL IT Training for several years now and would not consider booking with anyone else.
John and Rachel are excellent trainers and the feedback from employees is always great. They have delivered Excel, Word and Access courses at all levels both face to face and remotely.
The sessions are always interactive and informative, and you leave them knowing much more than you did at the start. In group sessions they have the ability to adapt to each learner and ensure everyone gets the level of attention they need which is important as no one gets left behind”

Read Full Testimonial

Lime Marketing – delivering bespoke training courses for staff

John has delivered Excel, Word and Outlook training to us at Lime Marketing over the last few months, he has trained around 20 employees and has created bespoke courses to suit our time, money and skill requirements. I’m pleased to say that the individual feedback from our team has been brilliant, everyone has come away feeling more confident and knowledgeable, from a business point of view it is fantastic to see employees valuing and enjoying Johns sessions and most importantly using new skills in the workplace. We look forward to continuing to work with John.

Read Full Testimonial