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

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

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

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

Microsoft Office Access – supporting your business development

John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.

Read Full Testimonial