Remove or allow a circular reference - Microsoft Support
You can move between cells in a circular reference by double-clicking the tracer arrow. The arrow indicates the cell that affects the value of the currently selected cell. You show the tracer arrow by selecting Formulas, and then select either Trace Precedents or Trace Dependents.
Change formula recalculation, iteration, or precision in Excel
Iteration is the repeated recalculation of a worksheet until a specific numeric condition is met. Excel cannot automatically calculate a formula that refers to the cell — either directly or indirectly — that contains the formula. This is called a circular reference.
Create conditional formulas - Microsoft Support
You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check. value_if_true: The value to return if the condition is True.
Split a column of text (Power Query) - Microsoft Support
You can split a column with a text data type into two or more columns by using the number of characters within a text value. Select the column you want to split. Ensure the column is a text data type. textbox, enter the number of characters used to split the text column.
Python in Excel DataFrames - Microsoft Support
Python in Excel can output a DataFrame in two ways: as a Python object or converted to Excel values. When a DataFrame is returned as a Python object, the cell displays the text “DataFrame”, preceded by a card icon. The following screenshot shows a …
OR function - Microsoft Support
function is to expand the usefulness of other functions that perform logical tests. For example, the function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE.
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.
Use slicers to filter data - Microsoft Support
Use slicers to filter data. Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed. Windows macOS Web.