Use the Selection pane to manage objects in documents
You can use the Selection pane to manage objects in your document: re-order them, show or hide them, and group or ungroup them. Tip: In Word, you might want to set the location of objects within a paragraph. When you move a paragraph, the corresponding anchored image (s) move with the paragraph.
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.
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.
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms.
Remove hidden data and personal information by inspecting …
Document Inspector helps you find and remove hidden data and personal information stored in documents that you plan to share. Here's how to use it. Tip: If you're just looking to print without comments, on the File tab select Print, choose Print All Pages, and clear Print Markup.
Find and select cells that meet specific conditions
Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on the worksheet that contains data or formatting. Follow these steps: To search the entire worksheet for specific cells, click any cell.
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
Excel functions (alphabetical) - Microsoft Support
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences. Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.
Import data from a folder with multiple files (Power Query) - Microsoft …
Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of …
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, select 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 …
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.