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

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

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

Chamber of Commerce – Excel Training for Baylis & Harding

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

Carpet & Flooring – Helping train staff in Microsoft 365 packages

JPL created and conducted a bespoke Excel training program based on our requirements, and both John and Rachel exceeded our expectations in the delivery of this. Delegates were from a variety of departments and had varying levels of experience, yet John and Rachel were accommodating and engaging to ensure this training was effective to all. The team found the training informative, useful to their day job, and fun, and look forward to participating in future courses 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