StarOffice™ 5.2 Calc Handbook

Understanding Advanced Data Analysis

In the previous chapter, we took a look at a number of the features that Calc offers to manipulate data in a list or table. You worked with the Sort and Filter features and became familiar with grouping records using the Outline feature. You also became familiar with some of the issues related to importing and exporting data into and out of Calc.

In this chapter, we will continue to look at lists and databases and tackle some of the more advanced features that can be used to analyze data in a table. We will look at how you can create subtotals for your database data and how you can consolidate data using the Consolidate command. Consolidating data allows you to summarize information found on a number of sheets ...