< Back to search results

Microsoft Excel: Using Functions

Qualifications needed

It is highly recommended that you will have attended the Creating and Using Formulae course or already have an understanding of the various types of cell referencing.

Course information

NOTE: These are in-classroom sessions delivered at the stated venue.

This course is aimed at developing skills in Excel with more complex functions used in making predictive and 'what-if' calculations and using other formulae techniques:

Skills covered include:

• using IF functions and a range of other logical functions for conditional statements
• using nested functions
• using a range of lookup and reference functions

The approach will give you confidence to explore and employ other functions in general.

It is highly recommended that you will have attended the Creating and Using Formulae course as you must have a good understanding of cell referencing.

What previous participants have said:

• "I knew some of the basic Formulae and Functions but I came away with so much more insight and ability."
• "This course taught me methods and skills which I had seen be used on other spreadsheets but never knew how to set them up myself. I feel the student has become the master and now my colleagues and friends will be coming to me and asking for help."
• "Far easier to do in-person due to the ability of the tutor to fix issues physically instead of talking someone through it."

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