Master Excel Dates and Times - Excel 365 and Excel 2019

Name: Master Excel Dates and Times - Excel 365 and Excel 2019
Rating: 4.4 (23 reviews)

Master Microsoft Excel dates and times in an afternoon! Excel 365, Excel 2019, and Excel 2016 dates and times.

Created byTom Meservy

Last updated 10/2021

English

What you'll learn

Manipulate Excel dates and times like a master
Perform complex calculations with Excel dates and times

Course content

6 sections • 26 lectures • 1h 12m total length

Introduction0:15
A Welcome to the course.
Files Overview0:34
Provides and overview of the samples file that is used in the course. You can download it here.
Practice Problem5:11
Determine what you know by trying out this practice problem.

Serial Numbers2:23
You will understand how dates and times are stored and formatted.
1900 vs 19041:08
Differentiate between standard base dates for the excel date and time serial number.
Entering Dates4:05
You will know how to enter dates in a variety of ways and how Excel interprets your input.
Entering Times7:39
You will know how to enter times in a variety of ways and how Excel interprets your input.

Date Functions Overview0:46
Identify some Excel date functions.
DateDif2:32
Determine the number of days, months, and years between two dates.
Today3:10
Create a date that is always up to date.
Now0:48
Create a date and time that are always up to date.
Static Dates and Times1:11
Create dates and times that don't change when other formulas do.
Holidays3:31
Learn how Excel can calculate holidays for any year entered.
WorkDays and NetWorkDays1:52
Determine the number of workdays between to dates or the date that is a certain number of workdays after another.
Date Calculations0:44
Understand default date formats when a calculation includes another date.
Additional Date Functions14:15
An overview of several different date functions.

Displaying Current Time3:07
Enter the current time in an Excel spreadsheet.
Summing Time that Exceeds 24 Hours1:42
You will be able to format a time properly so that the time displays amounts greater than 24 hours.
Calculating Time Differences2:55
Determine a few different ways that time differences can be calculated.
Converting Time1:37
Convert minutes and seconds to hours and fractions of hours to proper time format.
Adding Time1:32
Learn how to easily additional time to a date/time.
Rounding Time3:57
Properly round times with simple formulas.
Converting Between Time Zones1:13
Convert time between different time zones.

Requirements

A recent copy of Excel. Course created with Excel 2016 but Excel 2013 or Excel 2010 will work as well.

Description

Have you done date and time calculations in Excel but keep running into weird problems? Do the dates and times in your Excel spreadsheets look off? Do you need to calculate date and time values in Excel but just aren't getting results?

Do you want to master Excel dates and times? This course is for you!

Master Excel Dates and Times in this Comprehensive Course

In just over an hour you will learn to effectively use Excel dates and times including:

Knowing how Excel dates and times are stored as serial numbers
How to format dates and times
Appropriately formatting dates and times
Effective use of date functions
Effective use of time functions
Calculating recurring dates like holidays
Calculating differences between dates including only counting workdays
Displaying current date and time in a variety of ways
Summing times that exceed 24 hours
and more!

Learn Excel Dates and Times by Doing

Throughout the course, you can follow along with the numerous concise examples that illustrate the nuances of Excel dates and times using the included worksheets. Further, practice problems are provided to allow you to apply these same concepts to another data set so that you can know that you have mastered the concepts.

We are professional instructors who have helped thousands of students Master Excel Dates and Times and become even more effective at work. We invite you to join us on a short journey to advance your career. Enroll today!

Who this course is for:

Intermediate users of Excel who want to be able to effectively use dates and times

Master Excel Dates and Times - Excel 365 and Excel 2019

What you'll learn

Explore related topics

Course content

Introduction and Overview3 lectures • 6min

General Overview of Dates and Times4 lectures • 15min

Excel Dates9 lectures • 29min

Excel Times7 lectures • 16min

Practice Problems2 lectures • 6min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: