Chapter 14. Formula and Database Magic

Congratulations, you’ve mastered enough of Excel to input numbers, perform calculations, create charts and graphs, and log your DVD collection using the List Manager. In fact—you already have far more spreadsheet ability than most people.

If, on the other hand, you’re the kind of person who uses Excel for more than a list maker, whose business depends on the flow of numbers, calculations, and projections, there’s still more to learn. This chapter covers the eerie realms of power Excel, where several people can work on the same spreadsheet simultaneously over the network, files can connect to databases or even the Web for their information, and you can program Excel to function by itself.

Get Office 2008 for Macintosh: The Missing Manual 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.