Calc As A Simple Database

Apache OpenOffice 4.1 Calc Guide

Chapter 13 Calc as a Simple Database

< Previous Section

Next Section >

• Introduction
  • Example Data
• Associating a Range with a Name
  • Named Range
  • Database Range
• Sorting
• Filters
  • Auto Filters
  • Standard Filters
  • Advanced Filters
  • Manipulating Filtered Data
• Calc Functions Similar to Database Functions
  • Count and Sum Cells that Match Conditions: COUNTIF, COUNTIFS, SUMIF, SUMIFS, and SUMPRODUCT
  • Ignore Filtered Cells Using SUBTOTAL
  • Using Formulas to Find Data
    • Search a Block of Data Using VLOOKUP
    • Search a Block of Data Using HLOOKUP
    • Search a Row or Column Using LOOKUP
    • Use MATCH to Find the Index of a Value in a Range
    • Examples
  • ADDRESS Returns a String with a Cell’s Address
  • INDIRECT Converts a String to a Cell or Range
  • INDEX Returns Cells Inside a Specified Range
• Database-specific Functions
• Macros for a Calc Database
  • Macros for Named Ranges
    • Naming Multiple Ranges
  • Macro for a Database Range
  • Macros for Filtering
    • Macros for Advanced Filters

< Previous Page

Next Page >