» » Lynda - Excel 2013: Working with Dates and Times

Information of news
  • Author: Alexandr
  • Date: 20-01-2015, 18:30
20-01-2015, 18:30

Lynda - Excel 2013: Working with Dates and Times

Category: Tutorials

Lynda - Excel 2013: Working with Dates and Times

Lynda - Excel 2013: Working with Dates and Times
English | 1h 35m | AVC (.mp4) 1280x720 15fps | AAC 48KHz 2ch | 212 Mb
Genre: eLearning

Most Excel users incorporate dates and times in their spreadsheets, but getting them to show up the way you want can be difficult.
Excel expert Dennis Taylor shares his solutions for formatting and calculating dates and times in Excel 2013. This one-hour course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering them, and teaches the options for date and time formatting. It also demonstrates the various date and time functions and shows how to calculate with dates and times in a range of scenarios.

Topics include:

Understanding how Excel records and stores dates and times
Looking at standard date and time entry options and acceptable alternatives
Using the TODAY and NOW functions
Customizing date formats
Using keyboard shortcuts
Formatting time for hours over 24
Calculating differences across dates and times
Calculating the day of the week
Working with holidays
Validating dates
Converting formatted dates to usable data
(Buy premium account for maximum speed and resumming ability)



Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter