Master Excel Dates and Times - Excel 2016

Master Microsoft Excel dates and times in an afternoon! Excel 2016, Excel 2013, and Excel 2010 dates and times.

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.