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

IKON Dental Suite Testimonial – helping train staff in Microsoft Office

We wanted to share a quick note and let you know that you did a really good job on giving us the training that we need for Excel and PowerPoint.

As we all know these both are big topics which suit every company differently. We cannot thank you enough for taking the time to tailor this course to our needs.

John is an excellent trainer and very generous with his tips. We were also very impressed by the excellent and efficient before and after communication in between us.

The whole team benefitted greatly from the day. We are looking forward booking more courses provided by you.

Read Full Testimonial

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

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

Move With Us testimonial – helping train staff in Excel

I had a workshop session with John on a survey report that was taking a considerable amount of time to complete. John explained to us that if we changed how we were initially setting out the data that the production of reports and pivot tables would be much quicker.

The Excel training we had over the course of the next two days was fantastic. John managed to keep us all focussed, he is a very engaging trainer. We were all eager to get back to our desks and start implementing what we’d learnt to make our report running much more efficient.

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