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

Direct Air Testimonial – helping train staff in Microsoft 365 packages

JPL IT Training has provided exceptional remote training for members of our Sales & Marketing team. The team had varying levels of Microsoft knowledge, so the training covered Word, Excel and PowerPoint. All of the team found the courses they attended really useful. As a result they have been implementing key takeaways in their day-to-day work such as shortcuts and formatting tools. The training was 1-2-1 and very flexible to each learners’ requirements. This style was a fantastic method of training for our business. Thank you to John & Rachel!

Read Full Testimonial

Redwing Solutions – Training Staff in Microsoft 365

Both John & Rachel have provided 1-2-1 training for our team for several years and each time the training has been excellent and informative.
Both John & Rachel’s training skills and techniques are fantastic, and they are both extremely patient and conscientious throughout the day, ensuring that everyone understands each section before moving on to the next.
We would highly recommend JPL to anyone wishing to get themselves & their team up to date with any IT training!

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

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

Woodgreen – Helping pets and their people – Bespoke Access training course

We were looking for a tailored Access database training course and John was able to accommodate our requirements with ease and offer flexibility which was just what we wanted.
The pace of the training was spot on. It was informative and interactive and we felt comfortable in asking questions.
John was very patient and we all learnt a lot. The day just flew by which just shows how much we enjoyed the day and the content and support given. Thank you John!

Read Full Testimonial