XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Filter by using advanced criteria - Microsoft Support
Click a cell in the list range. Using the example, click any cell in the range A6:C10. On the Data tab, in the Sort & Filter group, click Advanced. Do one of the following: To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.
Define and use names in formulas - Microsoft Support
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and …
VLOOKUP function - Microsoft Support
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.
Use cell references in a formula - Microsoft Support
When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you enter or select the cell reference A2, the formula uses the value of that cell to calculate the result. You can also reference a range of cells.
INDEX function - Microsoft Support
The INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.
CORREL function - Microsoft Support
The CORREL function returns the correlation coefficient of two cell ranges. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location's average temperature and the use of air conditioners.
How to write formulas that reference data types - Microsoft Support
How to write formulas that reference data types. You can use formulas that reference linked data types. This allows you to retrieve and expose more information about a specific linked data type. In the following example, the linked data type, Stocks, is used in cells A2 through A11.
MAXIFS function - Microsoft Support
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria: numbers, dates, text, etc. This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription.
CUBEVALUE function - Microsoft Support
This article describes the formula syntax and usage of the CUBEVALUE function in Microsoft Excel. Description. Returns an aggregated value from the cube. Syntax. CUBEVALUE (connection, [member_expression1], [member_expression2], …) The CUBEVALUE function syntax has the following arguments: Connection Required.
Align or rotate text in a cell - Microsoft Support
You can align text in a single cell, a range of cells, a row or rows, a column or columns, or the entire worksheet. (Use Ctrl+A to select all cells.) Select the cells you want to align. On the Home tab, in the Alignment group, select a horizontal alignment option: Align Left. Center.