Description
COURSE OBJECTIVE:
This online Excel course explores how to work effectively with dates and
times, helping participants perform date-based calculations and manage
schedules more efficiently.
Learners will use common date functions such as TODAY, NOW, DATEDIF,
YEAR, MONTH, and DAY to analyse and calculate dates, as well as create
and format timelines to visually track projects, deadlines, and key
milestones.
The course provides practical techniques for organising time-sensitive
information and producing clear, professional schedules and plans.
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)
To gain these skills we recommend that you attend the following course
first:-
Excel Undertstanding Formula (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
|
