A large percentage of Excel workbooks consist of one or more database tables (sometimes known as lists). These are used to track just about anything you can think of. Most people find that it's much easier to view and manipulate data in a spreadsheet than it is using normal database software. If the tables are set up properly, they can be summarized with a pivot table.
In Chapter 10, you'll find everything you need to know about creating custom worksheet functions, including lots of examples.
Was this article helpful?