O'Reilly logo

Learn Office 2016 for Mac, 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

© Guy Hart-Davis 2016

Guy Hart-Davis, Learn Office 2016 for Mac, 10.1007/978-1-4842-2002-3_16

16. Creating Simple Databases and Solving Business Problems

Guy Hart-Davis

(1)Barnard Castle, Durham, UK

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

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