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.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