O'Reilly logo

Learn Excel 2016 for OS X, Second Edition 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

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.

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. ...

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