Chapter 10

Creating Databases Using Tables

Packed with more than 16,000 columns and more than 1 million rows, each Excel worksheet has enough space to contain serious amounts of data—so it's great for creating a database to store information and quickly find the items you need.

In this chapter, you'll learn to use Excel's tables to create databases for storing information, sorting it, and filtering it to show the information you need. You'll also learn how to put Excel's database functions to work with tables.

Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.