If you encrypt an Outlook message that contains voting buttons, message recipients won't be able to see them. That feature isn't supported at this time. Create an email message or reply to or forward a message that you received. On the Options tab, in the Tracking group, click Use Voting Buttons.

A list of Excel training, from entry level to advanced skills, plus templates and other resources.

For those devices, you can sign in with an app password instead. An app password is a long, randomly generated password that you provide only once instead of your regular password when signing in to an app or device that doesn't support two-step verification.

COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1 Required. The first range in which to evaluate the associated criteria. criteria1 Required.

How to correct a #N/A error in the VLOOKUP function. Look up values with VLOOKUP, INDEX, or MATCH. HLOOKUP function. Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.

function is to expand the usefulness of other functions that perform logical tests. For example, the function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE.

VLOOKUP function. INDEX function. How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

症状. _xlfn。 prefix 显示在公式中的函数前面。 计算公式时，会显示 #NAME？ 。 原因. Excel 工作簿包含当前运行的 Excel 版本中不支持的函数。