Outline (group) data in a worksheet - Microsoft Support
If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.
Group or ungroup data in a PivotTable - Microsoft Support
Group or ungroup data in a PivotTable. Grouping 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. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.
Automatically number rows - Microsoft Support
Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
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.
Ways to count values in a worksheet - Microsoft Support
Use the SUBTOTAL function to count the number of values in an Excel table or range of cells. If the table or range contains hidden cells, you can use SUBTOTAL to include or exclude those hidden cells, and this is the biggest difference between SUM and SUBTOTAL functions. The SUBTOTAL syntax goes like this: SUBTOTAL (function_num,ref1, [ref2],...)
Create a 3-D reference to the same cell range on multiple …
You can use a 3-D reference to add up budget allocations between three departments, Sales, HR, and Marketing, each on a different worksheet, by using the following 3-D reference: =SUM (Sales:Marketing!B3) You can even add another worksheet, and then move it into the range that your formula refers to.
Tutorial: Import Data into Excel, and Create a Data Model
These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View. The tutorials are designed to demonstrate Microsoft Business Intelligence features and capabilities in …
COUNT function - Microsoft Support
How to use the COUNT function in Excel to count the number of cells that contain numbers, and to count numbers within a list of arguments.
Create a custom number format - Microsoft Support
Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format codes, see Review guidelines for customizing a number format. Select the numeric data. On the Home tab, in the Number group, select the small arrow to open the Dialog box. Select Custom.
Multiply and divide numbers in Excel - Microsoft Support
There are several ways to multiply numbers. To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Suppose you want to multiply each cell in a column of seven numbers by …
Create a 3-D reference to the same cell range on multiple worksheets ...
You can use a 3-D reference to add up budget allocations between three departments, Sales, HR, and Marketing, each on a different worksheet, by using the following 3-D reference: =SUM (Sales:Marketing!B3) You can even add another worksheet, and then move it into the range that your formula refers to.