Lynda - Excel 2007 Working with Dates and Times

วิดีโอติวเตอร์สอนการใช้งานโปรแกรม excel เรื่อง Working with Dates and Times







Lynda.com - Excel 2007 Working with Dates and Times
English | H264 960x540 | MP3 96 Kbps
Genre: eLearning

In Excel 2007: Working with Dates and Times, Dennis Taylor shares his solutions for optimizing the use of dates and times in Excel 2007. This course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering dates and times, and shows 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. Exercise files are included with the course.

Topics include:

* Understanding how Excel records and stores dates and times
* Looking at standard date/time entry options and acceptable alternatives
* Using the TODAY and NOW functions
* Customizing date formats
* Exploring keyboard shortcuts
* Formatting time for hours over 24
* Calculating differences across dates and times
* Rounding calculations
* Working with holidays
* Validating with dates
* Converting formatted dates to usable data



Introduction
Welcome           01:14
Using the exercise files           00:28
06:19 1. Excel's Date/Time System
Understanding how Excel records and stores dates           04:15
Understanding how Excel records and stores times           02:04
15:19 2. Creating Date/Time Entries
Looking at standard date/time entry options and acceptable alternatives           05:19
Using instant date/time entry           01:17
Using TODAY and NOW functions for dynamic date/time entry           03:02
Using Auto Fill to enter date and time series           05:41
08:03 3. Date/Time Formatting
Exploring keystroke shortcuts           02:12
Formatting time for hours over 24           03:04
Creating custom date formatting           02:47
18:51 4. Excel's Date/Time Functions
EOMONTH and EDATE: Setting ends of months and future/past dates           04:07
DATEDIF: Calculating date differences by year, month, day, and more           04:15
WEEKDAY: Determining the day of the week           02:13
NETWORKDAYS: Calculating working days           02:50
WORKDAY: Calculating an ending date           02:09
DATEVALUE and TIMEVALUE: Converting text entries into dates and times           03:17
21:34 5. Calculating with Dates and Times
Calculating date differences across days, months, and years           01:44
Calculating time differences within and across days           05:34
Calculating fiscal years and quarters           05:44
Rounding time calculations to convenient intervals           03:48
Using times with currency calculations           02:44
Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.)           02:00
15:30 6. Using Dates and Times with Excel Commands
Using special date filters with date data           03:15
Using date controls in data validation rules           05:30
Using date functions in data validation rules           03:39
Converting unusually formatted dates into usable data (text to columns)           03:06
00:29 Conclusion
Goodbye           00:29