Broadcast: Events

Excel 2016 - Functions

Tuesday 28 August 10:00 until 12:00
Shawcross Training Room
Speaker: Adrian Chorlton

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: Tuesday, 24 July 2018

Share: