Master Excel Dates and Times - Excel 2016
4.8 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
539 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Excel Dates and Times - Excel 2016 to your Wishlist.

Add to Wishlist

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.
4.8 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
539 students enrolled
Created by Tom Meservy
Last updated 7/2016
English
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Manipulate Excel dates and times like a master
  • Perform complex calculations with Excel dates and times
View Curriculum
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 is the target audience?
  • Intermediate users of Excel who want to be able to effectively use dates and times
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
01:12:40
+
Introduction and Overview
3 Lectures 06:00

A Welcome to the course.

Preview 00:15

Provides and overview of the samples file that is used in the course. You can download it here.

Files Overview
00:34

Determine what you know by trying out this practice problem.

Preview 05:11
+
General Overview of Dates and Times
4 Lectures 15:15

You will understand how dates and times are stored and formatted.

Preview 02:23

Differentiate between standard base dates for the excel date and time serial number.

1900 vs 1904
01:08

You will know how to enter dates in a variety of ways and how Excel interprets your input.

Entering Dates
04:05

You will know how to enter times in a variety of ways and how Excel interprets your input.

Entering Times
07:39
+
Excel Dates
9 Lectures 28:49

Identify some Excel date functions.

Preview 00:46

Determine the number of days, months, and years between two dates.

DateDif
02:32

Create a date that is always up to date.

Today
03:10

Create a date and time that are always up to date.

Now
00:48

Create dates and times that don't change when other formulas do.

Static Dates and Times
01:11

Learn how Excel can calculate holidays for any year entered.

Holidays
03:31

Determine the number of workdays between to dates or the date that is a certain number of workdays after another.

WorkDays and NetWorkDays
01:52

Understand default date formats when a calculation includes another date.

Date Calculations
00:44

An overview of several different date functions. 

Additional Date Functions
14:15
+
Excel Times
7 Lectures 16:03

Enter the current time in an Excel spreadsheet.

Preview 03:07

You will be able to format a time properly so that the time displays amounts greater than 24 hours.

Summing Time that Exceeds 24 Hours
01:42

Determine a few different ways that time differences can be calculated.

Calculating Time Differences
02:55

Convert minutes and seconds to hours and fractions of hours to proper time format.

Converting Time
01:37

Learn how to easily additional time to a date/time.

Adding Time
01:32

Properly round times with simple formulas.

Rounding Time
03:57

Convert time between different time zones.

Converting Between Time Zones
01:13
+
Practice Problems
2 Lectures 06:09

Retry the practice problem now that you know how to work with Excel dates and times.

Revisiting the Practice Problem
05:17

Test your date and time knowledge with these additional practice problems.

Additional Practice Problems
00:52

Complete the Additional Practice Problems spreadsheet before doing this quiz.

Additional Practice Problems Quiz
7 questions
+
Conclusion
1 Lecture 00:24
Conclusion
00:24
About the Instructor
Tom Meservy
4.5 Average rating
890 Reviews
5,474 Students
4 Courses
Professor and Consultant

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!