Course Details

MS Excel 2010 (Developing Formulas) (Wed March 19th 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):
Mar 19, 2014
Duration:
1 days
Time:
9:30a.m. - 12:30p.m.
Organiser:
Organisation and Staff Development
Venue:
Nursing & Midwifery PC Suite, Basement level in the Nursing & Midwifery Library Extension
Deadline:
4 days before
The registration period has expired.

Back