Course details

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!

Updated on 22 March, 2018
Courses you can instantly connect with... Do an online course on Soft Skills starting now. See all courses

Rate this page