Learn tricks and techniques for optimizing the use of dates and times in Excel 2016. Getting dates and times to show up the way you want in an Excel spreadsheet can be tricky. In this concise course, Excel expert Dennis Taylor shares easy solutions for formatting and calculating dates and times in Excel 2016. 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.