O'Reilly logo

Master Visually®: Excel® 2007 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17. Analyzing Tabular Information with Functions

Understanding Database Functions

Do not let the word database frighten you. A database is nothing more than a collection of related information. The telephone book is a simple database that contains name, address, and telephone number information for many people. In database terminology, each persons entry in the book is considered a record and each record is made up of fields. In the telephone book analogy, the persons first name is a field, the persons last name is another field, the street address is another field, and so on. When you set up a database, you can decide which fields you want to include. For example, you can store the city, state, and Zip code as one field or as three separate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required