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

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

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

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

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

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