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

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