Download Lynda - Excel 2013: Working with Dates and Times Torrent

Lynda - Excel 2013: Working with Dates and Times

01. Introduction

	01_01-Welcome.mp4	MP4	8.58 MB
	01_02-Using the exercise files.mp4	MP4	1.42 MB

02. The Excel Date and Time Systems

	02_01-How Excel records and stores dates.mp4	MP4	13.23 MB
	02_02-How Excel records and stores times.mp4	MP4	4.3 MB

03. Creating Date and Time Entries

03_01-Standard date- and time-entry options and acceptable alternatives.mp4	MP4	9.98 MB
03_02-Instant date and time entry.mp4	MP4	2.32 MB
03_03-Using TODAY and NOW functions for dynamic date and time entry.mp4	MP4	4.99 MB
03_04-Using AutoFill to enter a date or time series rapidly.mp4	MP4	18 MB

04. Date and Time Formatting

04_01-Standard date and time formats.mp4	MP4	7.27 MB
04_02-Custom date formatting.mp4	MP4	6.67 MB
04_03-Keystroke shortcuts.mp4	MP4	5.18 MB
04_04-Time formatting for hours over 24.mp4	MP4	6.57 MB

05. Date and Time Functions

05_01-EOMONTH and EDATE End of months and futurepast dates.mp4	MP4	9.11 MB
05_02-DATEDIF Date differences by year, month, day, and more.mp4	MP4	14.85 MB
05_03-WEEKDAY Day-of-week determination.mp4	MP4	2.63 MB
05_04-Calculating week numbers with WEEKNUM and ISOWEEKNUM.mp4	MP4	5.11 MB
05_05-NETWORKDAYS Calculate working days.mp4	MP4	5.23 MB
05_06-WORKDAY Calculate ending date.mp4	MP4	5.5 MB
05_07-DATEVALUE and TIMEVALUE Convert text entries into dates and times.mp4	MP4	4.54 MB

06. Calculating with Dates and Times

06_01-Calculating date differences with formulas and the DAYS function.mp4	MP4	3.77 MB
06_02-Calculating time differences within and between days.mp4	MP4	5.41 MB
06_03-Calculating fiscal years and quarters.mp4	MP4	8.91 MB
06_04-Calculating the first or last day of the last, current, or future month.mp4	MP4	7.1 MB
06_05-Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mp4	MP4	7.27 MB
06_06-Rounding time calculations to convenient intervals.mp4	MP4	9.35 MB
06_07-Using times with currency calculations.mp4	MP4	5.46 MB

07. Using Dates and Times with Excel Commands

07_01-Using special date filters with date data Advanced data filter applications.mp4	MP4	13.17 MB
07_02-Using date and time controls and functions in data validation rules.mp4	MP4	9.75 MB
07_03-Converting unusually formatted dates into usable data Text to columns.mp4	MP4	5.25 MB

08. Conclusion

08_01-Next steps.mp4

MP4

1.57 MB

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Lynda - Excel Tips (Updated Apr 07, 2015) Posted by mdusanjay in Books - Ebooks Posted in Books - Ebooks 0 197.51 MB 11 years ago mdusanjay	Size 197.51 MB	Files 13	Age 11 years ago	Seeds 0	Leechs 0	Source
Microsoft Excel 2010 Advanced Formulas and Functions - Lynda.com Posted by HartFm in Books - Ebooks Posted in Books - Ebooks 1 523.2 MB 14 years ago HartFm	Size 523.2 MB	Files 4	Age 14 years ago	Seeds 1	Leechs 0	Source
Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR Posted by RARBG in Books - Ebooks Posted in Books - Ebooks 0 184.5 MB 15 years ago RARBG	Size 184.5 MB	Files 1	Age 15 years ago	Seeds 0	Leechs 0	Source
Lynda.com.Excel.2010.Charts.in.Depth-QUASAR Posted by RARBG in Books - Ebooks Posted in Books - Ebooks 0 508 MB 15 years ago RARBG	Size 508 MB	Files 1	Age 15 years ago	Seeds 0	Leechs 0	Source

Lynda - Excel 2013: Working with Dates and Times

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce