Advertisement

Data Analysis in Excel

  • Michael Kofler

Abstract

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.

Keywords

Character String Excel File Page Area Cell Pointer External Data Source 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

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