Performing common Excel tasks in 2.0's Calc

The Filter dialog box allows you to dig deeper into the data that you've extracted from the larger spreadsheet

If you want to see other trends in this new table, you can click the Filter button right above the table and use the settings in the Filter dialog box to extract other information. For example, you might want to find out who had the most $25 sales, as shown above.

By Greg Shultz

Greg Shultz is a freelance Technical Writer. Previously, he has worked as Documentation Specialist in the software industry, a Technical Support Specialist in educational industry, and a Technical Journalist in the computer publishing industry.