Consolidation is the term that denotes the unification of several parts into a single entity. In practice, we use consolidation when we want to receive a summary report; for example, when we want to summarize the sale by months, quarters, years … The simplest way to do this is by summarizing the data entered in several worksheets in the last sheet using the formula. But what if the data in the worksheets is not uniform? Excel also has a solution for this scenario …
When entering the parameters of a calculation, it is useful when we can check that the correct values are entered. This type of control serves to check whether a good type of data is entered, whether the values are in the reference range, and can be used to help when entering data into a table. In this way, Excel can also be used as a tool for completing a questionnaire with predefined answers.
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.