Management
Hands on Training icon
Hands On Training
Hands on Training icon

Excel Time and Date Function Playbook

Course Cover
compare button icon

Course Features

icon

Duration

53 minutes

icon

Delivery Method

Online

icon

Available on

Downloadable Courses

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Advanced

icon

Teaching Type

Self Paced

icon

Video Content

53 minutes

Course Description

Microsoft Excel workbooks rarely have more than a few cells that contain relevant dates and timestamps. It is essential to be able to handle them. This course Excel Time and Date Function playbook will teach you how. The course is broken down into five modules to help you organize all of these functions. The first module will teach you how to use the NOW AND TODAY functions in Excel to refer time and date. Next, we'll be comparing the date and time within a cell with the current time and date using the NOW function. Next, you will learn how to serialize dates, then use several functions like TIMEVALUE and DATEDIF to determine the difference between dates. You'll also learn how to use Excel's additional functions to help you parse dates or times.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

projects-img

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Finally, you'll explore how to parse dates and times in Excel with further useful functions

Learn how to reference time and date in excel using the NOW and TODAY functions

Next, you'll learn to serialize dates and times before moving on to use several functions such as TIMEVALUE, DATEDIF, and DAYS360, to find the difference between dates and times

Then, you’ll look at comparing date and time in a cell with the current date and time using the NOW and TODAY functions

Course Cover