Basic Excel Training Course

Our Basic Excel training course can be carried out in all versions of Microsoft.

All of our Microsoft Excel training 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.

FAQs

How is the Basic Excel training course structured?
We cover a variety of topics in our basic Excel course. The topics are structured to build on throughout the day. There is also a mid morning break, lunch break and mid afternoon break planned in to make sure that it isn’t too much information for you in one go.

 

Does the training cover the latest Microsoft Office 365 updates?
Definitely. The majority of the content of our Excel training courses transfers across and is compatible with any future updates of Microsoft 365. As well as this though, all of our Excel 365 training courses are reviewed regularly to ensure any new tools and features are not missed out.

 

How can Microsoft Excel training benefit my business?
Excel is one of the most widely used Microsoft packages and so training in it will benefit any member of staff greatly. It can increase your team’s productivity, develop existing data analysis skills further and strengthen their ability to communicate effectively, helping your business stand out in any industry.

 

How do I know if this is the right level course for my Excel training needs?
You will be the best person to know what your knowledge of Excel is. We say that a good indicator of your level, is that if you know at least 80% of the content covered confidently then you are ok to go on the next level course. However if you are unsure, we suggest it is best to do the level to make sure you are confident enough to move onto the next one.

 

Comments and Testimonials

Microsoft Office Access – supporting your business development

John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.

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

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

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

Rea Valley Tractors – Excel training courses to enhance staff skills

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