Microsoft Excel: How Dates and Times work

Description

This is the first in a series that covers the nuts and bolts of different formulas, concepts and tools in Microsoft Excel. This series is designed for students and coaches seeking to learn access to compete in the UIL High School Computer Applications contest but has proven to be useful for anyone seeking to learn or brush up on their Excel skills. In this lesson, we focus on the dates and times in Microsoft Excel.

In this video, you'll learn:
- how dates and times work
- different common date and time number formats
- whole numbers versus decimals/fractions in dates and times when formatted as general numbers
- Common Formulas (TODAY, DAY, MONTH, YEAR, DATE, TIME, WEEKDAY, etc)
- Basic calculations involving dates and times

To illustrate these things, we'll go through some examples in Microsoft Excel. Note that starting point worksheets are attached as are the ending point worksheets (in the attached Excel workbook) in order to allow you to work off of the starting document and compare your results to the ending document.

This video is screencasted. To watch it in the resolution in which it was recorded (which will offer a crisper screen resolution than the player here), move your mouse over the player and click the 100% (Actual Size) button.

This video was recorded using Microsoft Excel 2010. There are very minor differences between Excel 2007 and 2010, but the content covered here is virtually the same across versions.

Supplementary Files

Once you purchase this lesson you will have access to the following files:

• Date_Time_Excel_Start_and_Finish_Sheets.xlsx

Embed this video on your site