Sorting and filtering (changing the order of the rows according to the specified parameter).Data consolidation (consolidation of several data sets).Helps find the best solution for a particular task. Used in situations when it is necessary to show the effect of variable values on formulas in the form of a table. It is used when the user knows the result of the formula, but the input information for this result is unknown. It is used to generate, change and save different sets of input data and the results of calculations for a group of formulas. One of the most attractive data analysis is "What-if Analysis".
0 Comments
Leave a Reply. |