Excel 2010 Made Simple
Copyright 2011 by Abbott Katz
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-4302-3545-3
ISBN-13 (electronic): 978-1-4302-3546-0
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.
President and Publisher: Paul Manning
Lead Editor: Steve Anglin
Development Editor: Matthew Moodie
Technical Reviewer: Greg Kettell
Editorial Board: Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan
Gennick, Jonathan Hassell, Michelle Lowman, James Markham, Matthew Moodie,
Jeff Olson, Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke,
Dominic Shakeshaft, Matt Wade, Tom Welsh
Coordinating Editor: Kelly Moritz
Copy Editor: Damon Larson
Compositor: MacPS, LLC
Indexer: John Collin
Artist: April Milne
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media, LLC, 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail .
For information on translations, please e-mail .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Special Bulk SaleseBook Licensing web page at www.apress.com/bulk-sales
.
The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.
Contents at a Glance
Contents
About the Author
A New Yorker living in London, Abbott Katz has introduced Excel to thousands of students in both university and corporate settings. The author of Beginning Microsoft Excel 2010 (Apress), he has a doctorate in sociology and has contributed to numerous publications on a range of topics.
About the Technical Reviewer
Greg Kettell is a professional software engineer with a diverse career that has covered everything from game programming to enterprise business applications. He has written and contributed to several books about software applications, operating systems, web design, and programming. Greg, his wife Jennifer, and their two children currently reside in upstate New York.
Acknowledgments
The Made Simple series sports two sets of authors: the ones whose names make it to the books' covers, and the ones whose labors earn their appreciations in sections such as these.
Thus, many thanks go to an international coterie of helpers, including development editor Matthew Moodie for his spot-on tweaks and knowing recommendations, coordinating editor Kelly Moritz for her redoubtable coordination of the publication process, technical editor Greg Kettell for his sage commentaries, and what is doubtless a set of literally silent partnersthe able players on Apress's production team. And thanks to Dominic Shakeshaftfor encouraging this project's inception. A Made Simple book isn't so simple.
An here's an additional and special thanks to my wife, Marsha, for affording me the space to ply the time that might have been otherwise spent on less literary chores. Constructing spreadsheets is one of the few things I do better than her.
Quick Start Guide
Believe it or not, you're looking at a book about one of the most widely ownedbut underusedprograms on the planet: Microsoft Excel, the 2010 edition. Underused? Yep, because even though millions of people around the globe apply Excel to a vast range of daily tasks, most users still don't appreciate the even wider range of things Excel can doonce they nail down its basics and begin to glimpse the huge potential that lurks behind all those cells and buttons.
What makes Excel is interesting, and even exciting, is that once you learn those basics you can start to