LOOKUP function - Microsoft Support
The LOOKUP function vector form syntax has the following arguments: lookup_value Required. A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value. lookup_vector Required. A range that contains only one row or one column.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern.
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.
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.
Download free, pre-built templates - Microsoft Support
You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover …
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
Manage workbook links - Microsoft Support
There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.
Keyboard shortcuts in Microsoft 365
Keyboard shortcuts for the File menu in Microsoft 365 for Windows. Keyboard shortcuts for SmartArt graphics in Microsoft 365 for Windows. Use a keyboard to customize the Quick Access Toolbar. Use the keyboard to work with the ribbon.
Add or remove titles in a chart - Microsoft Support
To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.
LEFT, LEFTB functions - Microsoft Support
LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. These functions may not be available in all languages.
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.