Lynda.com - Excel 2007. Working with Dates and Times
File List
- 00 Introduction/0001 Welcome.mov 8.5 MB
- 05 Calculating with Dates and Times/0503 Calculating fiscal years and quarters.mov 6.4 MB
- 02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov 6.3 MB
- 05 Calculating with Dates and Times/0502 Calculating time differences within and across days.mov 6.2 MB
- 06 Using Dates and Times with Excel Commands/0602 Using date controls in data validation rules.mov 6.1 MB
- 01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov 5.6 MB
- 02 Creating Date Time Entries/0201 Looking at standard date time entry options and acceptable alternatives.mov 5.5 MB
- 06 Using Dates and Times with Excel Commands/0601 Using special date filters with date data.mov 5.3 MB
- 04 Excel's Date Time Functions/0402 DATEDIF Calculating date differences by year, month, day, and more.mov 5.0 MB
- 04 Excel's Date Time Functions/0401 EOMONTH and EDATE Setting ends of months and future past dates.mov 4.6 MB
- 05 Calculating with Dates and Times/0504 Rounding time calculations to convenient intervals.mov 4.4 MB
- 06 Using Dates and Times with Excel Commands/0603 Using date functions in data validation rules.mov 4.0 MB
- 06 Using Dates and Times with Excel Commands/0604 Converting unusually formatted dates into usable data (text to columns).mov 3.9 MB
- 04 Excel's Date Time Functions/0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov 3.6 MB
- 03 Date Time Formatting/0303 Creating custom date formatting.mov 3.4 MB
- 03 Date Time Formatting/0302 Formatting time for hours over 24.mov 3.3 MB
- 02 Creating Date Time Entries/0203 Using TODAY and NOW functions for dynamic date time entry.mov 3.2 MB
- Exercise Files/Ex_Files_Excel07_Dates.zip 3.1 MB
- 04 Excel's Date Time Functions/0404 NETWORKDAYS Calculating working days.mov 2.9 MB
- 05 Calculating with Dates and Times/0505 Using times with currency calculations.mov 2.9 MB
- 03 Date Time Formatting/0301 Exploring keystroke shortcuts.mov 2.8 MB
- 05 Calculating with Dates and Times/0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov 2.4 MB
- 04 Excel's Date Time Functions/0403 WEEKDAY Determining the day of the week.mov 2.3 MB
- 04 Excel's Date Time Functions/0405 WORKDAY Calculating an ending date.mov 2.2 MB
- 01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov 2.2 MB
- 05 Calculating with Dates and Times/0501 Calculating date differences across days, months, and years.mov 2.0 MB
- 02 Creating Date Time Entries/0202 Using instant date time entry.mov 1.2 MB
- 00 Introduction/0002 Using the exercise files.mov 562.1 KB
- 07 Conclusion/0701 Goodbye.mov 404.2 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.