EX3: Using Excel formulae (Wed 1 Feb 13:30-14:30)
Free
EX3: Using Excel formulae (Wed 1 Feb 13:30-14:30)

EX3: Using Excel formulae (Wed 1 Feb 13:30-14:30)

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

Friends Who Are Going
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
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