Lisa A. Bucki - Office 2013 Bible

Contents

Microsoft Office 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)

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 affiliates, 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.

To homeless and neglected pets everywhere, in the hope that you will find 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 selfless work that you do.

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 Office 2013 Bible, she wrote Teach Yourself Visually Microsoft Office PowerPoint 2007; Microsoft Office 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 Office 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 spreadsheet 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+ Certified hardware guru, Microsoft Office Specialist Master Instructor, and software consultant with over 120 computer books to her credit. She has taught Microsoft Office 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 Office 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 Certified 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 Office solutions. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community. 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 Office for more than 20. Dick develops Access- and Excel-based solutions for his clients and has conducted training seminars on Office products in the United States and Australia. Dick also writes a popular Excel-related blog at www.dailydoseofexcel.com .

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 first 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 five 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 define their lab strategy as well as operationalize and run the internal eLearning platform. Over the years he has served as the technical editor on numerous books such as the Office 2010 and Office 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 firefighter and EMT.