Dennis explains what's going on behind the scenes when Excel stores dates and times, and offers tips for entering and formatting data. Next, he demonstrates how to work with dates and times in common Excel functions, and how to calculate data with dates and times. Finally, Dennis explains how to use dates and times with Excel commands, including working with data filters.

Topics include:
* How Excel records and stores dates
* Using standard date/time entries and acceptable alternatives
* Formatting dates and times
* Creating standard date/time formats
* Working with dates and times in functions
* Calculating with dates and times
* Using dates/times with Excel commands