Lynda - Excel 2013: Working with Dates and Times with Dennis Taylor

seeders: 24
leechers: 10
Added on January 24, 2015 by webcentarain Other > Tutorials
Torrent verified.



Lynda - Excel 2013: Working with Dates and Times with Dennis Taylor (Size: 212.48 MB)
 01_01-Welcome.mp48.58 MB
 01_02-Using the exercise files.mp41.42 MB
 02_01-How Excel records and stores dates.mp413.23 MB
 02_02-How Excel records and stores times.mp44.3 MB
 03_04-Using AutoFill to enter a date or time series rapidly.mp418 MB
 03_01-Standard date- and time-entry options and acceptable alternatives.mp49.98 MB
 03_03-Using TODAY and NOW functions for dynamic date and time entry.mp44.99 MB
 03_02-Instant date and time entry.mp42.32 MB
 04_01-Standard date and time formats.mp47.27 MB
 04_02-Custom date formatting.mp46.67 MB
 04_04-Time formatting for hours over 24.mp46.57 MB
 04_03-Keystroke shortcuts.mp45.18 MB
 05_02-DATEDIF Date differences by year, month, day, and more.mp414.85 MB
 05_01-EOMONTH and EDATE End of months and futurepast dates.mp49.11 MB
 05_06-WORKDAY Calculate ending date.mp45.5 MB
 05_05-NETWORKDAYS Calculate working days.mp45.23 MB
 05_04-Calculating week numbers with WEEKNUM and ISOWEEKNUM.mp45.11 MB
 05_07-DATEVALUE and TIMEVALUE Convert text entries into dates and times.mp44.54 MB
 05_03-WEEKDAY Day-of-week determination.mp42.63 MB
 06_06-Rounding time calculations to convenient intervals.mp49.35 MB
 06_03-Calculating fiscal years and quarters.mp48.91 MB
 06_05-Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mp47.27 MB
 06_04-Calculating the first or last day of the last, current, or future month.mp47.1 MB
 06_07-Using times with currency calculations.mp45.46 MB
 06_02-Calculating time differences within and between days.mp45.41 MB
 06_01-Calculating date differences with formulas and the DAYS function.mp43.77 MB
 07_01-Using special date filters with date data Advanced data filter applications.mp413.17 MB
 07_02-Using date and time controls and functions in data validation rules.mp49.75 MB
 07_03-Converting unusually formatted dates into usable data Text to columns.mp45.25 MB
 08_01-Next steps.mp41.57 MB

Description

Lynda - Excel 2013: Working with Dates and Times with Dennis Taylor

Subjects: Business Spreadsheets
Software: Excel Office Office 365

1h 35m Intermediate Apr 08, 2014 | Uploaded in Jan 24, 2015 Via Webcentara

image

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.
Topics include:
• Understanding how Excel records and stores dates and times
• Looking at standard date and time entry options and acceptable alternatives
• Using the TODAY and NOW functions
• Customizing date formats
• Using keyboard shortcuts
• Formatting time for hours over 24
• Calculating differences across dates and times
• Calculating the day of the week
• Working with holidays
• Validating dates
• Converting formatted dates to usable data


###################################################




Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
212.48 MB
seeders:24
leechers:10
Lynda - Excel 2013: Working with Dates and Times with Dennis Taylor