Course Details

MS Excel (Developing Formulas) Thurs May 29th 2014
The registration period has expired.
Category:
Information Technology
Course aim:
This course is aimed at staff who already use Excel and wish to develop their analytical skills using formulas and functions.
Target group:
Existing users of Excel.
Content:

  • Overview of basic formulas

  • Using Absolute Cell References in formulas

  • Working with functions - Average, Maximum, Minimum, Count

  • Rounding Errors

  • Conditional Functions - If, And, Or, SumIf, CountIf

  • Conditional Formatting

  • Setting up and using Lookup tables - Vlookup and Hlookup

Prerequisites:
Intermediate level Excel.
Start date (yyyy-mm-dd):
May 29, 2014
Duration:
1 days
Time:
9.30am - 1.00pm
Organiser:
Organisation & Staff Develoment, Human Resources
Venue:
PC Suite, Nursing and Midwifery Library Extension, Basement level, JHL.
Deadline:
14 days before
The registration period has expired.

Back