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