9. Tables and Worksheet Databases

  1. John Walkenbach

Published Online: 1 NOV 2011

DOI: 10.1002/9781118257630.ch9

Excel® 2010 Formulas

Excel® 2010 Formulas

How to Cite

Walkenbach, J. (2010) Tables and Worksheet Databases, in Excel® 2010 Formulas, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257630.ch9

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 10 MAY 2010

ISBN Information

Print ISBN: 9780470475362

Online ISBN: 9781118257630

SEARCH

Keywords:

  • tables;
  • worksheet;
  • databases;
  • Excel;
  • subtotal

Summary

This Chapter contains sections titled:

  • Tables and Terminology

  • Working with Tables

  • Using Advanced Filtering

  • Specifying Advanced Filter Criteria

  • Using Database Functions

  • Inserting Subtotals