Aims & Objectives

To become an effective user of Excel and to get the best out of your data and calculating totals this course is for you. The magic of Excel lies in the use of formulas and how to fix or leave them moveable. During this hands-on session, you will gain valuable skills about how to create different types of calculations using formulae and functions.

This session is designed for those people who already have a basic understanding of Excel.

What will I learn?

Introduction to Formulae and Functions

  • Use arithmetical operations to create simple calculations including percentages
  • Understand the order of calculation
  • Create simple formula using brackets
  • Use quick functions to calculate the Total, Mean, Highest and Lowest of a range of data
  • Use relative and absolute cell references in calculations
  • Use the Name Box to name a cell and use this in a formula
  • Automatically fill a range of cells with a series of data
  • Edit and interpret existing spreadsheet data.

How We Deliver

We currently deliver all training online to comply with the Government's guidelines.

Online training works well for businesses whose staff are mainly working from home.

It allows us to train all of your staff with the same training needs at the same time. Your people simply log on from home, using details provided in advance by our team.

Choose from Watch and Learn sessions for larger groups or interactive hands on sessions for smaller groups.

When permitted we also offer face to face training at your offices.

All sessions can be customised to a half day or 90 minute sprint session and tailored to fit your needs, covering the topic(s) within a course that are most important to your business.

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)