9. Using Excel's Database Features

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch9

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

Billo, E. J. (2011) Using Excel's Database Features, in Excel for Chemists®: A Comprehensive Guide, Third Edition, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118093955.ch9

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 16 SEP 2011

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • Excel's database;
  • database structure;
  • database creation;
  • sort options;
  • AutoFilter

Summary

This chapter contains sections titled:

  • The Structure of a List or Database

  • Updating a Database Using Data Form

  • Sorting a List

  • Using AutoFilter to Obtain a Subset of a List

  • Using Advanced Filter to Obtain a Subset of a List

  • Using Database Functions