Lynda-com-Excel-2010-Adv-jns3
- 00 Introduction\\0001 Welcome.mov11.44MB
- 00 Introduction\\0002 Using the exercise files.mov837.85KB
- 01 Formula and Function Tips and Shortcuts\\0106 Displaying and highlighting formulas.mov21.76MB
- 01 Formula and Function Tips and Shortcuts\\0101 Using the entire row column references.mov14.73MB
- 01 Formula and Function Tips and Shortcuts\\0108 Enhancing readability with range names.mov12.74MB
- 01 Formula and Function Tips and Shortcuts\\0104 Creating 3D formulas to gather data from multiple sheets.mov10.05MB
- 01 Formula and Function Tips and Shortcuts\\0102 Copying column formulas instantly.mov9.92MB
- 01 Formula and Function Tips and Shortcuts\\0107 Simplifying debugging formulas.mov8.43MB
- 01 Formula and Function Tips and Shortcuts\\0103 Converting formulas to values with a simple drag.mov5.98MB
- 01 Formula and Function Tips and Shortcuts\\0105 Updating values without formulas.mov5.49MB
- 02 Formula and Function Tools\\0201 Reviewing function basics.mov29.06MB
- 02 Formula and Function Tools\\0204 Using mixed references.mov10.80MB
- 02 Formula and Function Tools\\0202 Using and extending AutoSum.mov10.33MB
- 02 Formula and Function Tools\\0203 Using absolute and relative references.mov8.99MB
- 03 IF and Related Functions\\0303 Using the AND OR and NOT functions with IF to create compound logical tests.mov12.97MB
- 03 IF and Related Functions\\0301 Exploring IF logical tests and using relational operators.mov7.97MB
- 03 IF and Related Functions\\0302 Creating and expanding the use of nested IF statements.mov7.29MB
- 04 Lookup and Reference Function\\0408 Using TCH and INDEX together.mov13.84MB
- 04 Lookup and Reference Function\\0402 Finding approxite matches with VLOOKUP.mov13.74MB
- 04 Lookup and Reference Function\\0404 Nesting LOOKUP functions.mov12.92MB
- 04 Lookup and Reference Function\\0406 Locating data with TCH.mov10.45MB
- 04 Lookup and Reference Function\\0401 Looking up infortion with VLOOKUP and HLOOKUP.mov10.21MB
- 04 Lookup and Reference Function\\0407 Retrieving infortion by location with INDEX.mov9.63MB
- 04 Lookup and Reference Function\\0403 Finding exact tches with VLOOKUP.mov7.83MB
- 04 Lookup and Reference Function\\0405 Finding table-like infortion within a function with CHOOSE.mov6.29MB
- 05 Power Functions\\0502 Tabulating infortion on multiple criteria with COUNTIFS SUMIFS and ERAGEIFS.mov15.00MB
- 05 Power Functions\\0501 Tabulating infortion on a single criterion with COUNTIF SUMIF and ERAGEIF.mov8.84MB
- 06 Statistical Functions\\0602 Ranking data without sorting with RANK.mov10.72MB
- 06 Statistical Functions\\0604 Tabulating blank cells with COUNTBLANK.mov8.60MB
- 06 Statistical Functions\\0601 Finding the middle value with MEDIAN.mov3.36MB
- 06 Statistical Functions\\0603 Finding the gnitude data with LARGE and ALL.mov3.24MB
- 07 Data Functions\\0701 Understanding Excel date time capabilities in formulas.mov13.05MB
- 07 Data Functions\\0702 Identifying the day of the week with WEEKDAY.mov12.02MB
- 07 Data Functions\\0705 Tabulating date time differences with DATEDIF.mov8.53MB
- 07 Data Functions\\0703 Counting working days with NETWORKDAYS.mov5.26MB
- 07 Data Functions\\0704 Determining a completion date with WORKDAY.mov4.27MB
- 08 th Functions\\0801 Working with rounding functions.mov15.45MB
- 08 th Functions\\0803 Building random number generators with RAND and RANDBETWEEN.mov11.36MB
- 08 th Functions\\0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov10.80MB
- 08 th Functions\\0802 Finding the remainder with MOD and using MOD with conditional formatting.mov10.39MB
- 08 th Functions\\0804 Converting a value between measurement systems with CONVERT.mov7.87MB
- 09 Array Formulas and Functions\\0901 Extending formula capabilities with arrays.mov17.68MB
- 09 Array Formulas and Functions\\0902 Counting unique entries in a range with an array formula.mov11.49MB
- 09 Array Formulas and Functions\\0906 Combining multiple functions in arrays.mov9.03MB
- 09 Array Formulas and Functions\\0904 Flipping row column orientation with TRANSPOSE.mov8.95MB
- 09 Array Formulas and Functions\\0905 Building analysis via regression techniques with TREND and GROWTH.mov8.54MB
- 09 Array Formulas and Functions\\0903 Determining frequency distributions with FREQUENCY.mov6.05MB
- 10 Text Functions\\1006 Adjusting character content with REPLACE and SUBSTITUTE.mov11.31MB
- 10 Text Functions\\1001 Locating and extracting data with FIND and MID.mov10.99MB
- 10 Text Functions\\1003 Removing excess spaces with TRIM.mov10.36MB
- 10 Text Functions\\1007 Reviewing additional text functions.mov10.34MB
- 10 Text Functions\\1005 Adjusting case within cells with PROPER UPPER and LOWER.mov9.43MB
- 10 Text Functions\\1004 Using CONCATENATE with functions.mov7.29MB
- 10 Text Functions\\1002 Extracting specific data with LEFT and RIGHT.mov5.82MB
- 11 Financial Functions\\1101 Calculating payments with PMT.mov7.86MB
- 11 Financial Functions\\1103 Determining total amount of future payments with PV.mov7.65MB
- 11 Financial Functions\\1102 Finding future values with FV.mov6.28MB
- 12 Infortion Functions\\1202 Using error-checking functions ISERR ISERROR IFERROR.mov12.78MB
- 12 Infortion Functions\\1201 Working with the IS information functions.mov8.16MB
- 13 Reference Functions\\1302 Returning references with INDIRECT.mov20.26MB
- 13 Reference Functions\\1301 Getting data from remote cells with OFFSET.mov7.66MB
- 14 Conclusion\\1401 Final thoughts.mov2.37MB
- Exercise Files\\Ex_Files_Excel_10_Ad_Form.zip820.28KB
- CreateTime2018-11-12
- UpdateTime2018-11-12
- FileTotalCount64
- TotalSize1.22GBHotTimes6ViewTimes10DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.IDBD-391 2.CADV-205 3.KTDS-365 4.MIBD-564 5.JS-37 6.DVDES-433 7.MBYD-118 8.MAMA-107 9.WSS-170 10.ZONO-068 11.ERDV-216 12.MIBD-463 13.CRAD-006 14.FRDVS-021 15.AISM-33 16.ISD-118 17.SFNA-004 18.TYWD-016 19.DSML-008 20.AAJB-130 21.KWBD-064 22.IDBD-282 23.PBD-105 24.MIBD-644 25.MGDV-034 26.ONSD-587 27.RKI-144 28.JFB-047 29.SUPD-095 30.IDBD-381 31.KIBD-044 32.XV-886 33.EVIS-026 34.ONSD-605 35.OBSE-001 36.JUKD-852 37.DJNJ-34 38.MDYD-281 39.MDOS-002 40.MVBD-017 41.EMAC-005 42.ARM-054 43.GUR-014 44.SACE-077 45.QHR-002 46.SDMT-950 47.BJOS-021 48.DVC-28 49.BVD-037 50.WAP-001 51.KMI-073 52.SGT-017 53.MDS-691 54.ALX-411 55.MBD-144 56.SRD-14 57.BT-039 58.VSPDS-622 59.USA-037 60.ONSD-142 61.KIJO-004 62.NHDTA-105 63.PKC-016 64.MAD-090 65.AVGP-018 66.SHPDV-034 67.MAMA-047 68.CO-4716 69.HA-007 70.CAV-3900038 71.391 72.205 73.365 74.5 75.37 76.433 77.118 78.107 79.170 80.068 81.216 82.463 83.006 84.021 85.33 86.118 87.004 88.016 89.008 90.130 91.0 92.282 93.105 94.4 95.034 96.587 97.144 98.047 99.095 100.381 101.044 102.886 103.026 104.605 105.001 106.852 107.34 108.281 109.002 110.017 111.005 112.054 113.014 114.077 115.002 116.950 117.021 118.28 119.037 120.001 121.073 122.017 123.691 124.411 125.144 126.14 127.039 128.622 129.037 130.142 131.004 132.105 133.016 134.090 135.018 136.034 137.047 138.4716 139.007 140.3900038