Virtual Intermediate Excel Training Course

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

All of our Excel courses are full day courses and they normally run from 9:30am to 4pm. We allow for two coffee breaks and a lunch break throughout the day to break up the course. Although these are our standard timings, we can alter them to fit in with your needs. As well as our standard course agendas we can put together a bespoke agenda to accommodate your training needs. Whichever you require just ask, we’d be happy to help.

Key Content

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

 

  • Charts – chart sheets, formatting and protection
  • Sorting and Custom Lists. Advanced sorting
  • Auto, Custom and Advanced Filtering of a list
  • Subtotalling using command button
  • Complex formulae e.g. IF, Problem Solving
  • Absolute References in formulas. Named cells and Ranges
  • Miscellaneous features remove duplicates, evaluate formulas
  • Formula auditing
  • Multi File linking and consolidation
  • Group sheet selection
  • Locking Cells and password protection
  • Using SUMIF and COUNTIF functions
  • Exercises throughout

Course Objectives

The objective of this course is to equip the trainee with the knowledge of regularly used features in business. Some of the features covered are creating Charts, Sub Totalling, Sorting and Filtering. Trainees will be able to learn and develop skills through the use of problem techniques like relative and absolute referencing and the IF statement. Finally the course will cover the use of multi sheet and workbook summaries.

Comments and Testimonials

Chamber of Commerce – Excel training for ISO

JPL IT Training provided Excel training for ISO at the Herefordshire and Worcestershire Chamber of Commerce. The course was Intermediate Excel and 10 people attended and gave us great feedback on their Linked In profile.
John Legge has been an absolute dream of a trainer and made it so engaging that we didn’t even notice how the evening came!
Safe to say that we now know all about Fn button (and yes, we love it) and Control + Strange Button! Most of us had a very basic knowledge of Excel and we have definitely gained an in-depth knowledge and learned a lot that we haven’t known before!

Read Full Testimonial

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

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

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

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