Magnetz

Title: Lynda Com - ExcelGroup: NOGRPYear: 2010Source: Lynda.Com

Info Hash

7B3F82C1AE6B304EF469040A6DABBEACC5491A02

Source

Unverified

Total Size

104.11 MB

Total Files

29

Seeders

0

Leechers

2

Health

Score

2

Type

Bookware

File List

File	Size
00 Introduction/0001 Welcome.mov	9.22 MB
00 Introduction/0002 Using the exercise files.mov	362.17 KB
01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov	4.98 MB
01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov	1.68 MB
02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov	6.45 MB
02 Creating Date Time Entries/0203 Using TODAY and NOW functions for dynamic date time entry.mov	3.16 MB
02 Creating Date Time Entries/0201 Looking at standard date time entry options and acceptable alternatives.mov	3.16 MB
02 Creating Date Time Entries/0202 Using instant date time entry.mov	1.56 MB
03 Date Time Formatting/0303 Creating custom date formatting.mov	2.88 MB
03 Date Time Formatting/0302 Formatting time for hours over 24.mov	2.44 MB
03 Date Time Formatting/0301 Exploring keystroke shortcuts.mov	2.32 MB
04 Excel's Date Time Functions/0401 EOMONTH and EDATE Setting ends of months and future past dates.mov	4.83 MB
04 Excel's Date Time Functions/0402 DATEDIF Calculating date differences by year, month, day, and more.mov	4.79 MB
04 Excel's Date Time Functions/0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov	3.38 MB
04 Excel's Date Time Functions/0404 NETWORKDAYS Calculating working days.mov	2.54 MB
04 Excel's Date Time Functions/0405 WORKDAY Calculating an ending date.mov	1.99 MB
04 Excel's Date Time Functions/0403 WEEKDAY Determining the day of the week.mov	1.96 MB
05 Calculating with Dates and Times/0503 Calculating fiscal years and quarters.mov	6.26 MB
05 Calculating with Dates and Times/0502 Calculating time differences within and across days.mov	5.85 MB
05 Calculating with Dates and Times/0504 Rounding time calculations to convenient intervals.mov	5.44 MB
05 Calculating with Dates and Times/0505 Using times with currency calculations.mov	2.9 MB
05 Calculating with Dates and Times/0501 Calculating date differences across days, months, and years.mov	2.05 MB
05 Calculating with Dates and Times/0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov	1.96 MB
06 Using Dates and Times with Excel Commands/0602 Using date controls in data validation rules.mov	6.29 MB
06 Using Dates and Times with Excel Commands/0601 Using special date filters with date data.mov	4.5 MB
06 Using Dates and Times with Excel Commands/0604 Converting unusually formatted dates into usable data (text to columns).mov	4.3 MB
06 Using Dates and Times with Excel Commands/0603 Using date functions in data validation rules.mov	3.47 MB
07 Conclusion/0701 Goodbye.mov	269.41 KB
Exercise Files/Ex_Files_Excel2010_Dates.zip	3.14 MB

Trackers

No trackers found.