Appendix A. Getting Help in Excel

On the one hand, you've got to give it up for Excel's developers, who've beefed up the search tools inside Excel's help system to the point where they're actually pretty good. On the other hand, the information you actually uncover in your search can be vague, confusing, and sometimes painfully obscure programmer-speak.

Overall, the Excel help system isn't, alas, much help when you need to tackle new topics or learn fundamental Excel concepts. But if you just need to look up a list of steps, then you'll be thankful it's fairly easy to find what you need. In fact, many Excel gurus use this approach, referring to magazine articles and books (like this one) to learn the tricks of the trade, relying on the online help system only when they need to fill in the occasional memory gap.

In this appendix, you'll take a quick tour of Excel's help system, and see how you can use it to track down a step-by-step list of instructions for many tasks. You'll also take a quick look at the often-exasperating Office Assistant.

Asking Questions

Excel's help is search-driven. That means, instead of looking at the help like a comprehensive manual, its designers clearly want you to think of it as a giant database of knowledge that you can search in order to extract individual nuggets. While it's possible to view a topic-by-topic listing (see Section A.2 for more on this option), the quickest way to conduct a ...

Get Excel 2003 for Starters: 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.