Browse courses

Book your training course

Feefo logo

In-house training

  • This training course can be tailor-made and delivered in-house for up to 8 people. Held online via our virtual classroom or where safe to do so, at your premises or a nearby venue.
  • £1245 (+VAT & Travel)

Scheduled course

  • Sorry, there’re no scheduled courses at the moment. Get notified via email when a course at a one of our venues takes place.
Get notified

Why book this course?

Spreadsheets are the backbone of many a workplace, and Microsoft Excel is the spreadsheet software of choice. Whether you’re making timetables, logging contact details, creating reports or tracking expenditure, Microsoft Excel has a myriad of different uses, and is essential for anyone performing office work.

Our highly practical Microsoft Excel for Beginners course introduces you to this integral part of the Microsoft Office suite. Coordinating with our expert tutors, you’ll familiarise yourself with Excel’s software environment, and learn the essential skills you’ll need to create and format spreadsheets with confidence.

Who is the course for?

While it is preferable that you have some keyboard and mouse skills, there are no real prerequisites for this course. It is designed to introduce anyone who is unfamiliar with Excel to how the software functions, and impart basic skills that will be valuable to almost any office or digital media role.

Learners on our Microsoft Excel for Beginners course will learn to produce simple spreadsheets with basic formulae, produce basic charts, and structure and layout their spreadsheets in a neat and visually pleasing way. The course is ideal for anyone who uses Excel sporadically, or as a preamble to a more advanced course.

What content will the course cover?

  • Screen Elements

  • Customising the Quick Access Toolbar

  • Use mouse shortcut menus and keyboard shortcuts

  • Understanding worksheets, columns, rows and cell referencing

  • The formula bar, status bar and name box 

  • Using the New Help Feature


  • Entering different data types, text, values, dates

  • Editing cell contents and simple corrections, spell checking

  • Deleting cell contents and undo/redo

  • Using AutoFill and Auto Calculate and FlashFill

  • Cut/copy and paste – understanding the clipboard

  • Save, close and open workbooks

Calculations – Formula and Functions

  • BODMAS – The order of calculation

  • Relative, absolute cell referencing, fixing cell references

  • Arithmetic calculations and operators

  • Simple functions – sum, average etc.

  • Create and use range names


  • Moving/copying rows and columns

  • Adjusting/deleting column and row dimensions

  • Aligning cell content and text and number formatting


  • Set up page breaks and use print preview and page break preview

  • Page set-up options, headers and footers

**Introduction to Charting

What will I get out of the training?

Learners on our Microsoft Excel for Beginners course will gain an understanding of the functions of Microsoft Excel, and be able to work more effectively in the software. You’ll learn how to create, edit, format and print professional spreadsheets quickly and easily, as well as using some basic formulae and understanding the principles of calculation.

At Kent Trainers, we’re proud to tailor our training to the needs of  businesses across the region. By working closely with our trainers and undertaking practical exercises, you’ll be able to ask questions and get answers that pertain to your work. By the end of your course, you should have an understanding of Excel that addresses everything you need from the software.

What is the duration of this course?

This is a 1 day course.

The timings and format for our courses are as follows:

  • Scheduled training courses held virtually

Unless specified, courses commence at 9:30am and finish at approximately 4:00pm.  The day is broken up into modules, both online and offline to ensure engagement and interaction.  We also ensure that there are plenty of comfort breaks throughout the day.

  • Scheduled training courses held at one of our venues

Courses commences at 9:30am and finish at approximately 4:30pm. On all our scheduled courses, a hot lunch is included, and refreshments are provided throughout the day.

  • In-house & bespoke courses, held virtually or at a venue of your choice

For all in-house training courses, we will adapt the timings and format for the day around the needs of your team and business. Please contact us to discuss your requirements.

Ready to book onto your course?

Let get you started by choosing what booking option is the best option for you.

Choose booking

Want 10% off your first scheduled course?

Sign up to our newsletter and receive 10% off any of our scheduled courses as a thank you! Our monthly newsletters are filled with features, advice and information about our forthcoming courses.