Event box

Excel3: Using formulae   (Wed 10 Aug 2022 14:00-15:00) - York Campus

Excel3: Using formulae   (Wed 10 Aug 2022 14:00-15:00) - York Campus In-Person

This course is for staff and students of York St John University only.

Format: One hour hands on, in the Library on the York Campus.

Prior knowledge: A good knowledge of common Excel features 

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

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 

 

Date:
Wednesday, August 10, 2022
Time:
2:00pm - 3:00pm
Time Zone:
UK, Ireland, Lisbon Time (change)
Location:
FT/208 - 2nd floor York Fountains library - far end from lift
Audience:
  Staff     Students  
Categories:
  Excel courses  
Registration has closed.

This course is for staff and students of York St John University only.

This will take place in the Library on the York Campus.

Event Organizer

Profile photo of Digital Training
Digital Training

Hands-on, focussed courses in popular IT. Available on campus and online.

More events like this...