When retreiving data from another application or their mass input, especially when done by more people, occurrence of repeated values is a common thing. If it’s a small amount of data, we’ll probably be able to manually remove them. However, when reviewing large tables, we can also use the Excel option that allows you to find and remove duplicates based on one or more criteria.
Conditional formatting allows us to customize the way that cell or group of cells is displayed in order to highlight their values. When using conditional formatting options, we can use some of the predefined rules discussed earlier. However, we often want to set the rules for formatting independently, to determine the order of their operation, or to disable some of them …
Even the best reports sometimes require that some information be emphasized in order to be more visible to the observer and help him to make certain conclusions. Conditional formatting is an Excel functionality that emphasizes the appearance of a particular cell or group of cells based on one or more rules. The appearance is formed on the basis of the data value or satisfaction of the conditions specified in the formula.
When we make charts that contain multiple data series, it happens that the data in them varies greatly, in terms of value ranges, or they are set in different units of measure. Also, we will sometimes want to show different series by using different chart types. For this purpose, we choose whether the series is displayed on the primary or secondary axis, and which type of chart we want to use to display the data on it.
There are several functions in Excel that literally serve to “find the cell in time and space”. They can be used to identify the row and column in which the cell is located, count the rows or columns, determine the type of value that the cell contains … By themselves, these functions are seldom used. In combination with other functions, in conditional formatting, and especially with data validation, they can be irreplaceable.