About This Book
Despite the many improvements in software over the years , one feature hasn't improved a bit: Microsoft's documentation. In fact, with Office 2003, you get no printed user guide at all. To learn about the thousands of features included in this software collection, Microsoft expects you to read the online help.
Occasionally, these screens are actually helpful, like when you're looking for a quick description explaining a mysterious new function. On the other hand, if you're trying to learn how to, say, create an attractive chart, you'll find nothing better than terse and occasionally cryptic instructions.
The purpose of this book, then, is to serve as the manual that should have accompanied Excel 2003 and Excel 2002. In these pages, you'll find step-by-step instructions and tips for using almost every Excel feature, including those you may not even be aware of.
This book is divided into eight parts , each containing several chapters.
Part 1, Worksheet Basics . In this part, you'll get acquainted with Excel's interface and learn the basic techniques for creating spreadsheets and entering and organizing data. You'll also learn how to format your work to make it more presentable and how to create slick printouts.
Part 2, Formulas and Functions . This part introduces you to Excel's most important featureformulas. You'll learn how to perform calculations ranging from the simple to the complex, and you'll tackle specialized functions for dealing with all kinds of information, including scientific, statistical, business, and financial data.
Part 3, Organizing Worksheets . The third part covers how to organize and find what's in your spreadsheet. First, you'll learn to search, sort , and filter large amounts of information by using data lists. Next, you'll see how to boil down complex tables with grouping and outlining. Finally, you'll turn your perfected spreadsheets into reusable templates.
Part 4, Charts and Graphics . The fourth part introduces you to charting and graphics, two of Excel's most popular features. You'll learn about the wide range of different chart types available and when each one makes sense to use. You'll also find out how you can add a little pizzazz to your spreadsheets with pictures.
Part 5, Advanced Data Analysis . In this short part, you'll tackle some of the more advanced features that people often overlook or misunderstand. You'll see how to study different possibilities with scenarios, use goal seeking and the Solver add-in to calculate "backward" and fill in missing numbers , and create multi-layered summary reports with pivot tables.
Part 6, Sharing Data with the Rest of the World . The sixth part explores ways that you can integrate Excel with other applications, such as Access and Word. You'll learn how to extract information from a database and put it in Excel, convert worksheets into Web pages, and collaborate with other people to revise a spreadsheet.
Part 7, Programming Excel . The last part presents a gentle introduction to the world of Excel programming, first with macros and then with the full-featured VBA (Visual Basic for Applications) language, which lets you automate complex tasks .
Part 8, Appendixes . At the end of this book, you'll find three appendices. The first helps you use Excel's sometimes useful but often infuriating online help. The second shows you how to customize Excel's menus and toolbars . And the third gives you a menu-by-menu guide to Excel.
Throughout this book, you'll find sentences like this one: " Open My Computer C: Windows folder." That's shorthand for a much longer instruction that directs you to open three nested folders in sequence, like this: "On your hard drive, there's an icon called My Computer. Open that. Inside My Computer, there's a folder for your C: drive. Open that. Inside your C: drive is your Windows folder. Open that."
Similarly, this kind of arrow shorthand helps to simplify the business of choosing commands in menus, such as File New Window, as shown in Figure P-3. You'll also see this arrow notation used to indicate which tab or pane of a dialog box you're supposed to click: "Choose Tools Options General," for example.
You'll find very little jargon or nerd terminology in this book. You will, however, encounter a couple of terms that you'll see frequently in your computing life:
Clicking . This book gives you three kinds of instructions that require you to use your computer's mouse or trackpad. To click means to point the arrow cursor at something on the screen and thenwithout moving the cursor at allpress and release the clicker button on the mouse (or laptop trackpad). To double-click , of course, means to click twice in rapid succession, again without moving the cursor at all. And to drag means to move the cursor while pressing the button continuously.
Keyboard shortcuts . Every time you take your hand off the keyboard to move the mouse, you lose time. That's why many experienced computer fans use keystroke combinations instead of menu commands wherever possible. Ctrl+B, for example, is a keyboard shortcut for boldface type in Excel (and most other programs).
When you see a shortcut like Ctrl+S (which saves changes to the current document), it's telling you to hold down the Ctrl key, and, while it's down, type the letter S, and then release both keys.
As you read this book, you'll see a number of examples that demonstrate Excel features and techniques for building good spreadsheets. Many of these examples are available as Excel workbook files in a separate download. Just surf to www.missingmanuals.com, and click the link for this book to visit a page where you can download a zip file that includes the examples, organized by chapter.
At www.missingmanuals.com, you'll find news, articles, and updates to the books in the Missing Manual and Power Hound series.
But the Web site also offers corrections and updates to this book (to see them, click the book's title, then click Errata). In fact, you're invited and encouraged to submit such corrections and updates yourself. In an effort to keep the book as up-to- date and accurate as possible, each time we print more copies of this book, we'll make any confirmed corrections you've suggested. We'll also note such changes on the Web site, so that you can mark important corrections into your own copy of the book.
In the meantime, we'd love to hear your own suggestions for new books in the Missing Manual and Power Hound lines. There's a place for that on the Web site, too, as well as a place to sign up for free email notification of new titles in the series.