Self Teach Excel Training Videos Demo

We are now selling ‘Self Teach’ video and Microsoft Excel training packages to run alongside our courses or to be used independently.

These will be contained in easy to use PowerPoint presentations with a video tutorial, exercise and answer sheet per slide. There will be several slides per Excel level. The levels are: basic, intermediate and advanced. An example to illustrate is shown below in the demo videos and exercises.

Once you have watched the tutorials, you can then try out the exercise found below the video (there is a Question sheet which you can try first and then check your ‘Answers’ using the A sheet). To make the video bigger you can click on the ‘YouTube’ text to view the video on YouTube. We hope you enjoy them!

Purchasing Training Levels

If you have found any of the videos above interesting and have left you wanting to learn more about Excel, then why not ask us about purchasing any or all of the levels? If you like the look of the videos but would like a bit more of an in depth learning experiencing then why not ask us about our day courses that we offer?

For more information on these self teach packages or for any information on our day courses, contact John at johnlegge@jplcomputer.co.uk or on 07903 840105

Basic Excel

To view summary of key content, click here.

Please see the video below for the tutorial of how to use cell formatting.

Cell Formatting Exercise

Intermediate Excel

To view summary of key content, click here.

Please see the video below for the tutorial of how to use sorting in Excel.

Sorting Exercise

Advanced Excel

To view summary of key content, click here.

Please see the video below for the tutorial of how to use CONCATENATE in Excel.

Concatenate Exercise

Comments and Testimonials

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

Harvey and Brockless – working alongside JPL for training needs

We have worked with John for a number of years now in group environments from basic to masterclass levels, and in 121 sessions tailored around our specific requirements. We’ve seen in this time, our staff grow in confidence and ability through John’s tuition, which has in turn benefitted our company and our staffs’ own development.

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

MonoSol AF Limited – Helping train staff in Microsoft 365 packages

“We would highly recommend JPL IT Training. We have been using JPL IT Training for several years now and would not consider booking with anyone else.
John and Rachel are excellent trainers and the feedback from employees is always great. They have delivered Excel, Word and Access courses at all levels both face to face and remotely.
The sessions are always interactive and informative, and you leave them knowing much more than you did at the start. In group sessions they have the ability to adapt to each learner and ensure everyone gets the level of attention they need which is important as no one gets left behind”

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