Close
Browse courses

Book your training course

  • Online

    Spaces left
    • 6th Oct 2022
    • 9:30am - 4:00pm
    • £195.00 (+ VAT)
    Book

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.
  • £1195 (+VAT & Travel)
Enquire

Can't make it? Get notified of next course

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

Editing

  • 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

Formatting

  • Moving/copying rows and columns

  • Adjusting/deleting column and row dimensions

  • Aligning cell content and text and number formatting

Printing

  • 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.

Who will train me?

Ready to book onto your course?

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

Choose booking

Associate Trainer

Sarah Aspinall

What is my experience?

I have been involved in IT Training and Development for over 18 years.  I have experience of training staff in both the Private and Public sector.  I train Microsoft and Google Products, carrying out software specific training needs analysis and advising organisations on their future training plans.

What is my area of expertise?

My training expertise focuses on all Microsoft Products, including Project, Excel, Teams, Word, Outlook, PowerPoint, Visio, Publisher.  With technology being so versatile and open to all, matter what the location, I can conduct all of my training either face to face or virtually.  As well as working with the more well established software products, I also work with companies that seek to develop and train on their own in-house systems.

Why I love inspiring others?

I love my work and get great satisfaction from unlocking knowledge and helping delegates develop a deeper understanding of what each product can help them with.  It is great to see all course participants gain new skills that will help them in all aspects of their daily life, whether that be time saving, being more productive, developing confidence or making communication much easier.

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.