Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Create, load, or edit a query in Excel (Power Query)
Manage queries in Excel. Power Query offers several options for loading queries into your workbook. You set default query load settings in the Options dialog popup.
Tutorial: Import Data into Excel, and Create a Data Model
When you import tables from a database, the existing database relationships between those tables is used to create the Data Model in Excel. The Data Model is transparent in Excel, but you can view and modify it directly using the Power Pivot add-in. The Data Model is discussed in more detail later in this tutorial.
Split text into different columns with functions - Microsoft Support
This example uses a two-part first name, Mary Kay. The second and third spaces separate each name component. Copy the cells in the table and paste into an Excel worksheet at cell A1.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
AGGREGATE function - Microsoft Support
The AGGREGATE function syntax has the following arguments: Function_num Required. A number 1 to 19 that specifies which function to use. Options Required. A numerical value that determines which values to ignore in the evaluation range for the function.
Using wildcard characters in searches - Microsoft Support
This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Count how often a value occurs - Microsoft Support
There are several ways to count how often a value occurs. Count how often a single value occurs by using the COUNTIF function. Count based on multiple criteria by using the COUNTIFS function. Count based on criteria by using the COUNT and IF functions together.
Using structured references with Excel tables - Microsoft Support
When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. Here's an example of what Excel does: That combination of table and …
Excel functions (alphabetical) - Microsoft Support
Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. A complete list of all Excel functions in alphabetical order.
Microsoft 365 Quick Starts - Microsoft Support
Training: Get started quickly on all of your favorite Microsoft 365 apps with our popular Quick Start guides.