Tel: +1 (604) 900-1980

Working with Data Tables

"This course is part of a comprehensive program. Please contact us for more information."

Contact Us

Course Description

Excel enables you to enter dates and times on your worksheet, format them, and use them in calculations like other values. However, there are some rules and limitations you must be aware of so that any calculation using dates and times is accurate.

Course Details

Learning Objectives

By the end of this course, you will be able to

  • List uses for dates and times in a worksheet
  • Explain the serial numbers Excel uses to create dates and times
  • Enter dates and times in valid formats
  • Explain how to use the Today and Now functions
  • Use keyboard shortcuts to enter the current date and current time
  • Format dates and times using predefined formats and custom formats
  • Use dates and times in formulas

Preparing you for success

The Northwest Skills Institute is an industry focused training organization.

Our programs are geared specifically for industry, making students more qualified and READY FOR WORK.

Runner to target

It's time to upskill your employees and solve your workforce problems.

Contact our program coordinator

Trusted by companies looking to develop highly skilled workers

Manufacturing BC
Discover Tours
Print Forward
Mission Community
Arcteryx
BC Food & Beverage
BSIA
Go Industrial
Great Little Box Company
BC Apparel & Gear
Mustang Survival
Red Wood Rubber

Northwest Skills Institute
Proud Member of

NW Skills acknowledges and respects the traditional territories of the First Nations, Métis, and Inuit peoples upon which we and our partners carry out our work across Canada. We thank the hereditary First Peoples who continue to live on and care for these lands.