Broadcast: Events

Excel - Functions

2 hours

This course builds on your basic Excel knowledge. You will learn how to harness the power of formulas to unlock the mathematical power of Excel.

This session will cover:

•Conditional formatting

•Absolute and relative referencing

•Defined names

•Displaying formulas

•Using the fill handle

•Order of evaluation in formulas

•Functions (Statistical, logical, lookup, maths, text, date)

•Using IF statements

•Using VLOOKUP and HLOOKUP

Prior knowledge: Excel 2016 for beginners or equivalent knowledge.

Full details available on the IT Service Training web pages.

If you wish to attend please book a place via Sussex Direct: Book now in Sussex Direct.

About IT Service courses:

•Pre-booking required

•Courses are run subject to minimum numbers

•IT Service courses are free of charge

If you are unable to make this date you may use Sussex Direct to add yourself to the waiting list and you will be advised when future dates are scheduled.

IT Services ITS-training@sussex.ac.uk

By: Samantha Elmer
Last updated: Friday, 6 March 2020