[Lynda.com] Excel 2013: Working with Dates and Times [2014, ENG]

Содержание

Introduction
Welcome
Using the exercise files
1. The Excel Date and Time Systems
How Excel records and stores dates
How Excel records and stores times
2. Creating Date and Time Entries
Standard date- and time-entry options and acceptable alternatives
Instant date and time entry
Using TODAY and NOW functions for dynamic date and time entry
Using AutoFill to enter a date or time series rapidly
3. Date and Time Formatting
Standard date and time formats
Custom date formatting
Keystroke shortcuts
Time formatting for hours over 24
4. Date and Time Functions
EOMONTH and EDATE: End of months and future/past dates
DATEDIF: Date differences by year, month, day, and more
WEEKDAY: Day-of-week determination
Calculating week numbers with WEEKNUM and ISOWEEKNUM
NETWORKDAYS: Calculate working days
WORKDAY: Calculate ending date
DATEVALUE and TIMEVALUE: Convert text entries into dates and times
5. Calculating with Dates and Times
Calculating date differences with formulas and the DAYS function
Calculating time differences within and between days
Calculating fiscal years and quarters
Calculating the first or last day of the last, current, or future month
Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.)
Rounding time calculations to convenient intervals
Using times with currency calculations
6. Using Dates and Times with Excel Commands
Using special date filters with date data: Advanced data filter applications
Using date and time controls and functions in data validation rules
Converting unusually formatted dates into usable data: Text to columns
Conclusion
Next steps

Скриншоты