Course Details

MS Excel (Developing Formulas) Tues June 17th 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):
Jun 17, 2014
Duration:
0 days
Time:
9:30a.m - 1:00p.m
Organiser:
Organisation & Staff Development, Human Resources
Venue:
PC Suite, Nursing and Midwifery Library Extension ,James Hardiman Library
Deadline:
14 days before
The registration period has expired.

Back