O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Creating Databases in Excel

When you need to store a lot of the same type of information in a worksheet, you can create a database in a table. For example, if you run a business, you can make a database of your customers and their orders.

The first step is to set up the table and to tell Excel that you're creating a table rather than a regular worksheet. The next step is to add your data to the table, either by typing it into the cells as usual or by using a data-entry form.

Once the data is in the table, you can sort the table to reveal different aspects of its contents or filter it to identify items that match the criteria you specify.

Understanding What You Can and Can't Do with Excel Tables

Before you start creating a table in Excel, it's ...

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