Table Of Content

ffirs.indd ii 31-05-2013 12:59:35 ® Microsoft Office 2013 Bible ffirs.indd i 31-05-2013 12:59:34 ffirs.indd ii 31-05-2013 12:59:35 ® Microsoft Off ce 2013 BIBLE Lisa A. Bucki John Walkenbach Faithe Wempen Michael Alexander Dick Kusleika ffirs.indd iii 31-05-2013 12:59:35 Microsoft® Offi ce 2013 Bible Published by John Wiley & Sons, Inc. 10475 Crosspoint Boulevard Indianapolis, IN 46256 www.wiley.com Copyright © 2013 by John Wiley & Sons, Inc., Indianapolis, Indiana Published simultaneously in Canada ISBN: 978-1-118-48809-6 ISBN: 978-1-118-75046-9 (ebk) ISBN: 978-1-118-76676-7 (ebk) Manufactured in the United States of America 10 9 8 7 6 5 4 3 2 1 No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/ permissions. LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEB SITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ. For general information on our other products and services please contact our Customer Care Department within the United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002. Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com. Library of Congress Control Number: 2013934762 Trademarks: Wiley and the Wiley logo are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affi liates, in the United States and other countries, and may not be used without written permission. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book. ffirs.indd iv 31-05-2013 12:59:35 To homeless and neglected pets everywhere, in the hope that you will fi nd a better life and the loving care that you deserve. And to the many compassionate people involved in animal rescue work, in thanks for the selfl ess work that you do. ffirs.indd v 31-05-2013 12:59:35 ffirs.indd vi 31-05-2013 12:59:36 About the Authors Lisa A. Bucki is an author, trainer, and consultant and has been writing and teaching about computers and software for more than 15 years. Also author of Microsoft Word 2013 Bible and contributing author for two prior editions of Offi ce 2013 Bible, she wrote Teach Yourself Visually Microsoft Offi ce PowerPoint 2007; Microsoft Offi ce Project 2007 Survival Guide; Learning Photoshop CS2; Dell Guide to Digital Photography: Shooting, Editing, and Printing Pictures; Learning Computer Applications: Projects & Exercises (multiple editions); and Adobe Photoshop 7 Fast & Easy. Along with Faithe Wempen, Lisa also co-wrote Windows 8 (brief and expanded editions) for educational publisher Paradigm Publishing. Lisa has written or contributed to dozens of additional books and multimedia tutorials covering a variety of software and technology topics, including FileMaker Pro, iPhoto, Fireworks and Flash from Adobe, Microsoft Offi ce applications, and digital photography. She also spearheaded or developed more than 100 computer and trade titles during her association with the former Macmillan Computer Publishing (now a division of Pearson). John Walkenbach is a bestselling Excel author and has published more than 50 spread- sheet books. He lives amid the saguaros, javelinas, rattlesnakes, bobcats, and gila monsters in Southern Arizona — but the critters are mostly scared away by his clayhammer banjo playing. For more information, Google him. Faithe Wempen, MA, is an A+ Certifi ed hardware guru, Microsoft Offi ce Specialist Master Instructor, and software consultant with over 120 computer books to her credit. She has taught Microsoft Offi ce applications, including PowerPoint, to over a quarter of a million online students for corporate clients, including Hewlett Packard, CNET, Sony, Gateway, and eMachines. When she is not writing, she teaches Microsoft Offi ce classes in the Computer Technology department at Indiana University-Purdue University at Indianapolis (IUPUI), does private computer training and support consulting, and owns and operates Sycamore Knoll Bed and Breakfast in Noblesville, Indiana (www.sycamoreknoll.com). Michael Alexander is a Microsoft Certifi ed Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Microsoft Excel. He has more than 15 years of experience consulting and developing Microsoft Offi ce solutions. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel commu- nity. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares Excel and Access tips. Dick Kusleika has been awarded as a Microsoft MVP for 12 consecutive years and has been working with Microsoft Offi ce for more than 20. Dick develops Access- and Excel-based solutions for his clients and has conducted training seminars on Offi ce products in the United States and Australia. Dick also writes a popular Excel-related blog at www.dailydoseofexcel.com. ffirs.indd vii 31-05-2013 12:59:36 About the Technical Editor Justin Rodino began his technical instructional career working as a guest lecturer while also attending Purdue University as an undergraduate. After graduation, he worked overseas for Tias Business School doing educational design for online delivery, by creating one of the fi rst online eLearning platforms. Later, Justin joined Altiris/Symantec and was one of their lead Microsoft Consultants in the EMEA region where he became an expert in Microsoft Technologies, received his MCSE, and became an MCT. He has been an MCT for the past fi ve years and in that time was also awarded the coveted MVP award two years in a row before joining Microsoft as a Technical Program Manager. In the past three years Justin has worked with Microsoft to help defi ne their lab strategy as well as operationalize and run the inter- nal eLearning platform. Over the years he has served as the technical editor on numerous books such as the Offi ce 2010 and Offi ce 2013 Bibles. As well as editing books, Justin speaks at numerous Microsoft Events, runs Square Baboon, a consulting company specializing in IP Telephony and IT services, and is a volunteer fi refi ghter and EMT. ffirs.indd viii 31-05-2013 12:59:36