Data Analysis in Excel

  • Michael Kofler


Excel is not a database system. Its strengths are in its extensive data analysis capabilities. The central section of this chapter is devoted to pivot tables. These are a very capable tool for grouping and organizing data with several parameters clearly. A feature of pivot tables is that with them data can be analyzed that are not even located in an Excel worksheet, but, for example, in an external database.


Character String Excel File Page Area Cell Pointer External Data Source 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Kofler 2000

Authors and Affiliations

  • Michael Kofler

There are no affiliations available

Personalised recommendations