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:
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!
Differentiate between standard base dates for the excel date and time serial number.
You will know how to enter dates in a variety of ways and how Excel interprets your input.
You will know how to enter times in a variety of ways and how Excel interprets your input.
Determine the number of days, months, and years between two dates.
Create a date that is always up to date.
Create a date and time that are always up to date.
Create dates and times that don't change when other formulas do.
Learn how Excel can calculate holidays for any year entered.
Determine the number of workdays between to dates or the date that is a certain number of workdays after another.
Understand default date formats when a calculation includes another date.
An overview of several different date functions.
You will be able to format a time properly so that the time displays amounts greater than 24 hours.
Determine a few different ways that time differences can be calculated.
Convert minutes and seconds to hours and fractions of hours to proper time format.
Learn how to easily additional time to a date/time.
Properly round times with simple formulas.
Convert time between different time zones.
Retry the practice problem now that you know how to work with Excel dates and times.
Test your date and time knowledge with these additional practice problems.
Complete the Additional Practice Problems spreadsheet before doing this quiz.
I'm a professor of Information Systems. I enjoy extracting business value out of technology. Over the years I have been a software developer, database administrator, systems administrator, systems analyst, and more. I've done training/consulting with Fortune 100 companies and the DOD. I’m the founder of Tech Mountain Consulting that provides world-class training, software development, and consulting. I love the outdoors. I've roasted marshmallows over a volcano!