Description
COURSE OBJECTIVE:
This course will furnish you with the skills to build formula using the
built in functions for calculating dates. This course is the third in
the series of formula courses.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheet formulae.
PREREQUISITES:
Participants should be able to perform the following tasks without
assitance:-
• Create formula using basic function such as SUM, AVERAGE etc
• Fix a cell reference within a formula (absolute cell referencing)
• Use the Formula Auditing Tools
To gain these skills we recommend that you attend the following course
first:-
Excel Formula Part 1 (to learn basic formula & functions)
CONTENT
• Date Functions (TODAY, DAY, MONTH, YEAR, DATE, DATEVALUE, EDATE,
DATEDIF, EOMONTH, WEEKDAY, WORKDAY & NETWORKDAYS)
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
