Free

EX3: Using Excel formulae (Tue 27 Mar 15:00-16:00)

Event Information

Share this event

Date and Time

Location

Location

ILS Training area (outside FT/120)

(1st floor near bridge to DeGrey)

Fountains Learning Centre

York St John University

YO31 7RB

United Kingdom

View Map

Event description

Description

These courses are for staff and students of York St. John University only.


EX3: Manipulating data using formulae

Prior knowledge: A good knowledge of common Excel features

This course will help you understand and build more complex formulae to create active worksheets.

Open Badge Available - Excel: Manipulating data using formulae

This course includes:

  • Understanding different cell references
  • Using named ranges
  • Order of evaluation for formulae
  • Using IF and CountIf formulae
  • Using concatenate (&)
  • String manipulation using Left, right, mid, len
  • Different types of pasting

FAQ

Is this course open to anyone?

This course is only available to students, staff and alumni of York St John University.

How can I contact the organiser with any questions?

Email digitaltraining@yorksj.ac.uk

Do I have to bring my printed ticket to the event?

No, we have a list of bookings

Share with friends

Date and Time

Location

ILS Training area (outside FT/120)

(1st floor near bridge to DeGrey)

Fountains Learning Centre

York St John University

YO31 7RB

United Kingdom

View Map

Save This Event

Event Saved