Analyzing Data with Excel

Section 3: 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
Lesson 13: Comparative Analyses in Excel
Lesson 14: Excel Database Requirements
Lesson 15: Database Filters in Excel
Lesson 16: Sorting Data in Excel
Lesson 17: Database Form in Excel
Lesson 18: Database Subtotals in Excel
Lesson 19: Pivot Tables in Excel (as analysis tool)