Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 12 Minute(s)
Language
English
Taught by
Tom Meservy
Rating
Course Overview
Master Microsoft Excel dates and times in an afternoon! Excel 365, Excel 2019, and Excel 2016 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.
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!
Course Content
- 6 section(s)
- 26 lecture(s)
- Section 1 Introduction and Overview
- Section 2 General Overview of Dates and Times
- Section 3 Excel Dates
- Section 4 Excel Times
- Section 5 Practice Problems
- Section 6 Conclusion
What You’ll Learn
- Manipulate Excel dates and times like a master
- Perform complex calculations with Excel dates and times
Skills covered in this course
Reviews
-
JJoe Ferraro
So far so good.
-
RRobyn Jackson
I enrolled in this course for specifically adding year date only to a formula to obtain just the year in a cell and this was not addressed in this course.
-
MMichael o Lenenkokuai
I have always wanted to have take a course that is date and time specific to understand it better.
-
DDavid P
This course was a great way to quickly ramp up on Excel dates and times. The instructor explains things well. It's a short course, but I learned a lot. There are some good exercises that help reinforce the points learned. It will help me use the Excel dates and times better.
