|
|||
|
|
|
|
|
|
Analyzing Data with Excel In the dictionary, analyzing is: Dividing a whole into its elements and studying the relations between them and the whole. When the conclusions of the analysis deserve to be shared because they support a significant decision making process, the analysis can be automated and a report can be designed and issued. So the analytical process is a dynamic process. The data analyst must be able to access the data in all kinds of formats and establish all kinds of relations between elements of a whole and the whole itself. You will discover in this section that the pivot table is an analytical tool and that the SUMPRODUCT function is a reporting tool. The pivot table is a sophisticated analytical tool but Excel offers you numerous other powerful analytical tools including the extremely user friendly database functionalities. Lesson 12: Calculator/Validator in Excel
|
|
|
|
|
|
