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.
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.
Load the Solver Add-in in Excel - Microsoft Support
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel. Windows macOS Android iOS Windows Mobile. Go to File > Options.
Manage workbook links - Microsoft Support
Description of workbook link management and storage in Excel. Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
Use multiple tables to create a PivotTable - Microsoft Support
Create a PivotTable with multiple tables. Here are the three basic steps to get multiple tables into the PivotTable Field List: Import from a relational database, like Microsoft SQL Server, Oracle, or Access. You can import multiple tables at the same time: Connect to an Oracle database.
Multiply and divide numbers in Excel - Microsoft Support
There are several ways to multiply numbers. Multiply numbers in a cell. To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Multiply a column of numbers by a constant number.
Delete a PivotTable - Microsoft Support
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. When you no longer need a PivotTable, select the entire PivotTable, and press the Delete key to remove it.
SUBSTITUTE function - Microsoft Support
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Filter data in a PivotTable - Microsoft Support
In Excel, use slicers and other ways to filter large amounts of PivotTable data to show a smaller portion of that data for in-depth analysis.
OR function - Microsoft Support
Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE. Example. Technical Details. Examples. Here are some general examples of using OR by itself, and in conjunction with IF. Sales Commission Calculation.