Excel3: Using formulae  (Tue 18 Nov 2025 15:00-16:00) - York FT208, 18 November | Event in York | AllEvents

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

Digital Training - Library & Learning Services

Highlights

Tue, 18 Nov, 2025 at 03:00 pm

1 hour

FT208, Fountains Learning Centre

Free Tickets Available

Advertisement

Date & Location

Tue, 18 Nov, 2025 at 03:00 pm to 04:00 pm (GMT+00:00)

FT208, Fountains Learning Centre

FT208, York, United Kingdom

Save location for easier access

Only get lost while having fun, not on the road!

About the event

Excel3: Using formulae (Tue 18 Nov 2025 15:00-16:00) - York FT208
This course will help you understand and build more complex formulae to create active worksheets using structured references.

About this Event

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


Also check out other Workshops in York.

interested
Stay in the loop for updates and never miss a thing. Are you interested?
Yes
No

Ticket Info

Tickets for Excel3: Using formulae (Tue 18 Nov 2025 15:00-16:00) - York FT208 can be booked here.

Ticket type Ticket price
YSJ only - course place Free
Advertisement

Nearby Hotels

FT208, Fountains Learning Centre, FT208, York, United Kingdom
Register for Free
Ask AI if this event suits you

Host Details

Digital Training - Library & Learning Services

Digital Training - Library & Learning Services

Are you the host? Claim Event

Advertisement
Excel3: Using formulae  (Tue 18 Nov 2025 15:00-16:00) - York FT208, 18 November | Event in York | AllEvents
Excel3: Using formulae (Tue 18 Nov 2025 15:00-16:00) - York FT208
Tue, 18 Nov, 2025 at 03:00 pm
Free