Guidelines and examples of array formulas - Microsoft Support
网页The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as existing array formulas entered as both dynamic and legacy arrays.
Consolidate multiple worksheets into one PivotTable
网页To summarize and report results from separate worksheet ranges, you can consolidate data from each separate worksheet range into a PivotTable on a master worksheet. The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook.
Lookup and reference functions (reference) - Microsoft Support
网页Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
Create a Map chart in Excel - Microsoft Support
网页Create a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to …
Show or hide subtotals and totals in a PivotTable
网页Click Design > Subtotals. Pick the option you want: Do Not Show Subtotals. Show all Subtotals at Bottom of Group. Show all Subtotals at Top of Group. Tips: To include filtered items in the total amounts: Click Include Filtered Items in …
Look up values in a list of data - Microsoft Support
网页Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and OFFSET functions to find related data in rows and columns in Excel.
Use the SUM function to sum numbers in a range
网页You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
How to avoid broken formulas - Microsoft Support
网页Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.
Manage your household budget in Excel - Microsoft Support
网页This Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. Compare projected costs with actual costs to hone your budgeting skills over time.
Use the Name Manager in Excel - Microsoft Support
网页Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope.
AVERAGEIFS function - Microsoft Support
网页The AVERAGEIFS function syntax has the following arguments: Average_range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers. Criteria_range1, criteria_range2, …