Lynda – Excel 2016: Working with Dates and Times-0daytown

Lynda – Excel 2016: Working with Dates and Times
Size: 269 MB | Duration: 1h 57m | Video: AVC (.mp4) 1280×720 30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
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.

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