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

Summary

In the first half of this chapter, you learned how to create a flat-file database in an Excel worksheet, enter data in it either directly or by using a data-entry form, and how to format the database to look the way you want. You also learned to sort and filter the data in the database.

In the second half of the chapter, you learned to use Excel to solve business problems. You now know how to use Excel's scenarios to enter different sets of values in a worksheet and switch quickly among the sets, and you can use the Goal Seek feature to work backward from the desired result of a calculation to derive a value required to produce that result.

This is the end of the part of the book that covers Excel. In the next chapter, we'll get started ...

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