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

Snow Business testimonial – working alongside staff in Excel

The session was very well structured with a good combination of theory and practical work. It was very useful to do individual examples of each task and the course notes are thorough without being confusing. John was a great teacher and catered for all knowledge levels. The pace of the day was great, at no point did we feel John was moving on too quickly but the sessions didn’t ‘drag’.

Read Full Testimonial

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

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

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

Chamber of Commerce – Excel training for ISO

JPL IT Training provided Excel training for ISO at the Herefordshire and Worcestershire Chamber of Commerce. The course was Intermediate Excel and 10 people attended and gave us great feedback on their Linked In profile.
John Legge has been an absolute dream of a trainer and made it so engaging that we didn’t even notice how the evening came!
Safe to say that we now know all about Fn button (and yes, we love it) and Control + Strange Button! Most of us had a very basic knowledge of Excel and we have definitely gained an in-depth knowledge and learned a lot that we haven’t known before!

Read Full Testimonial