Microsoft Excel: Date & Time Functions

This workshop covers some of the most important date and time functions used in business applications to help you create and maintain:

  • Timesheets
  • Work-logs
  • Invoices
  • Orders
  • Stock control
  • Project management activities

Skills needed:

This is an intermediate level workshop so you will be a reasonably confident user of Excel with a knowledge of how basic formula work.

Skills covered:

The workshop will cover the following:

  • Formatting dates and times
  • Using arithmetical calculations and date and time functions to:
    • Work out timesheets
    • Apply date and time stamps
    • Track hours worked
    • Calculate differences between dates
    • Calculate working days with or without weekends and holidays
    • Calculate differences between dates
    • Use conditional formatting to highlight dates

Functions covered will include:

  • TODAY()
  • NOW()
  • DATE(year,month,day)
  • EDATE()
  • WEEKNUM()
  • WEEKDAY()
  • WORKDAY()
  • INTWORKDAY()
  • NETWORKDAYS()
  • DATEDIF()
  • TIME(hour,minute,second)

This workshop is interactive and attendees will gain hands-on experience.  Raw data to work with and useful summary notes will be provided. Limited spaces to ensure student-centred learning.

Read about the trainer, Bernard Pfister of Excel Training, and other workshops here


Requirements:

Attendees must bring their own laptops (not Tablets) with full Microsoft Excel, version 2010 or higher.  To check version, open a spreadsheet, click on File then Account.  
Please inform the training provider if you will be bringing a Mac laptop.


Register to attend below

For more information, contact Julia at
julia@taranakichamber.co.nz,
or call 06 759 9080

 

Date:
Wednesday, 11th August, 2021
Time:
9:30 a.m. to 11:30 a.m.
Location:
Taranaki Chamber of Commerce
Single Ticket (Member) incl GST:
$138.00
Single Ticket (Non-Member) incl GST:
$165.00

Step 1 of 4 - Event Details

Membership

Choose if you are booking as a member or non-member

First time here? If you’re a current Chamber member and this is your first time registering for an event on our new website, please click here and enter your email address to be sent your password.

Forgotten Password

Event


Total (incl GST)

Registration Policy:
Payment is required prior to course attendance, and your registration will be confirmed once payment has been made.

Cancellation Policy:
Any cancellation and/or changes must be made in writing to the Taranaki Chamber of Commerce no less than ten working days prior to the course in order to receive a full refund/credit. No refund or credit will be given for cancellations made after this or for non-attendance at the course.