Excel 2013

  1. sample_s,number_sample,population_s,number_pop!This function is available for compatibility with Excel 2007 and earlier.Returns ...
  2. sample_s,number_sample,population_s,number_pop,cumulative!Returns the hypergeometric distribution!is the number of successes ...
  3. Saves dates and times in Open XML files using the ISO 8601 format. Times are rounded to the nearest ISO 8601 time value supported ...
  4. Saving the file as XML Data will result in the loss of worksheet features such as formatting, pictures, and objects. If you ...
  5. Saving this workbook's VBA project in the Excel 5.0/95 file format requires a component that is not currently installed. ...
  6. Saving this workbook's VBA project in the Excel 5.0/95 file format requires a component that is not currently installed. ...
  7. Scatter with only MarkersCompare pairs of values.Use it when the values are not in x-axis order or when they represent separate ...
  8. Scatter with Smooth Lines and MarkersCompare pairs of values.Use it when there are a few data points in x-axis order and ...
  9. Scatter with Smooth LinesCompare pairs of values.Use it when there are many data points in x-axis order and the data represents ...
  10. Scatter with Straight Lines and MarkersCompare pairs of values.Use it when there are a few data points in x-axis order and ...
  11. Scatter with Straight LinesCompare pairs of values.Use it when there are many data points in x-axis order and the data represents ...
  12. Select the cell containing the text you want to center and the blank cells you want to center the text across. The blank ...
  13. Select the cells where you want the blank cells inserted. You can choose to have the existing cells moved down or to the ...
  14. Select the entire outline or a level in the outline that you want to apply styles to. If you select a level that includes ...
  15. Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver ...
  16. Select the new data that you want to add to the chart. Include the cells containing row or column labels if you want those ...
  17. Select to use automatic scaling when inputs and outputs have large differences in magnitude. For example, when maximizing ...
  18. Selecting Convert Report Filters also permanently replaces existing report filters by substituting formulas for them, removing ...
  19. Send your contact an instant message containing a link to this workbook. If you want to send the file itself, first save ...
  20. serial_number!Returns the day of the month, a number from 1 to 31.!is a number in the date-time code used by Microsoft Excel! ...
  21. serial_number!Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).!is a number in the date-time code used ...
  22. serial_number!Returns the minute, a number from 0 to 59.!is a number in the date-time code used by Microsoft Excel or text ...
  23. serial_number!Returns the month, a number from 1 (January) to 12 (December).!is a number in the date-time code used by Microsoft ...
  24. serial_number!Returns the second, a number from 0 to 59.!is a number in the date-time code used by Microsoft Excel or text ...
  25. serial_number!Returns the year of a date, an integer in the range 1900 - 9999.!is a number in the date-time code used by ...
  26. serial_number,return_type!Returns a number from 1 to 7 identifying the day of the week of a date.!is a number that represents ...
  27. serial_number,return_type!Returns the week number in the year!is the date-time code used by Microsoft Excel for date and ...
  28. Sets made exclusively of measures support only a single instance of any one measure. Duplicate instances of measures will ...
  29. settlement,maturity,coupon,yld,frequency,basis!Returns the annual duration of a security with periodic interest payments!is ...
  30. settlement,maturity,coupon,yld,frequency,basis!Returns the Macauley modified duration for a security with an assumed par ...
  31. settlement,maturity,discount!Returns the bond-equivalent yield for a treasury bill!is the Treasury bill's settlement date, ...
  32. settlement,maturity,discount!Returns the price per $100 face value for a treasury bill!is the Treasury bill's settlement ...
  33. settlement,maturity,discount,redemption,basis!Returns the price per $100 face value of a discounted security!is the security's ...
  34. settlement,maturity,frequency,basis!Returns the next coupon date after the settlement date!is the security's settlement date, ...
  35. settlement,maturity,frequency,basis!Returns the number of coupons payable between the settlement date and maturity date!is ...
  36. settlement,maturity,frequency,basis!Returns the number of days from the beginning of the coupon period to the settlement ...
  37. settlement,maturity,frequency,basis!Returns the number of days from the settlement date to the next coupon date!is the security's ...
  38. settlement,maturity,frequency,basis!Returns the number of days in the coupon period that contains the settlement date!is ...
  39. settlement,maturity,frequency,basis!Returns the previous coupon date before the settlement date!is the security's settlement ...
  40. settlement,maturity,investment,discount,basis!Returns the amount received at maturity for a fully invested security!is the ...
  41. settlement,maturity,investment,redemption,basis!Returns the interest rate for a fully invested security!is the security's ...
  42. settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,basis!Returns the yield of a security with an odd first ...
  43. settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security ...
  44. settlement,maturity,issue,rate,pr,basis!Returns the annual yield of a security that pays interest at maturity!is the security's ...
  45. settlement,maturity,issue,rate,yld,basis!Returns the price per $100 face value of a security that pays interest at maturity!is ...
  46. settlement,maturity,last_interest,rate,pr,redemption,frequency,basis!Returns the yield of a security with an odd last period!is ...
  47. settlement,maturity,last_interest,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security ...
  48. settlement,maturity,pr!Returns the yield for a treasury bill!is the Treasury bill's settlement date, expressed as a serial ...
  49. settlement,maturity,pr,redemption,basis!Returns the annual yield for a discounted security. For example, a treasury bill!is ...
  50. settlement,maturity,pr,redemption,basis!Returns the discount rate for a security!is the security's settlement date, expressed ...
  51. settlement,maturity,rate,pr,redemption,frequency,basis!Returns the yield on a security that pays periodic interest!is the ...
  52. settlement,maturity,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security that pays periodic ...
  53. Shared workbook from Microsoft Excel 95 must be opened read-only.To edit the workbook, click OK, then click Save As and save ...
  54. Shared workbooks cannot contain tables. You must either turn off sharing or disable the table functionality for this workbook. ...
  55. Shared Workbooks do not support the format of your data. Remove any Hyperlinks or Merged Cells to complete the operation. ...
  56. Sheet names cannot be blank, greater than 31 characters in length, start or end with a single quote, or contain any of the ...
  57. Sheet names should provide information about what is found on the sheet. Blank sheets should be removed.To rename a sheet:1) ...
  58. Show a list of relevant functions and defined names when building cell formulas.This functionality can be enabled or disabled ...
  59. Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer. Select a single ...
  60. Show Details" is not available when a Timeline control is filtering the data. You could use a Slicer with a single selection ...
  61. Show Details" is not available when a Timeline control is filtering the data. You could use a Slicer with a single selection ...
  62. Show values as" calculations cannot be used with value fields for which values have been changed using PivotTable what-if ...
  63. Show values as" calculations cannot be used with value fields for which values have been changed using PivotTable what-if ...
  64. show_option,auto_text,show_key,has_leaderlines,show_seriesname,show_categoryname,show_value,show_percentage,show_bubblesizes,separator ...
  65. Signatures cannot be added because this workbook is embedded in another file or is hosted within another program, such as ...
  66. Signatures cannot be added or removed because this read-only workbook has been changed. To add or remove signatures, enable ...
  67. Signatures cannot be added or removed, because this workbook contains linked images that are stored outside the file.To correct ...
  68. Since this workbook is protected for sharing, you cannot decrease the number of days to keep the change history. You can ...
  69. Solver has performed 5 iterations for which the objective did not move significantly. Try a smaller convergence setting, ...
  70. Solver32.dll is unavailable - you will be able to define and edit Solver models, but not actually solve them. To fix this, ...
  71. Some array formulas in this workbook refer to an entire column. In earlier versions of Excel, these formulas may be converted ...
  72. Some cells contain conditional formatting with the 'Format entire row' option selected. This version of Excel does not recognize ...
  73. Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize ...
  74. Some cells contain multiple conditional formatting rules that should all be evaluated and shown. This version of Excel does ...
  75. Some cells have more conditional formats than are allowed in this version of Excel. Only the first three conditions will ...