Lynda-Excel-2013-Working-ynRV
01. Introduction\\/01_01-Welcome.mp48.58MB
01. Introduction\\/01_02-Using the exercise files.mp41.42MB
02. The Excel Date and Time Systems\\/02_01-How Excel records and stores dates.mp413.23MB
02. The Excel Date and Time Systems\\/02_02-How Excel records and stores times.mp44.30MB
03. Creating Date and Time Entries\\/03_01-Standard date- and time-entry options and acceptable alternatives.mp49.98MB
03. Creating Date and Time Entries\\/03_02-Instant date and time entry.mp42.32MB
03. Creating Date and Time Entries\\/03_03-Using TODAY and NOW functions for dynamic date and time entry.mp44.99MB
03. Creating Date and Time Entries\\/03_04-Using AutoFill to enter a date or time series rapidly.mp418.00MB
04. Date and Time Fortting\\/04_01-Standard date and time formats.mp47.27MB
04. Date and Time Fortting\\/04_02-Custom date formatting.mp46.67MB
04. Date and Time Fortting\\/04_03-Keystroke shortcuts.mp45.18MB
04. Date and Time Fortting\\/04_04-Time formatting for hours over 24.mp46.57MB
05. Date and Time Functions\\/05_01-EOMONTH and EDATE End of months and futurepast dates.mp49.11MB
05. Date and Time Functions\\/05_02-DATEDIF Date differences by year month day and more.mp414.85MB
05. Date and Time Functions\\/05_03-WEEKDAY Day-of-week determination.mp42.63MB
05. Date and Time Functions\\/05_04-Calculating week numbers with WEEKNUM and ISOWEEKNUM.mp45.11MB
05. Date and Time Functions\\/05_05-NETWORKDAYS Calculate working days.mp45.23MB
05. Date and Time Functions\\/05_06-WORKDAY Calculate ending date.mp45.50MB
05. Date and Time Functions\\/05_07-DATEVALUE and TIMEVALUE Convert text entries into dates and times.mp44.54MB
06. Calculating with Dates and Times\\/06_01-Calculating date differences with formulas and the DAYS function.mp43.77MB
06. Calculating with Dates and Times\\/06_02-Calculating time differences within and between days.mp45.41MB
06. Calculating with Dates and Times\\/06_03-Calculating fiscal years and quarters.mp48.91MB
06. Calculating with Dates and Times\\/06_04-Calculating the first or last day of the last current or future month.mp47.10MB
06. Calculating with Dates and Times\\/06_05-Calculating holidays (Labor Day Thanksgiving Memorial Day etc.).mp47.27MB
06. Calculating with Dates and Times\\/06_06-Rounding time calculations to convenient intervals.mp49.35MB
06. Calculating with Dates and Times\\/06_07-Using times with currency calculations.mp45.46MB
07. Using Dates and Times with Excel Comnds\\/07_01-Using special date filters with date data Advanced data filter applications.mp413.17MB
07. Using Dates and Times with Excel Comnds\\/07_02-Using date and time controls and functions in data validation rules.mp49.75MB
07. Using Dates and Times with Excel Comnds\\/07_03-Converting unusually formatted dates into usable data Text to columns.mp45.25MB
08. Conclusion\\/08_01-Next steps.mp41.57MB
- CreateTime2020-01-03
- UpdateTime2020-01-03
- FileTotalCount30
- TotalSize424.96MBHotTimes6ViewTimes10DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.HAVD-480 2.RKI-204 3.MIBD-577 4.BID-032 5.DJSG-088 6.CRPD-351 7.JAME-004 8.MIBD-616 9.QEDO-001 10.RKI-210 11.WSP-100 12.ARJKT-10002 13.AND-110 14.PSD-412 15.MVBD-069 16.HITMA-158 17.ZSD-56 18.HYA-04 19.AAJ-026 20.DJSF-045 21.JUTA-013 22.HLV-002 23.IROS-025 24.DJNJ-89 25.BIB-022 26.CADV-221 27.ONSD-537 28.ONSD-461 29.ONSD-550 30.MILD-337 31.NMRD-09 32.JUC-231 33.BMW-021 34.BKSP-096 35.MIDD-798 36.NNN-08 37.OPBD-018 38.LADS-118 39.KTDVR-151 40.NFDM-118 41.HITMA-56 42.BOMN-032 43.TMSA-002 44.SMA-655 45.INF-006 46.INU-042 47.SHL-006 48.NATR-167 49.SMA-625 50.ECB-070 51.NLD-009 52.IFD-182 53.BNDV-00753 54.WANZ-099 55.TMGK-049 56.MIBD-472 57.WSES-019 58.HRDV-389 59.FMES-002 60.NCJD-030 61.JUMP-2149 62.IWFL-001 63.TEZ-172 64.SPZ-250 65.SDDE-113 66.AR-016 67.CHHT-007 68.HG-041 69.M-791 70.IMGS-036 71.480 72.204 73.577 74.032 75.088 76.351 77.004 78.616 79.001 80.210 81.100 82.10002 83.110 84.412 85.069 86.158 87.56 88.04 89.026 90.045 91.013 92.002 93.025 94.89 95.022 96.221 97.537 98.461 99.550 100.337 101.09 102.231 103.021 104.096 105.798 106.08 107.018 108.118 109.151 110.118 111.56 112.032 113.002 114.655 115.006 116.042 117.006 118.167 119.625 120.070 121.009 122.182 123.00753 124.099 125.049 126.472 127.019 128.389 129.002 130.030 131.2149 132.001 133.172 134.250 135.113 136.016 137.007 138.041 139.791 140.036