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

Redwing Solutions Ltd – Training staff in Excel, Word and PowerPoint

JPL’s training courses have been brilliant for us. John delivers the courses in an informative, helpful and extremely friendly manner.
Each element of the courses is explained clearly and makes sure that everyone understands before continuing. Each course is gone through at your own pace, so it never feels rushed or overwhelming.
Furthermore, John is always personable and makes sure the courses are always an enjoyable and friendly experience.

Read Full Testimonial

Chamber of Commerce – Excel Training for Forest Garden Group

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

LPR – Helping train staff in Excel

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

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

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