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

Move With Us testimonial – helping train staff in Excel

I had a workshop session with John on a survey report that was taking a considerable amount of time to complete. John explained to us that if we changed how we were initially setting out the data that the production of reports and pivot tables would be much quicker.

The Excel training we had over the course of the next two days was fantastic. John managed to keep us all focussed, he is a very engaging trainer. We were all eager to get back to our desks and start implementing what we’d learnt to make our report running much more efficient.

Read Full Testimonial

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

LPR – Helping train staff in Excel

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

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