Excel: advanced (January)

Learn advanced Excel techniques including the IF, IFERROR, HLOOKUP and VLOOKUP functions

  • 9 Jan 2019, 10.00am to 9 Jan 2019, 12.00pm GMT
  • Room to be confirmed, University of Bath
  • This event is free

About the workshop

This course will show you how to use conditional formulae and formatting that will automatically decide what information or formatting to put into cells, based on the rules applied to them. You will also learn how to use HLOOKUP and VLOOKUP to return information displayed in other lists within a formula.

The course assumes you already have a good working knowledge of Excel including basic Functions & Formulas.

Learning outcomes

After completing this course, you will be able to:

  • create an IF function to display text or to calculate values
  • create a nested IF function
  • use the IFERROR function
  • use an AND, OR and NOT statements
  • use the COUNTIF and SUMIF functions
  • create a HLOOKUP function (using a horizontal table)
  • create a VLOOKUP function (using a vertical table)
  • edit LOOKUP functions
  • use Lookups to display exact matches
  • use Lookups to display non-exact matches
  • understand Reference Functions
  • use ROW, COLUMN and ADDRESS

Speaker profiles

John Baker

Who should attend

Doctoral students

Booking details

Register for this event

Location


Room to be confirmed University of Bath Claverton Down Bath BA2 7AY United Kingdom

Enquiries

If you have any questions, please contact us.