Copy and paste using the Office Clipboard - Microsoft Support
WEBThe Office Clipboard allows you to copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a workbook or datasheet, and a graphic from a presentation, and then paste them all into a document. By using the Office Clipboard, …
Copy visible cells only - Microsoft Support
WEBIf some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in this article to copy visible cells only. For example, you can choose to copy only ...
Using IF with AND, OR, and NOT functions in Excel
WEBTechnical Details. Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like this: AND – =IF (AND (Something is True, Something else is True), Value if True, Value if False)
Outline (group) data in a worksheet - Microsoft Support
WEBUse an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.
Group or ungroup data in a PivotTable - Microsoft Support
WEBGrouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Windows Mac.
GROUPBY function - Microsoft Support
WEBThe GROUPBY function allows you to group, aggregate, sort, and filter data based on the fields you specify. The syntax of the PIVOTBY function is: GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship])
Check if a cell contains text (case-insensitive) - Microsoft Support
WEBFind cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.
Find and remove duplicates - Microsoft Support
WEBUse conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them. Select the cells you want to check for duplicates. Note: Excel can’t highlight duplicates in the Values area of a PivotTable report.
Create a relationship between tables in Excel - Microsoft Support
WEBHave you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
AGGREGATE function - Microsoft Support
WEBReturns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values.
Create a drop-down list - Microsoft Support
WEBLock or unlock specific areas of a protected worksheet. You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.