Excel 2016 Time and Date Function Playbook

Focused View

Pratheerth Padman

53:12

50 View

01 - Course Overview

01 - Course Overview.mp4

01:57

02 - Referencing Current Date and Time

02 - Course and Module Introduction.mp4

01:40

03 - NOW Function.mp4

01:59

04 - TODAY Function.mp4

00:55

05 - Demo - Implementing the NOW and TODAY Functions.mp4

02:39

03 - Serializing Dates and Times in Excel

06 - Module Introduction.mp4

00:37

07 - Date and Time Storage in Excel.mp4

04:18

08 - DATE and TIME Functions.mp4

03:52

04 - Calculating Differences Between Dates and Times

09 - Module Introduction.mp4

01:12

10 - Comparing Given Date with Current Date.mp4

03:35

11 - Calculating Differences in Timestamps.mp4

05:41

12 - Calculating Differences in Dates - DATEVALUE.mp4

03:51

13 - Calculating Differences in Dates - DAYS, DATEDIF and DAYS360.mp4

05:30

05 - Finding the Day, Month, Weekday, or Year of a Date

14 - Module Introduction.mp4

00:50

15 - DAY and WEEKDAY Functions.mp4

05:21

16 - MONTH and YEAR Functions.mp4

01:52

06 - Finding the Hour, Minute, or Second of a Time

17 - Module Introduction.mp4

00:40

18 - HOUR Function.mp4

01:30

19 - MINUTE and SECOND Functions.mp4

01:11

20 - Demo - Implementing the HOUR, MINUTE, and SECOND Function in Excel.mp4

02:04

21 - Course Summary and Feedback.mp4

01:58

Description

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.

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Pratheerth Padman

Instructor's Courses

Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.