63.gif

Search (advanced search)
Use this Search form before posting, asking or make a new thread.
Tips: Use Quotation mark to search words (eg. "How To Make Money Online")

04-11-2014, 08:07 AM
Post: #1
Lynda - Excel 2013: Working with DatesDates and Times
[Image: K76cUrFnVZGiBQTdjfw2xcm4fVoWwWbg.jpeg]
[align=center]Excel 2013: Working with DatesDates and Times
English | 1h 35m | Intermediate | Apr 08, 2014 | Exercise Files | 212 MB
eLearning[/center]

Most Excel users incorporate datesdates 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 datadata

Screenshots
[Image: th_4htYJ8lE72WJSQWc5seDFAHVv5R222i7.jpg]

[Image: di-K1B6_zpsd6404f85.gif]
If get link die or problem with unrar file , send request to >>>[[[Reported by Members as URL Shortener! Post the actual link!]]]<<</124uJzh
Use 7zip for unrar if you get "Max 260 character" error
Password for Unrar : tut4dl
Code:
[b][Uploaded][/b]
http://[Reported by Members as spam/premium links]/file/xoitmh0b/Excel_2013_Working_with_DatesDates_and_Times.part1.rar
http://[Reported by Members as spam/premium links]/file/6274zs8v/Excel_2013_Working_with_DatesDates_and_Times.part2.rar
[b][[Reported by Members as premium hosting that SUCK! Use MEDIAFIRE or MEGA.NZ :) !!!]][/b]
http://[Reported by Members as premium hosting that SUCK! Use MEDIAFIRE or MEGA.NZ :) !!!].net/file/a836f4f250b36bf2d38687f07565e4de/Excel_2013_Working_with_DatesDates_and_Times.part1.rar.html
http://[Reported by Members as premium hosting that SUCK! Use MEDIAFIRE or MEGA.NZ :) !!!].net/file/892b21e7df145a8ed0d56a6ed66c606c/Excel_2013_Working_with_DatesDates_and_Times.part2.rar.html




19.gif