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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2003 Michael Kofler
About this chapter
Cite this chapter
Kofler, M. (2003). Data Analysis in Excel. In: Definitive Guide to Excel VBA. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0666-8_13
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0666-8_13
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-103-1
Online ISBN: 978-1-4302-0666-8
eBook Packages: Springer Book Archive