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

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

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 Excel Courses at AFH Wealth Management

John is an excellent trainer and has helped many of our staff members become competent users of Excel, which has ultimately improved efficiencies when performing their job roles. John’s “learn by doing” style of teaching is very effective as it enables the trainees to get hands-on experience while they develop their skills within the system.

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

Direct Air Testimonial – helping train staff in Microsoft 365 packages

JPL IT Training has provided exceptional remote training for members of our Sales & Marketing team. The team had varying levels of Microsoft knowledge, so the training covered Word, Excel and PowerPoint. All of the team found the courses they attended really useful. As a result they have been implementing key takeaways in their day-to-day work such as shortcuts and formatting tools. The training was 1-2-1 and very flexible to each learners’ requirements. This style was a fantastic method of training for our business. Thank you to John & Rachel!

Read Full Testimonial