Excel3: Using formulae (Tue 18 Nov 2025 15:00-16:00) - York FT208

Audience: All YSJ students and staff

Format: One hour in person on York Campus

Prior knowledge: A good knowledge of common Excel features

Excel3 is in our series of five Excel courses designed to cover all the key aspects of Excel. The other individual sessions can be booked according to your interests and do not have to be taken in order although we do recommend Excel1 before the others.

We have the same courses Excel Video Courses on YouTube.

If you are interested in a MOS (Microsoft Office Specialist) qualification, then the five courses cover most of the MOS objectives in an introductory manner. There is an additional MOS Excel course to cover further MOS skills.

This course includes:

• Define named range and navigate to it
• Insert relative, absolute, and mixed references including named ranges
• Paste data by using special paste options
• Use structured references and brackets in formulae
• Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Count cells by using the COUNT(), COUNTA(), COUNTBLANK() and COUNTIF() functions
• Trapping errors using IFERROR()
• Perform conditional operations by using the IF() function