Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Advanced Data Analysis and Ma... > Understanding Advanced Data Analysis

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 or spreadsheets.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint