Lynda.com - Excel 2010. Working with Dates and Times/00 Introduction/0001 Welcome.mov |
9.2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/00 Introduction/0002 Using the exercise files.mov |
362 KB |
Lynda.com - Excel 2010. Working with Dates and Times/01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov |
5 MB |
Lynda.com - Excel 2010. Working with Dates and Times/01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov |
1.7 MB |
Lynda.com - Excel 2010. Working with Dates and Times/02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov |
6.5 MB |
Lynda.com - Excel 2010. Working with Dates and Times/02 Creating Date Time Entries/0203 Using TODAY and NOW functions for dynamic date time entry.mov |
3.2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/02 Creating Date Time Entries/0201 Looking at standard date time entry options and acceptable alternatives.mov |
3.2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/02 Creating Date Time Entries/0202 Using instant date time entry.mov |
1.6 MB |
Lynda.com - Excel 2010. Working with Dates and Times/03 Date Time Formatting/0303 Creating custom date formatting.mov |
2.9 MB |
Lynda.com - Excel 2010. Working with Dates and Times/03 Date Time Formatting/0302 Formatting time for hours over 24.mov |
2.4 MB |
Lynda.com - Excel 2010. Working with Dates and Times/03 Date Time Formatting/0301 Exploring keystroke shortcuts.mov |
2.3 MB |
Lynda.com - Excel 2010. Working with Dates and Times/04 Excel's Date Time Functions/0401 EOMONTH and EDATE Setting ends of months and future past dates.mov |
4.8 MB |
Lynda.com - Excel 2010. Working with Dates and Times/04 Excel's Date Time Functions/0402 DATEDIF Calculating date differences by year, month, day, and more.mov |
4.8 MB |
Lynda.com - Excel 2010. Working with Dates and Times/04 Excel's Date Time Functions/0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov |
3.4 MB |
Lynda.com - Excel 2010. Working with Dates and Times/04 Excel's Date Time Functions/0404 NETWORKDAYS Calculating working days.mov |
2.5 MB |
Lynda.com - Excel 2010. Working with Dates and Times/04 Excel's Date Time Functions/0405 WORKDAY Calculating an ending date.mov |
2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/04 Excel's Date Time Functions/0403 WEEKDAY Determining the day of the week.mov |
2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/05 Calculating with Dates and Times/0503 Calculating fiscal years and quarters.mov |
6.3 MB |
Lynda.com - Excel 2010. Working with Dates and Times/05 Calculating with Dates and Times/0502 Calculating time differences within and across days.mov |
5.9 MB |
Lynda.com - Excel 2010. Working with Dates and Times/05 Calculating with Dates and Times/0504 Rounding time calculations to convenient intervals.mov |
5.4 MB |
Lynda.com - Excel 2010. Working with Dates and Times/05 Calculating with Dates and Times/0505 Using times with currency calculations.mov |
2.9 MB |
Lynda.com - Excel 2010. Working with Dates and Times/05 Calculating with Dates and Times/0501 Calculating date differences across days, months, and years.mov |
2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/05 Calculating with Dates and Times/0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov |
2 MB |
Lynda.com - Excel 2010. Working with Dates and Times/06 Using Dates and Times with Excel Commands/0602 Using date controls in data validation rules.mov |
6.3 MB |
Lynda.com - Excel 2010. Working with Dates and Times/06 Using Dates and Times with Excel Commands/0601 Using special date filters with date data.mov |
4.5 MB |
Lynda.com - Excel 2010. Working with Dates and Times/06 Using Dates and Times with Excel Commands/0604 Converting unusually formatted dates into usable data (text to columns).mov |
4.3 MB |
Lynda.com - Excel 2010. Working with Dates and Times/06 Using Dates and Times with Excel Commands/0603 Using date functions in data validation rules.mov |
3.5 MB |
Lynda.com - Excel 2010. Working with Dates and Times/07 Conclusion/0701 Goodbye.mov |
269 KB |
Lynda.com - Excel 2010. Working with Dates and Times/Exercise Files/Ex_Files_Excel2010_Dates.zip |
3.1 MB |