Virtual Basic Excel Training Course Content

Our virtual basic Excel training course can be run in all versions of Microsoft.

All of our Excel courses are full day courses, and they typically run from 9:30am to 4pm. To break up this long day we allow two coffee breaks and a lunch break throughout the day. Even though we have set timings for the course on our agendas, we can alter them to fit in with your needs. As well as our standard course agendas, we can also create a bespoke course for you tailored to the training needs you have. Just let us know what you need, we’d be happy to help.

Key Content

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

 

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

Course Objectives

The objective of this basic Excel course is to allow the trainee to be able to build and edit individual worksheets through learning formatting skills of cells and columns. As well as formatting skills, knowledge of simple mathematical symbols and simple functions in Excel will be developed. Finally the conditional formatting feature will be covered alongside navigational features like freeze panes and hiding.

Comments and Testimonials

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

Microsoft training experts for you | JPL IT Training Limited

John and Rachel developed some customised training to meet a particular need (computer awareness). I was impressed with the service we received from start to finish, the training met our needs and we had extremely positive feedback from the delegates, in particular about the trainers’ style and delivery.

Read Full Testimonial

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

Woodgreen – Helping pets and their people – Bespoke Access training course

We were looking for a tailored Access database training course and John was able to accommodate our requirements with ease and offer flexibility which was just what we wanted.
The pace of the training was spot on. It was informative and interactive and we felt comfortable in asking questions.
John was very patient and we all learnt a lot. The day just flew by which just shows how much we enjoyed the day and the content and support given. Thank you John!

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