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.SAMA-404 2.ANTA-06 3.QXL-88 4.NFDM-191 5.BUR-311 6.ASW-081 7.BID-010 8.MXSPS-095 9.ONSD-499 10.BDD-26 11.WPW-002 12.JUSD-442 13.SBNS-066 14.AVGP-004 15.KTDS-389 16.BID-026 17.MDYD-692 18.CXAZ-012 19.TDMJ-110 20.AAJB-004 21.IROS-018 22.IDBD-237 23.RKI-190 24.MIBD-603 25.ONSD-531 26.ONSD-655 27.ONSD-576 28.FABS-012 29.SOE-646 30.BF-218 31.IDBD-309 32.ONED-916 33.AMDP-004 34.DDT-213 35.SMD-37 36.TYWD-027 37.BMD-399 38.IDBD-280 39.INU-030 40.MXSPS-224 41.IESP-121 42.DTAA-002 43.HYAZ-042 44.VNDS-2523 45.ATID-233 46.VNDS-2845 47.MMT-007 48.JUC-794 49.JUSD-457 50.FPJS-004 51.SMD-08 52.AAD-011 53.ZEX-103 54.TIN-022 55.FSFV-008 56.MNSD-019 57.POO-012 58.HKN-002 59.PSG-002 60.VHQV-001 61.UD-477R 62.HIST-013 63.RAYG-007 64.KRFV-034 65.CCEK-007 66.PTBI-012 67.SIMG-187 68.SPZ-228 69.IA-004 70.GOBR-015 71.404 72.06 73.88 74.191 75.311 76.081 77.010 78.095 79.499 80.26 81.002 82.442 83.066 84.004 85.389 86.026 87.692 88.012 89.110 90.004 91.018 92.237 93.190 94.603 95.531 96.655 97.576 98.012 99.6 100.218 101.309 102.916 103.004 104.213 105.37 106.027 107.399 108.280 109.030 110.224 111.121 112.002 113.042 114.2523 115.233 116.2845 117.007 118.794 119.457 120.004 121.08 122.011 123.103 124.022 125.008 126.019 127.012 128.002 129.002 130.001 131.477R 132.013 133.007 134.034 135.007 136.012 137.187 138.228 139.004 140.015