Virtual Advanced Excel Training Course Content

Our virtual Advanced Excel training course can be carried out in all Microsoft versions.

All of the courses we offer are full day courses which run from 9:30am to 4pm with a lunch break and two coffee breaks to break up the day. Even though these standard timings are used most of the time, we can alter them to fit in with your needs. As well as this we can create a bespoke course for you to be tailored to your training needs. Whether it is a standard or bespoke course you require, just ask us as we’d be happy to help you.

Key Content

All of the key content that is covered in the virtual course can be found below:

 

  • More Complex Charts
  • Using Text functions
  • Date and Time functions
  • Using Logical functions
  • Advanced Filtering of a list. Unique Lists
  • Absolute references in Complex Problem Solving
  • VLOOKUP and nested VLOOKUP – ranges
  • Advanced IF function – problem solving
  • Data Validation – Lists and Values
  • Simple macros. Editing Macros
  • Pivot Tables and Charts
  • Exercises throughout

Course Objectives

The objective of this course is to equip the attendee with understanding of more complex Excel features. Some features included are the creation of complex charts, text and logical functions, advanced filtering and the analysis of unique lists. As well as all of this VLOOKUPs, nested statements, Macros and Pivot Tables will also be covered.

Comments and Testimonials

VSMPO Tirus UK Ltd – Training Staff in Excel 365

Our company have used JPL for both Intermediate and Advanced Excel courses. Both John and Rachel made the courses not only easy to understand but fun as well.
Both courses were well received by all staff attending. We will definitely be booking JPL again for any future courses required.

Read Full Testimonial

Caldwell UK & Cotswold Architectural Products Ltd – Training Staff in Microsoft 365

We have used JPL training throughout the past year to help improve our teams Excel skills, and we all really enjoyed the training. Both online and on site.
John and Rachel show great patience and can really pin point individual needs. All of our departments have benefited from the training, and we are already looking for our next opportunity to extend our skills with JPL.

Read Full Testimonial

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

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

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