< Back to search results

Microsoft Excel: Creating and Using Formulae

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

NOTE: These are in-classroom sessions delivered at the stated venue.
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 participants 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

PLEASE NOTE: These courses are not open to those on Undergraduate or Taught Postgraduate programs.

Tutors

Sonny Evans

Venue

Butts Wynd PC Classroom: BWD 01

---

Course provider

IELLI
Email: ielli@st-andrews.ac.uk