All courses
Resource hub
Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Excel 2016 Time and Date Function Playbook

In this course, Excel 2016 Time and Date Function Playbook, you'll learn to deal with various scenarios and actions that occur when operating on worksheets containing dates and timestamps.

Pratheerth Padman - Pluralsight course - Excel 2016 Time and Date Function Playbook
by Pratheerth Padman
Get started Video play icon Preview course

What you'll learn

Microsoft Excel workbooks are seldom found without several cells filled with relevant dates or timestamps. As such, it is important to know how to deal with them, and in this course, Excel 2016 Time and Date Function Playbook, that's exactly what you'll be doing. To effectively compartmentalize all these functions, the course is divided into 5 modules. In the first module, you’ll learn how to reference time and date in excel using the NOW and TODAY functions. Then, you’ll look at comparing date and time in a cell with the current date and time 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. Finally, you'll explore how to parse dates and times in Excel with further useful functions.

Table of contents

About the author

Pratheerth Padman - Pluralsight course - Excel 2016 Time and Date Function Playbook
Pratheerth Padman

Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.

More Courses by Pratheerth