Computer Tutoring Logo

Flexible Training Options

Choose a single focused 90-minute session, combine several sessions into a short course, or ask us about ongoing training support for your team.
  • Focused 90-minute sessions for specific skills
  • Grouped sessions to build a complete learning path
  • Ongoing support options for teams who need regular help
Tell us what you need

Tell Me More






First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

Testimonials

HOPPE UK

"Fantastic really informative and interesting" "Excellent very enjoyable really good presenter"

St Johns Packaging (UK) LTD

"The training was highly beneficial and significantly enhanced my Excel skills. Simon was an engaging and approachable instructor, it was an absolute pleasure to learn from him."

Hahnemuehle

"Really good and really informative. Would recommend to a company needing excel training."

Ottolenghi Ltd

"I found the basic excel training useful and excel cheatsheet is very handy. I learnt some new things from the exercise and looking forward to the next session. "

This course in other locations

Learn Excel Basics in 90 Minutes - Part 2: Working with Formulas

Learn Excel Basics in 90 Minutes - Part 2: Working with Formulas Overview

This Excel training session builds on the basics by helping you work more efficiently with calculations. In just 90 minutes, you will learn how to create reusable formulas, understand how Excel references work, and use key functions to improve accuracy and speed.

Excel Beginners Training Series

What You'll Learn

  • Use simple calculations like adding, subtracting, multiplying and dividing
  • Understand how Excel remembers and uses cell references
  • Create formulas you can copy instead of typing again and again
  • Use key functions like SUM, AVERAGE, MIN and MAX
  • Work faster while reducing mistakes in your spreadsheets

Who This Course Is For

  • Users who understand basic Excel but want to improve confidence
  • Anyone working with numbers, calculations or reports
  • People who want to reduce manual work in spreadsheets

Course Duration: 90 Minutes

Course Prerequisites

  • Basic Excel knowledge such as entering data and simple formulas
  • Familiarity with the Excel interface

Not sure which version of Excel you have?
Go to File > Account to check your version.

Complete Course Outline

Working with Formula

  • Revisiting how formulas are structured
  • Using arithmetic operators like +, -, * and /
  • Understanding and fixing common formula errors

Cell References Explained

  • Understanding relative and absolute references
  • Copying formulas correctly
  • When and why to lock cell references

Using Essential Functions

  • Working with SUM, AVERAGE, MIN and MAX
  • Using COUNT and simple logic
  • Combining functions for more powerful results

Improving Efficiency

  • Copying and filling formulas quickly
  • Reducing repetitive calculations
  • Building reusable spreadsheets

Hands-on Exercises

  • Create formulas to calculate totals and averages
  • Practice copying formulas using relative and absolute references
  • Fix common formula errors in a sample worksheet
  • Use functions to summarise data quickly and accurately

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.

Birmingham Brentwood Cambridge Coventry Guildford Ipswich Leicester Luton Milton Keynes Northampton Norwich Oxford Peterborough London (Chiswick) London (Hammersmith) London (Heathrow) London (Kensington) Reading