![]() Obtaining subtotals (often required when working with lists) Īnalyze data in Excel using built-in functions (mathematical, financial, logical, statistical, etc.).Įxcel uses summary tables to simplify the viewing, processing and consolidation of data. ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |