2014
Lynda
Dennis Taylor
1:35
English
Most Excel users incorporate dates and times in their spreadsheets, but getting them to show up the way you want can be difficult. Excel expert Dennis Taylor shares his solutions for formatting and calculating dates and times in Excel 2013. This one-hour course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering them, and teaches the 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.
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
Download File Size:201.97 MB
|
