O'Reilly logo

Office 2010 Made Simple 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 15

Creating Databases and Solving Business Problems

In this chapter, I'll show you how to create databases and solve business problems in Excel.

Each Excel worksheet contains sixteen thousand columns and more than a million rows, so it has space to store huge amounts of data. By using each column to contain a data field (such as a customer's last name) and each row to contain a customer record (with all the customer's data), you can quickly build a straightforward database in which you can store data, sort it, and filter it. Similarly, you can create a database for a home inventory by using the columns to contain the data fields (such as the item, its value, and when you bought it) and the rows to contain the items (with all their details). ...

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