fileLynda-com-Excel-2010-Adv-jns3

Lynda Excel 2010 Advanced Foulas and Functions
  • MOV00 Introduction\\0001 Welcome.mov11.44MB
  • MOV00 Introduction\\0002 Using the exercise files.mov837.85KB
  • MOV01 Formula and Function Tips and Shortcuts\\0106 Displaying and highlighting formulas.mov21.76MB
  • MOV01 Formula and Function Tips and Shortcuts\\0101 Using the entire row column references.mov14.73MB
  • MOV01 Formula and Function Tips and Shortcuts\\0108 Enhancing readability with range names.mov12.74MB
  • MOV01 Formula and Function Tips and Shortcuts\\0104 Creating 3D formulas to gather data from multiple sheets.mov10.05MB
  • MOV01 Formula and Function Tips and Shortcuts\\0102 Copying column formulas instantly.mov9.92MB
  • MOV01 Formula and Function Tips and Shortcuts\\0107 Simplifying debugging formulas.mov8.43MB
  • MOV01 Formula and Function Tips and Shortcuts\\0103 Converting formulas to values with a simple drag.mov5.98MB
  • MOV01 Formula and Function Tips and Shortcuts\\0105 Updating values without formulas.mov5.49MB
  • MOV02 Formula and Function Tools\\0201 Reviewing function basics.mov29.06MB
  • MOV02 Formula and Function Tools\\0204 Using mixed references.mov10.80MB
  • MOV02 Formula and Function Tools\\0202 Using and extending AutoSum.mov10.33MB
  • MOV02 Formula and Function Tools\\0203 Using absolute and relative references.mov8.99MB
  • MOV03 IF and Related Functions\\0303 Using the AND OR and NOT functions with IF to create compound logical tests.mov12.97MB
  • MOV03 IF and Related Functions\\0301 Exploring IF logical tests and using relational operators.mov7.97MB
  • MOV03 IF and Related Functions\\0302 Creating and expanding the use of nested IF statements.mov7.29MB
  • MOV04 Lookup and Reference Function\\0408 Using TCH and INDEX together.mov13.84MB
  • MOV04 Lookup and Reference Function\\0402 Finding approxite matches with VLOOKUP.mov13.74MB
  • MOV04 Lookup and Reference Function\\0404 Nesting LOOKUP functions.mov12.92MB
  • MOV04 Lookup and Reference Function\\0406 Locating data with TCH.mov10.45MB
  • MOV04 Lookup and Reference Function\\0401 Looking up infortion with VLOOKUP and HLOOKUP.mov10.21MB
  • MOV04 Lookup and Reference Function\\0407 Retrieving infortion by location with INDEX.mov9.63MB
  • MOV04 Lookup and Reference Function\\0403 Finding exact tches with VLOOKUP.mov7.83MB
  • MOV04 Lookup and Reference Function\\0405 Finding table-like infortion within a function with CHOOSE.mov6.29MB
  • MOV05 Power Functions\\0502 Tabulating infortion on multiple criteria with COUNTIFS SUMIFS and ERAGEIFS.mov15.00MB
  • MOV05 Power Functions\\0501 Tabulating infortion on a single criterion with COUNTIF SUMIF and ERAGEIF.mov8.84MB
  • MOV06 Statistical Functions\\0602 Ranking data without sorting with RANK.mov10.72MB
  • MOV06 Statistical Functions\\0604 Tabulating blank cells with COUNTBLANK.mov8.60MB
  • MOV06 Statistical Functions\\0601 Finding the middle value with MEDIAN.mov3.36MB
  • MOV06 Statistical Functions\\0603 Finding the gnitude data with LARGE and ALL.mov3.24MB
  • MOV07 Data Functions\\0701 Understanding Excel date time capabilities in formulas.mov13.05MB
  • MOV07 Data Functions\\0702 Identifying the day of the week with WEEKDAY.mov12.02MB
  • MOV07 Data Functions\\0705 Tabulating date time differences with DATEDIF.mov8.53MB
  • MOV07 Data Functions\\0703 Counting working days with NETWORKDAYS.mov5.26MB
  • MOV07 Data Functions\\0704 Determining a completion date with WORKDAY.mov4.27MB
  • MOV08 th Functions\\0801 Working with rounding functions.mov15.45MB
  • MOV08 th Functions\\0803 Building random number generators with RAND and RANDBETWEEN.mov11.36MB
  • MOV08 th Functions\\0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov10.80MB
  • MOV08 th Functions\\0802 Finding the remainder with MOD and using MOD with conditional formatting.mov10.39MB
  • MOV08 th Functions\\0804 Converting a value between measurement systems with CONVERT.mov7.87MB
  • MOV09 Array Formulas and Functions\\0901 Extending formula capabilities with arrays.mov17.68MB
  • MOV09 Array Formulas and Functions\\0902 Counting unique entries in a range with an array formula.mov11.49MB
  • MOV09 Array Formulas and Functions\\0906 Combining multiple functions in arrays.mov9.03MB
  • MOV09 Array Formulas and Functions\\0904 Flipping row column orientation with TRANSPOSE.mov8.95MB
  • MOV09 Array Formulas and Functions\\0905 Building analysis via regression techniques with TREND and GROWTH.mov8.54MB
  • MOV09 Array Formulas and Functions\\0903 Determining frequency distributions with FREQUENCY.mov6.05MB
  • MOV10 Text Functions\\1006 Adjusting character content with REPLACE and SUBSTITUTE.mov11.31MB
  • MOV10 Text Functions\\1001 Locating and extracting data with FIND and MID.mov10.99MB
  • MOV10 Text Functions\\1003 Removing excess spaces with TRIM.mov10.36MB
  • MOV10 Text Functions\\1007 Reviewing additional text functions.mov10.34MB
  • MOV10 Text Functions\\1005 Adjusting case within cells with PROPER UPPER and LOWER.mov9.43MB
  • MOV10 Text Functions\\1004 Using CONCATENATE with functions.mov7.29MB
  • MOV10 Text Functions\\1002 Extracting specific data with LEFT and RIGHT.mov5.82MB
  • MOV11 Financial Functions\\1101 Calculating payments with PMT.mov7.86MB
  • MOV11 Financial Functions\\1103 Determining total amount of future payments with PV.mov7.65MB
  • MOV11 Financial Functions\\1102 Finding future values with FV.mov6.28MB
  • MOV12 Infortion Functions\\1202 Using error-checking functions ISERR ISERROR IFERROR.mov12.78MB
  • MOV12 Infortion Functions\\1201 Working with the IS information functions.mov8.16MB
  • MOV13 Reference Functions\\1302 Returning references with INDIRECT.mov20.26MB
  • MOV13 Reference Functions\\1301 Getting data from remote cells with OFFSET.mov7.66MB
  • MOV14 Conclusion\\1401 Final thoughts.mov2.37MB
  • ZIPExercise Files\\Ex_Files_Excel_10_Ad_Form.zip820.28KB
Latest 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