Basic Excel Training Course Content

Our Basic Excel training course can be carried out in the following versions: 2010, 2013, 2016 and 365.

All of our courses are full day courses, typically running from 9:30am to 4pm with two coffee breaks and a lunch break throughout to break up the course. Timings can be slightly flexible though to fit in with your needs. We can also create a bespoke course to tailor the contents of the course to your needs. Just ask, we’d be happy to help.

Key Content

The key content that is covered in the course can be found below:

The Excel Screen Environment
Ribbons, Tabs, Customisation
Selecting Cells
Entering Text and Numbers. Cell formatting
Editing, Cut, Copy, Paste
Formatting Text. Cell styles
Shading and borders
Inserting rows and columns
Simple Formulae. Autosum, Percentages
Headers & Footers
Common Functions
Differences between Relative & Absolute References
Page setup, Printing & Zoom
Other Simple Functions for example hiding, freezing, conditional formatting
Exercises throughout

Course Objectives

The objective of this course is to enable the trainee to create and format individual worksheets learning how to use simple cell and column formatting skills. In addition there will be considerable emphasis placed upon the simple mathematical symbols and simple functions used in Excel. Navigational procedures like hiding and freezing will be covered along with conditional formatting.

UCB – delivering all Microsoft Office courses to staff

My colleagues at UCB have nothing but praise for John and his team. John’s training is excellent and his advice on Microsoft packages has been valuable to us. I highly recommend JPL Computer Services Limited as a training provider and look forward to the next training that we will arrange.

Read Full Testimonial

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

Caldwell UK & Cotswold Architectural Products Ltd – Training Staff in Microsoft 365

We have used JPL training throughout the past year to help improve our teams Excel skills, and we all really enjoyed the training. Both online and on site.
John and Rachel show great patience and can really pin point individual needs. All of our departments have benefited from the training, and we are already looking for our next opportunity to extend our skills with JPL.

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

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. Recently John & Rachel have been carrying out training for our Kickstart Employee in Word, Excel, PowerPoint & Publisher, which has helped her gain a lot of confidence in using the Microsoft Packages. We were also lucky enough to have John carry out a bespoke Advanced Word course for 2 other members of the team which was in depth and very helpful. 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

Basic Excel Training Course

Our Basic Excel training course can be carried out in the following versions: 2010, 2013, 2016 and 365.

Key Content

Course Objectives

Comments and Testimonials

UCB – delivering all Microsoft Office courses to staff

Snow Business testimonial – working alongside staff in Excel

Caldwell UK & Cotswold Architectural Products Ltd – Training Staff in Microsoft 365

Harvey and Brockless – working alongside JPL for training needs

Redwing Solutions – Training Staff in Microsoft 365

Cookie control