Prior knowledge: A good knowledge of common Excel features
Format: One hour hands on
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
If you can’t see the course you want scheduled or you want to request a different date/time then please contact digitaltraining@yorksj.ac.uk
