Excel 2013: The Missing Manual

The Missing Credits

About the Author

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

About the Creative Team

Peter McKie (editor) graduated from Boston University’s School of Journalism and lives in New York City. In his spare time, he manages the Facebook page and website that chronicle the history of his summer community. Email: [e-mail].

Melanie Yarbrough (production editor) lives and works in Cambridge, MA. When not ushering books through production, she’s sewing, writing, and baking whatever she can think up. Email: [e-mail].

Julie Hawks (indexer) is an indexer for the Missing Manual series. She is currently pursuing a master’s degree in Religious Studies while discovering the joys of warm winters in the Carolinas. Email: [e-mail].

Carla Spoon (proofreader) is a freelance writer and copy editor. An avid runner, she works and feeds her tech gadget addiction from her home office in the shadow of Mount Rainier. Email: [e-mail].

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

Stephanie Dukes (technical reviewer) lives in San Francisco, and works for a software company that supports the global finance industry. When she isn’t crunching numbers and reverse-engineering SQL databases, she spends her time in the El Dorado National Forest skiing, hiking, and kayaking with her partner and dog, or volunteering with her favorite dog rescue, Muttville Senior Dog Rescue (www.Muttville.org) in San Francisco.

Acknowledgments

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 three previous ones. They include Peter McKie, Nellie McKesson, Brian Sawyer, Peter Meyers, Sarah Milstein, and technical reviewers Zack Barresse, and Stephanie Dukes. I also owe thanks to many people who worked to get this book formatted, indexed, and printed—you can meet many of them in the section About the Creative Team, above.

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 and cross-references to specific pages (not just chapters). Recent and upcoming titles include:

• Access 2010: The Missing Manual by Matthew MacDonald

• Access 2013: The Missing Manual by Matthew MacDonald

• Adobe Edge Animate: The Missing Manual by Chris Grover

• Buying a Home: The Missing Manual by Nancy Conner

• Creating a Website: The Missing Manual, Third Edition by Matthew MacDonald

• CSS3: The Missing Manual by David Sawyer McFarland

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

• Dreamweaver CS6: The Missing Manual by David Sawyer McFarland

• Droid 2: The Missing Manual by Preston Gralla

• Droid X2: The Missing Manual by Preston Gralla

• Excel 2010: The Missing Manual by Matthew MacDonald

• Excel 2013: The Missing Manual by Matthew MacDonald

• FileMaker Pro 12: The Missing Manual by Susan Prosser and Stuart Gripman

• Flash CS6: The Missing Manual by Chris Grover

• Galaxy S II: The Missing Manual by Preston Gralla

• Galaxy Tab: The Missing Manual by Preston Gralla

• Google+: The Missing Manual by Kevin Purdy

• HTML5: The Missing Manual by Matthew MacDonald

• iMovie ’11 & iDVD: The Missing Manual by David Pogue and Aaron Miller

• iPad: The Missing Manual, Fifth Edition by J.D. Biersdorfer

• iPhone: The Missing Manual, Fifth Edition by David Pogue

• iPhone App Development: The Missing Manual by Craig Hockenberry

• iPhoto ’11: The Missing Manual by David Pogue and Lesa Snider

• iPod: The Missing Manual, Tenth Edition by J.D. Biersdorfer and David Pogue

• JavaScript & jQuery: The Missing Manual, Second Edition by David Sawyer McFarland

• Kindle Fire HD: The Missing Manual by Peter Meyers

• Living Green: The Missing Manual by Nancy Conner

• Mac OS X Lion: The Missing Manual by David Pogue

• Microsoft Project 2010: The Missing Manual by Bonnie Biafore

• Microsoft Project 2013: The Missing Manual by Bonnie Biafore

• Motorola Xoom: The Missing Manual by Preston Gralla

• Netbooks: The Missing Manual by J.D. Biersdorfer

• NOOK HD: The Missing Manual by Preston Gralla

• Office 2010: The Missing Manual by Nancy Conner and Matthew MacDonald

• Office 2011 for Macintosh: The Missing Manual by Chris Grover

• Office 2013: The Missing Manual by Nancy Conner and Matthew MacDonald

• OS X Mountain Lion: The Missing Manual by David Pogue

• Personal Investing: The Missing Manual by Bonnie Biafore

• Photoshop CS6: The Missing Manual by Lesa Snider

• Photoshop Elements 11: The Missing Manual by Barbara Brundage

• PHP & MySQL: The Missing Manual, Second Edition by Brett McLaughlin

• QuickBooks 2012: The Missing Manual by Bonnie Biafore

• QuickBooks 2013: The Missing Manual by Bonnie Biafore

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

• Switching to the Mac: The Missing Manual, Mountain Lion Edition by David Pogue

• Windows 7: The Missing Manual by David Pogue

• Windows 8: The Missing Manual by David Pogue

• WordPress: The Missing Manual by Matthew MacDonald

• Your Body: The Missing Manual by Matthew MacDonald

• Your Brain: The Missing Manual by Matthew MacDonald

• Your Money: The Missing Manual by J.D. Roth

For a full list of all Missing Manuals in print, go to www.missingmanuals.com/library.html.