Basic Excel Training Course

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.

Comments and Testimonials

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

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

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

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

Ashorne Hill – Training staff in Excel, Word and PowerPoint

Excellent training delivery, courses being small in numbers worked very well for our staff, giving them time for any additional questions/content.
Smooth process from start to finish and excellent that trainers could provide individual laptops for staff that didn’t have their own.
Very informative training – we like the fact we can keep notes to refer back to while at work

Read Full Testimonial