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

Shrewsbury Food Hub Testimonial – training those helping their community

Thank you John for an engaging session. It has opened our eyes to many shortcuts and features that will make our working days run smoother.
Being a small charity, we do a lot of data collection and evaluation, to show the impact of our work. John showed us useful ways to record, sort and display our data in Excel. This will save us a lot of time! Thanks John.
A clear, well-structured course that catered for every level of computer literacy!

Read Full Testimonial

Chamber of Commerce – Excel Training for Baylis & Harding

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

Carpet & Flooring – Helping train staff in Microsoft 365 packages

JPL created and conducted a bespoke Excel training program based on our requirements, and both John and Rachel exceeded our expectations in the delivery of this. Delegates were from a variety of departments and had varying levels of experience, yet John and Rachel were accommodating and engaging to ensure this training was effective to all. The team found the training informative, useful to their day job, and fun, and look forward to participating in future courses with JPL

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

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