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