Excel 2016

  1. Stacked ColumnCompare the contribution of each value to a total across categories by using vertical rectangles.Use it to ...
  2. Stacked ColumnCompare the percentage that each value contributes to a total across categories by using vertical rectangles.Use ...
  3. Stacked Line with MarkersDisplay the trend of the contribution of each value over time or ordered categories.Consider using ...
  4. Stacked Line with MarkersDisplay the trend of the percentage each value contributes over time or ordered categories.Consider ...
  5. Stacked LineDisplay the trend of the contribution of each value over time or ordered categories.Consider using a stacked ...
  6. Stacked LineDisplay the trend of the percentage each value contributes over time or ordered categories.Consider using a 100% ...
  7. start_date,days,holidays!Returns the serial number of the date before or after a specified number of workdays!is a serial ...
  8. start_date,days,weekend,holidays!Returns the serial number of the date before or after a specified number of workdays with ...
  9. start_date,end_date,basis!Returns the year fraction representing the number of whole days between start_date and end_date!is ...
  10. start_date,end_date,holidays!Returns the number of whole workdays between two dates!is a serial date number that represents ...
  11. start_date,end_date,method!Returns the number of days between two dates based on a 360-day year (twelve 30-day months)!start_date ...
  12. start_date,end_date,weekend,holidays!Returns the number of whole workdays between two dates with custom weekend parameters!is ...
  13. start_date,months!Returns the serial number of the date that is the indicated number of months before or after the start ...
  14. start_date,months!Returns the serial number of the last day of the month before or after a specified number of months!is ...
  15. sum_range,criteria_range,criteria,.!Adds the cells specified by a given set of conditions or criteria!are the actual cells ...
  16. Tables are storage units within the database. If you specify a default table, the Query Wizard initially displays all fields ...
  17. target_date,values,timeline,confidence_level,seasonality,data_completion,aggregation!Returns a confidence interval for the ...
  18. target_date,values,timeline,seasonality,data_completion,aggregation!Returns the forecasted value for a specific future target ...
  19. Text values in formulas are limited to 255 characters. To create longer text values in a formula, use the CONCATENATE function ...
  20. text!Changes full-width (double-byte) characters to half-width (single-byte) characters. Use with double-byte character sets ...
  21. text!Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. Use with ...
  22. text!Converts a text string that represents a number to a number!is the text enclosed in quotation marks or a reference to ...
  23. text!Converts a text string to all uppercase letters!is the text you want converted to uppercase, a reference or a text string! ...
  24. text!Converts a text string to proper case; the first letter in each word to uppercase, and all other letters to lowercase!is ...
  25. text!Converts all letters in a text string to lowercase!is the text you want to convert to lowercase. Characters in Text ...
  26. text!Removes all nonprintable characters from text!is any worksheet information from which you want to remove nonprintable ...
  27. text!Removes all spaces from a text string except for single spaces between words!is the text from which you want spaces ...
  28. text!Returns a numeric code for the first character in a text string, in the character set used by your computer!is the text ...
  29. text!Returns the number (code point) corresponding to the first character of the text!is the character that you want the ...
  30. text!Returns the number of characters in a text string!is the text whose length you want to find. Spaces count as characters! ...
  31. text!Returns the number of characters in a text string. Use with double-byte character sets (DBCS)!is the text whose length ...
  32. text,decimal_separator,group_separator!Converts text to number in a locale-independent manner!is the string representing ...
  33. text,number_times!Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string!is ...
  34. text,num_bytes!Returns the specified number of characters from the end of a text string. Use with double-byte character sets ...
  35. text,num_bytes!Returns the specified number of characters from the start of a text string. Use with double-byte character ...
  36. text,num_chars!Returns the specified number of characters from the end of a text string!is the text string that contains ...
  37. text,num_chars!Returns the specified number of characters from the start of a text string!is the text string containing the ...
  38. text,old_text,new_text,instance_num!Replaces existing text with new text in a text string!is the text or the reference to ...
  39. text,start_num,num_bytes!Returns characters from the middle of a text string, given a starting position and length. Use with ...
  40. text,start_num,num_chars!Returns the characters from the middle of a text string, given a starting position and length!is ...
  41. text1,text2!Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive!is the ...
  42. text1,text2,.!Joins several text strings into one text string!are 1 to 255 text strings to be joined into a single text string ...
  43. That command cannot be performed on a protected sheet because the source data for this PivotTable report requires a data ...
  44. That command cannot be performed while a protected sheet contains another PivotTable report based on the same source data.To ...
  45. That command cannot be used with selections that contain entire rows or columns, and also other cells. Try selecting only ...
  46. That control can only be used while the worksheet is displayed in a separate window. Do you want to open a window for the ...
  47. That workbook cannot be merged because it contains changes that have not been merged followed by later changes that have ...
  48. The "Evaluate calculated members from OLAP server in filters" setting will also be changed for all other PivotTables connected ...
  49. The "Include new items in manual filter" setting will also be changed for this field in all other PivotTables connected to ...
  50. The "Show calculated members from OLAP server" setting will also be changed for all other PivotTables connected to the same ...
  51. The 'Applies To' range and the 'Data Source' range for the selected rule do not match. Select the entire Data Source range ...
  52. The action cannot be completed in Compatibility Mode. To complete the action, you can select less data or save the workbook ...
  53. The calculated field could not be deleted because insufficient memory is available. Simplify the PivotTable report, or close ...
  54. The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested ...
  55. The change history for this workbook is corrupt. Unless the workbook is removed from shared use, Excel may not be able to ...
  56. The changes you made to this query, such as choosing a different data object or changing columns, have altered the original ...
  57. The Chart Data Range is too complex to be displayed. If a new Data Range is selected, it will replace all of the series on ...
  58. The chart name that you specified contains characters that cannot be used. Use any character in a chart name except a colon ...
  59. The chart name you specified cannot be used. You can use any character in a chart name except a colon (:), backslash (\), ...
  60. The column width that you have selected is wider than a page. If you continue, Page Layout View will be unable to correctly ...
  61. The column you selected is not in the original selected range. Either select a column in the original selected range, or ...
  62. The column you selected is not in the original selected range. Either select a column in the original selected range, or ...
  63. The command could not be completed because you are attempting to filter on a cell in the table header. Select a cell in the ...
  64. The command could not be completed because you are attempting to filter on a total row cell. Select a cell in the table's ...
  65. The command could not be completed because you are attempting to filter on the filter header. Select a single cell in the ...
  66. The command text isn't set for the connection |0. To edit the command text, go to the Connections Manager on the Data tab ...
  67. The Compare and Merge operation cannot be completed because some parts of the document being merged from could not be read. ...
  68. The connection in this workbook will no longer be identical to the connection defined in the external file located at '|'.The ...
  69. The current operation cannot be completed.Possible reasons include: - You attempted to drill down from the lowest level of ...
  70. The current selection includes one or more calculated members that cannot be manually filtered. To apply the filter to the ...
  71. The current selection is not within a refreshable region of the workbook.Select a refreshable region, such as a PivotTable, ...
  72. The current title is based on a formula which cannot be displayed. If a new title is entered, it will replace the formula. ...
  73. The Data Connection File {1} used in the workbook is not in a trusted location. The following connections failed to refresh:{2} ...
  74. The data connection path in the workbook points to a file on the local drive or is an invalid URI.The following connections ...
  75. The data connection uses None as the external data authentication method and Unattended Service Account has not been configured. ...