Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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.
LOOKUP function - Microsoft Support
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price.
Customize the Quick Access Toolbar - Microsoft Support
For example, you can create custom tabs and custom groups to contain your frequently used commands. What do you want to do? Right-click in the ribbon and do either of the following: If the Quick Access Toolbar is shown, select Hide Quick Access Toolbar. If the Quick Access Toolbar is hidden, select Show Quick Access Toolbar.
Create and share a Dashboard with Excel and Microsoft Groups
In this topic, we’ll discuss how to use multiple PivotTables, PivotCharts and PivotTable tools to create a dynamic dashboard.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Create a Data Model in Excel - Microsoft Support
Each table needs to have a primary key, or unique field identifier, like Student ID, or Class number. The easiest way is to drag and drop those fields to connect them in Power Pivot's Diagram View . Go to Power Pivot > Manage .
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of …
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
Get started with Python in Excel - Microsoft Support
To begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell. Or use the function =PY in a cell to enable Python.