Excel3: Manipulating data using formulae (Mon 5th Dec 13:30-14:30)
Event Information
Description
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