Course selection
Microsoft Excel: Creating and Using Formulae
Audience: Academic staff, PG research, Professional staff, Research staff, Research supervisors
Date: Tuesday 22 July 2025
Times: 13.00 to 14.30
Key details: Live in-classroom session: Introduces working with calculations in spreadsheets. (WBH-Eden Campus)
Qualifications needed
Have attended "Introduction to Excel: Managing data" OR you should already be familiar and comfortable with entering and manipulating data in Excel with an understanding of data types and number formatting.
Follow on course
Microsoft Excel: Using Functions
Course information
This course introduces key principles and skills required in working with calculations in spreadsheets. It is aimed at those already familiar with the basics of using the Excel interface.
Skills covered include:
- formula basics
- understanding cell and formula referencing
- creating a range of formulae types
- using basic Excel functions
- formulae auditing tools
- error checking
What previous partiocipants have said:
- "Even if you think you already have a basic understanding of any software it is always worthwhile to attend one of these courses as there is so much more you can learn."
- "This has given me confidence to use formulae in my work when I might have tried to do everything manually before"
- "Applied immediately to my current excel sheets."
Based on Excel M365 for Windows
NOTE: These are live sessions requiring attendance at the stated venue.
These courses are NOT open to those on Undergraduate or Taught Postgraduate programs.
Tutors
Sonny Evans
Venue
Walter Bower House, Eden Campus, Guardbridge - IT Classroom
Course provider
IELLI
Email: ielli@st-andrews.ac.uk