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.

Find help and support content for Microsoft Phone Link. Learn time-saving tips and explore how you can use Phone Link to stay productive.

If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.

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.

Overview of formulas in Excel. SUM function. How to create simple formulas in Excel using AutoSum and the SUM function, along with the add, subtract, multiply, or divide values in your worksheet.

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.

You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5.

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