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, ...
Get Learn Office 2011 for Mac OS X 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.
