Broadcast: Events

Excel 2016 - Functions

Thursday 25 July 10:00 until 12:30
Shawcross Training Room
Speaker: Stephen Kiely

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.


By: Stephen Kiely
Last updated: Monday, 1 July 2019

Share: