Excel 2013 on Demand
Steve Johnson
Perspection, inc.
Que Publishing,
800 East 96th street, Indianapolis, IN 46240 USA
Excel 2013 on Demand
Copyright 2013 by Perspection, Inc.
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
Library of Congress Cataloging-in-Publication Data is on file
ISBN-13: 978-0-7897-5048-8
ISBN-10: 0-7897-5048-1
Printed and bound in the United States of America
First Printing: February 2013
16 15 14 13 4 3 2 1
Que Publishing offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales.
For information, please contact: U.S. Corporate and Government Sales
1-800-382-3419 or
For sales outside the U.S., please contact: International Sales
1-317-428-3341 or
Publisher
Paul Boger
Associate Publisher
Greg Wiegand
Executive Editor
Loretta Yates
Managing Editor
Steve Johnson
Author
Steve Johnson
Page Layout
James Teyler
Interior Designers
Steve Johnson
Marian Hartsough
Photographs
Tracy Teyler
Indexer
Katherine Stimson
Proofreader
Beth Teyler
Team Coordinator
Cindy Teeters
Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.
Microsoft and the Microsoft Office logo are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The authors and the publishers shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.
Acknowledgments
Perspection, Inc.
Excel 2013 on Demand has been created by the professional trainers and writers at Perspection, Inc. to the standards youve come to expect from Que publishing. Together, we are pleased to present this training book.
Perspection, Inc. is a software training company committed to providing information and training to help people use software more effectively in order to communicate, make decisions, and solve problems. Perspection writes and produces software training books, and develops multimedia and web-based training. Since 1991, we have written more than 130 computer books, with several bestsellers to our credit, and sold over 5 million books.
This book incorporates Perspections training expertise to ensure that youll receive the maximum return on your time. Youll focus on the tasks and skills that increase productivity while working at your own pace and convenience.
We invite you to visit the Perspection web site at:
www.perspection.com
Acknowledgments
The task of creating any book requires the talents of many hard-working people pulling together to meet impossible deadlines and untold stresses. Wed like to thank the outstanding team responsible for making this book possible: the writer, Steve Johnson; the production editor, James Teyler; the editor and proofreader, Beth Teyler; and the indexer, Katherine Stimson.
At Que publishing, wed like to thank Greg Wiegand and Loretta Yates for the opportunity to undertake this project, Cindy Teeters for administrative support, and Lori Lyons for your production expertise and support.
Perspection
About the Author
Steve Johnson has written more than 80 books on a variety of computer software, including Adobe Edge Animate, Adobe Photoshop CS6, Adobe Dreamweaver CS6, Adobe InDesign CS6, Adobe Illustrator CS6, Adobe Flash Professional CS5, Microsoft Windows 8, Microsoft Office 2013 and 2010, Microsoft Office 2008 for the Macintosh, and Apple OS X Mountain Lion. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc., which writes and produces software training. When he is not staying up late writing, he enjoys coaching baseball, playing golf, gardening, and spending time with his wife, Holly, and three children, JP, Brett, and Hannah. Steve and his family live in Northern California, but can also be found visiting family all over the western United States.
We Want to Hear from You!
As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what were doing right, what we could do better, what areas youd like to see us publish in, and any other words of wisdom youre willing to pass our way.
As an associate publisher for Que, I welcome your comments. You can email or write me directly to let me know what you did or didnt like about this bookas well as what we can do to make our books better.
Please note that I cannot help you with technical problems related to the topic of this book. We do have a User Services group, however, where I will forward specific technical questions related to the book.
When you write, please be sure to include this books title and author as well as your name, email address, and phone number. I will carefully review your comments and share them with the author and editors who worked on the book.
Email:
Mail: Greg Wiegand
Que Publishing
800 East 96th Street
Indianapolis, IN 46240 USA
For more information about this book or another Que title, visit our web site at www.quepublishing.com. Type the ISBN (excluding hyphens) or the title of a book in the Search field to find the page youre looking for.
Introduction
Welcome to Excel 2013 on Demand, a visual quick reference book that shows you how to work efficiently with Microsoft Excel. This book provides complete coverage of basic to advanced Excel skills.
How This Book Works
You dont have to read this book in any particular order. Weve designed the book so that you can jump in, get the information you need, and jump out. However, the book does follow a logical progression from simple tasks to more complex ones. Each task is presented on no more than two facing pages, which lets you focus on a single task without having to turn the page. To find the information that you need, just look up the task in the table of contents or index, and turn to the page listed. Read the task introduction, follow the step-by-step instructions in the left column along with screen illustrations in the right column, and youre done.