O'Reilly logo

Learn Office 2011 for Mac OS X 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 16. Creating Simple Databases and Solving Business Problems

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 first to use Excel to create databases for storing information, sorting it, and filtering it to show the information you need. You'll then learn to use Excel's scenarios feature and its Goal Seek tool to solve business problems by performing what-if analysis.

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. For example, if you run a business, ...

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