Excel3: Manipulating data using formulae  (Wed 2nd Nov 15:00-16:00)
Free
Excel3: Manipulating data using formulae  (Wed 2nd Nov 15:00-16:00)

Excel3: Manipulating data using formulae (Wed 2nd Nov 15:00-16:00)

Event Information

Share this event
Date and Time
Location
Location

ILS Training area

(1st floor near bridge to DeGrey)

Fountains Learning Centre

York St John University, United Kingdom

View Map

Event description

Description

Excel3: 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

(1st floor near bridge to DeGrey)

Fountains Learning Centre

York St John University, United Kingdom

View Map

Save This Event

Event Saved