This is the second class in our Excel 2010 Expert Series. It picks up where Expert Level 1 left off. The focus of this course is working with date and time values in Excel. Topics covered include:

- Understanding how Excel stores dates/times
- Date/time arithmetic (adding, subtracting)
- Custom date/time codes and formats
- Most popular date/time functions
- Determining the components of a date/time
- Constructing a date/time from it's components
- Calculating an age or anniversary date
- Determining the work days between two dates
- Creating a time sheet to track hours

Subscribe to Excel 2010 Expert 2
Get notifications when this page is updated