Template:Documentation/CG3Ch13TOC

OpenOffice.org 3 Calc Guide

Chapter 13 Calc as a Simple Database

< {{#switch:Previous Section

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}}

{{#switch:Next Section

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}} >

• Associating a range to a name
• Sorting data
• Filters
• Advanced filters
• Calc functions similar to database functions
• Using formulas to find data
• Address, Indirect, Offset, Index
• Database-specific functions

[[{{{PrevPage}}}|< {{#switch:Previous Page

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}} ]]

[[{{{NextPage}}}|{{#switch:Next Page

Previous Section = Previous Section

Next Section = Next Section

Previous Page = Previous Page

Next Page = Next Page

}} >]]