The Missing Credits

About the Author

Matthew MacDonald (author) is a science and technology writer with well over a dozen books to his name. Office geeks can follow him into the word of databases with Access 2010: The Missing Manual. Web fans can build an online home with him in Creating a Web Site: The Missing Manual. And human beings of all description can discover just how strange they really are in Your Brain: The Missing Manual and Your Body: The Missing Manual.

About the Creative Team

Brian Sawyer (editor) is an editor for O’Reilly Media’s Head First division. He’s also served as lead editor for the company’s popular Hacks series, editor for Missing Manuals and Make: Books, and contributing editor to Craft magazine. When not writing or editing about technology, he uses it to help train for marathons (see Chapter 4 of Best Android Apps).

Nellie McKesson (production editor) is a graduate of St. John’s College in Santa Fe, New Mexico. She lives in Brockton, Mass., and spends her spare time studying graphic design and making t-shirts (www.endplasticdesigns.com). Email: .

Alison O’Byrne (copyeditor) is a full-time freelance editor with over eight years’ experience specializing in corporate and government projects for international clients. She lives with her family in Dublin, Ireland. Email: . Web: www.alhaus.com.

Zack Barresse (technical reviewer) is a Microsoft Excel MVP and has held that title for six consecutive years. He works as a full-time fire fighter in his hometown of Boardman, Oregon, where he resides with his wife and four children.

Rhea Howard (technical reviewer) is an Operations Analyst at O’Reilly Media. She lives with her partner in Berkeley, CA.

Acknowledgements

Writing a book about a program as sprawling and complex as Excel is a labor of love (love of pain, that is). I’m deeply indebted to a whole host of people who helped out with this edition and the two previous ones. They include Nellie McKesson, Brian Sawyer, Peter Meyers, Sarah Milstein, and technical reviewers Zack Barresse and Rhea Howard. I also owe thanks to many people who worked to get this book formatted, indexed, and printed—you can meet many of them on the Missing Credits page.

Completing this book required a few sleepless nights (and many sleep-deprived days). I extend my love and thanks to my daughters Maya and Brenna, who put up with it without crying most of the time, my dear wife Faria, who mostly did the same, and our moms and dads (Nora, Razia, Paul, and Hamid), who contributed hours of babysitting, tasty meals, and general help around the house that kept this book on track. So thanks everyone—without you half of the book would still be trapped inside my brain!

Matthew MacDonald

The Missing Manual Series

Missing Manuals are witty, superbly written guides to computer products that don’t come with printed manuals (which is just about all of them). Each book features a handcrafted index; cross-references to specific page numbers (not just “see Chapter 14”); and RepKover, a detached-spine binding that lets the book lie perfectly flat without the assistance of weights or cinder blocks.

Recent and upcoming titles include:

Access 2007: The Missing Manual by Matthew MacDonald

AppleScript: The Missing Manual by Adam Goldstein

AppleWorks 6: The Missing Manual by Jim Elferdink and David Reynolds

CSS: The Missing Manual by David Sawyer McFarland

Creating Web Sites: The Missing Manual by Matthew MacDonald

David Pogue’s Digital Photography: The Missing Manual by David Pogue

Dreamweaver 8: The Missing Manual by David Sawyer McFarland

Dreamweaver CS3: The Missing Manual by David Sawyer McFarland

Dreamweaver CS4: The Missing Manual by David Sawyer McFarland

eBay: The Missing Manual by Nancy Conner

Excel 2003: The Missing Manual by Matthew MacDonald

Excel 2007: The Missing Manual by Matthew MacDonald

Facebook: The Missing Manual by E.A. Vander Veer

FileMaker Pro 8: The Missing Manual by Geoff Coffey and Susan Prosser

FileMaker Pro 9: The Missing Manual by Geoff Coffey and Susan Prosser

Flash 8: The Missing Manual by E.A. Vander Veer

Flash CS3: The Missing Manual by E.A. Vander Veer and Chris Grover

Flash CS4: The Missing Manual by Chris Grover with E.A. Vander Veer

FrontPage 2003: The Missing Manual by Jessica Mantaro

Google Apps: The Missing Manual by Nancy Conner

Google SketchUp: The Missing Manual by Chris Grover

The Internet: The Missing Manual by David Pogue and J.D. Biersdorfer

iMovie 6 & iDVD: The Missing Manual by David Pogue

iMovie ’08 & iDVD: The Missing Manual by David Pogue

iPhone: The Missing Manual by David Pogue

iPhoto ’08: The Missing Manual by David Pogue

iPhoto ’09: The Missing Manual by David Pogue and J.D. Biersdorfer

iPod: The Missing Manual, 6th Edition by J.D. Biersdorfer

iWork ’09: The Missing Manual by Josh Clark

JavaScript: The Missing Manual by David Sawyer McFarland

Living Green: The Missing Manual by Nancy Conner

Mac OS X: The Missing Manual, Tiger Edition by David Pogue

Mac OS X: The Missing Manual, Leopard Edition by David Pogue

Microsoft Project 2007: The Missing Manual by Bonnie Biafore

Netbooks: The Missing Manual by J.D. Biersdorfer

Office 2004 for Macintosh: The Missing Manual by Mark H. Walkerand Franklin Tessler

Office 2007: The Missing Manual by Chris Grover, Matthew MacDonald,and E.A. Vander Veer

Office 2008 for Macintosh: The Missing Manual by Jim Elferdink

PCs: The Missing Manual by Andy Rathbone

Photoshop CS4: The Missing Manual by Lesa Snider

Photoshop Elements 7: The Missing Manual by Barbara Brundage

Photoshop Elements 6 for Mac: The Missing Manual by Barbara Brundage

PowerPoint 2007: The Missing Manual by E.A. Vander Veer

QuickBase: The Missing Manual by Nancy Conner

QuickBooks 2008: The Missing Manual by Bonnie Biafore

Quicken 2008: The Missing Manual by Bonnie Biafore

Quicken 2009: The Missing Manual by Bonnie Biafore

QuickBooks 2009: The Missing Manual by Bonnie Biafore

Switching to the Mac: The Missing Manual, Tiger Edition by David Pogue and Adam Goldstein

Switching to the Mac: The Missing Manual, Leopard Edition by David Pogue

Wikipedia: The Missing Manual by John Broughton

Windows XP Home Edition: The Missing Manual, Second Edition by David Pogue

Windows XP Pro: The Missing Manual, Second Edition by David Pogue,Craig Zacker, and Linda Zacker

Windows Vista: The Missing Manual by David Pogue

Windows Vista for Starters: The Missing Manual by David Pogue

Word 2007: The Missing Manual by Chris Grover

Your Body: The Missing Manual by Matthew MacDonald

Your Brain: The Missing Manual by Matthew MacDonald

Get Excel 2010: 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.