589689.xyz

Lynda - Excel 2016 Advanced Formulas and Functions

  • 收录时间:2018-02-26 05:36:08
  • 文件大小:1GB
  • 下载次数:323
  • 最近下载:2021-01-17 10:50:02
  • 磁力链接:
立即下载 复制链接

文件列表

  1. Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions-463375.mp4 23MB
  2. Tabulating data from multiple sheets-463302.mp4 23MB
  3. Using Auditing tools-463295.mp4 22MB
  4. Understanding Excel date and time capabilities in formulas-463345.mp4 22MB
  5. Using the powerful AGGREGATE function to bypass errors and hidden data-463342.mp4 21MB
  6. Finding approximate matches with VLOOKUP and HLOOKUP-463317.mp4 21MB
  7. Using INDIRECT with Data Validation for two-tiered pick list scenarios-463363.mp4 21MB
  8. AND, OR, and NOT functions with IF-463314.mp4 20MB
  9. Preventing double counting-463328.mp4 18MB
  10. Locating and extracting data with the FIND, SEARCH, and MID functions-463365.mp4 18MB
  11. Counting unique entries in a range with an array formula-463355.mp4 17MB
  12. Tabulating data using multiple criteria-463327.mp4 17MB
  13. Using array formulas and the MATCH function for complex lookups-463359.mp4 17MB
  14. Displaying and highlighting formulas-463294.mp4 16MB
  15. Using VLOOKUP with large tables-463320.mp4 16MB
  16. Using autocalculate in the status bar-463310.mp4 16MB
  17. Absolute and relative references-463308.mp4 16MB
  18. Converting formulas to values with a drag-463298.mp4 16MB
  19. Using the SWITCH function for formula-embedded selection-480582.mp4 16MB
  20. Formulas tab for locating functions-463305.mp4 16MB
  21. Counting working days with the NETWORKDAYS function-463349.mp4 16MB
  22. Finding exact matches with VLOOKUP-463318.mp4 15MB
  23. Exploring practical uses for the RAND and RANDBETWEEN functions-463340.mp4 15MB
  24. Using the TODAY and NOW functions for dynamic date and time entry-463347.mp4 15MB
  25. Using the CONCAT and TEXTJOIN to combine data from different cells-480584.mp4 15MB
  26. Finding the remainder with MOD and using MOD with conditional formatting-463339.mp4 15MB
  27. Tabulating date differences with the DATEDIF function-463351.mp4 15MB
  28. Using mixed references in formulas-463309.mp4 15MB
  29. Hierarchy of operations in formulas-463304.mp4 15MB
  30. Using the TRIM function to remove unwanted spaces in a cell-463367.mp4 15MB
  31. Tabulating blank cells with the COUNTBLANK function-463333.mp4 15MB
  32. Extending formula capabilities with array formulas-463354.mp4 15MB
  33. Using ampersands and CONCATENATE to combine data from different cells-463368.mp4 15MB
  34. Extending the capabilities of AutoSum-463307.mp4 15MB
  35. Enhancing readability with range names-463301.mp4 14MB
  36. Working with the ROUND, ROUNDUP, and ROUNDDOWN functions-463336.mp4 14MB
  37. Getting data from remote cells with the OFFSET function-463361.mp4 14MB
  38. Flipping row and column orientation with TRANSPOSE-463357.mp4 14MB
  39. Adjusting character content with the REPLACE and SUBSTITUTE functions-463370.mp4 14MB
  40. Tabulating data using a single criterion-463326.mp4 14MB
  41. Insert Function for learning about unfamiliar functions-463306.mp4 14MB
  42. Calculating end-of-month and future and past dates with EDATE and EOMONTH-463352.mp4 13MB
  43. Using MAXIFS and MINIFS-480583.mp4 13MB
  44. Using MATCH and INDEX functions together-463324.mp4 13MB
  45. Ranking data without sorting with RANK and RANK.EQ-463331.mp4 13MB
  46. Identifying the day of the week with the WEEKDAY function-463348.mp4 13MB
  47. Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER-463374.mp4 12MB
  48. Using entire row and column references-463296.mp4 12MB
  49. Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions-463346.mp4 12MB
  50. Nesting lookup functions-463319.mp4 12MB
  51. Looking up information with VLOOKUP and HLOOKUP-463316.mp4 11MB
  52. Using the utility text functions - TEXT, REPT, and LEN-463371.mp4 11MB
  53. Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions-463369.mp4 11MB
  54. Using the INT and TRUNC functions to extract integer data-463338.mp4 11MB
  55. Expanding nested IF statements-463313.mp4 11MB
  56. Determining a completion date with the WORKDAY function-463350.mp4 11MB
  57. Determining frequency distributions with the FREQUENCY function-463356.mp4 11MB
  58. Extracting information with the CELL and INFO functions-463373.mp4 10MB
  59. Debugging formulas with the F9 key-463300.mp4 10MB
  60. Extracting specific data with the LEFT and RIGHT functions-463366.mp4 10MB
  61. Building analysis via regression techniques with TREND and GROWTH-463358.mp4 10MB
  62. Locating data with the MATCH function-463322.mp4 10MB
  63. IF logical tests-463312.mp4 10MB
  64. Using COUNT, COUNTA, and the status bar-463334.mp4 9MB
  65. Copying column formulas instantly-463297.mp4 9MB
  66. Using the ROMAN and ARABIC functions to display different number systems-463343.mp4 9MB
  67. Updating values without formulas-463299.mp4 9MB
  68. Returning references with the INDIRECT function-463362.mp4 9MB
  69. Converting a value between measurement systems with CONVERT-463341.mp4 8MB
  70. Tracking and highlighting formula cells with the ISFORMULA function-463376.mp4 8MB
  71. Retrieving information by location-463323.mp4 8MB
  72. Using IFS for multiple conditions-480581.mp4 8MB
  73. Working with MROUND, CEILING, and FLOOR for specialized rounding-463337.mp4 8MB
  74. Finding the middle value with MEDIAN and most common value with MODE-463330.mp4 7MB
  75. Finding table-like information within a function using the CHOOSE function-463321.mp4 7MB
  76. Welcome-463291.mp4 7MB
  77. Finding the largest and smallest values with the LARGE and SMALL functions-463332.mp4 5MB
  78. Next steps-463378.mp4 2MB
  79. Using the exercise files-463292.mp4 1MB
  80. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch03/03-IF Function.xlsx 580KB
  81. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch02/02-Tools.xlsx 444KB
  82. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch05/05-COUNTIF-SUMIF.xlsx 329KB
  83. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch01/01-TipsShortcuts.xlsx 270KB
  84. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch04/04-LookupFunctions.xlsx 242KB
  85. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch06/06-Stat.xlsx 132KB
  86. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch09/09-Array.xlsx 129KB
  87. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch07/07-Math.xlsx 68KB
  88. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch08/08-Date.xlsx 65KB
  89. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch11/11-Text.xlsx 31KB
  90. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch10/10-Reference.xlsx 29KB
  91. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch01/01-Sales by State.xlsx 18KB
  92. Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch12/12-Information.xlsx 17KB