Excel 2007 for Dummies Quick Reference P1

With Microsoft’s popular Excel 2007 spreadsheet program, you can enter, manipulate,and analyze data in ways that would be impossible, cumbersome, or errorprone for you to do manually. This part gives you the basics you need to get upand running quickly in Excel.
Nội dung trích xuất từ tài liệu:
Excel 2007 for Dummies Quick Reference P1 ® Excel 2007 FOR DUMmIES ‰ QUICK REFERENCEby John Walkenbach and Colin BanfieldExcel® 2007 For Dummies® Quick ReferencePublished byWiley Publishing, Inc.111 River StreetHoboken, NJ 07030-5774www.wiley.comCopyright © 2007 by Wiley Publishing, Inc., Indianapolis, IndianaPublished by Wiley Publishing, Inc., Indianapolis, IndianaPublished simultaneously in CanadaNo 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 ofthe 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization throughpayment 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 Legal Department, WileyPublishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at http://www.wiley.com/go/permissions.Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, TheDummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade dress are trademarks or registeredtrademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be usedwithout written permission. Excel is a registered trademark of Microsoft Corporation in the United States and/or othercountries. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated withany product or vendor mentioned in this book.LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONSOR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK ANDSPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR APARTICULAR 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 ISSOLD 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 COMPE-TENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLEFOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THISWORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THEAUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE ORRECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED INTHIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT ISREAD.For general information on our other products and services, please contact our Customer Care Department within the U.S.at 800-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.For technical support, please visit www.wiley.com/techsupport.Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available inelectronic books.Library of Congress Control Number: 2006934839ISBN-13: 978-0-470-04671-5ISBN-10: 0-470-04671-6Manufactured in the United States of America10 9 8 7 6 5 4 3 2 11O/RT/RS/QW/INAbout the Authors John Walkenbach is a leading authority on spreadsheet software and is principal of JWalk and Associates Inc., a small San Diego–based consulting firm that specializes in spreadsheet application development. He is the author of approximately three dozen spreadsheet books and has written hundreds of articles and reviews for a variety of publications, including PC World, InfoWorld, Windows magazine, and PC/Computing. John graduated from the University of Missouri and earned a master’s and a PhD from the University of Montana. Visit his Web site at www.j-walk.com. Colin Banfield has been working in the telecommunications field for more than twenty-five years and has been using spreadsheet programs for more than two decades. Colin’s largest Excel project to date is a comprehensive tool that is designed for telephone central office equipment configuration, pricing, and manufac- turing and used by sales, engineering, and manufacturing personnel. In between his telecom consulting duties, Colin works with organizations to extract information from corporate databases for business intelligence reporting in Excel. In his spare time, Colin writes and reviews books for Wiley and enjoys photography, astronomy, and expanding his musical repertoire. Colin holds a BSc (Honors) in Electrical Engineering from the University of the West Indies and has received extensive training in many advanced technologies.Dedication To Dorothy, my most loving and patient better half, and one of the nicest people on the planet. —C. B.Author’s Acknowledgments Thanks to the folks at Wiley who helped with the update of this book. In particular, my project editor, Susan Pink (Pinkie to me), did her usual wonderful editing and coordinating job and kept me on my toes. I’m indebted to Allen Wyatt, who provided a thorough technical review and made some very good suggestions for improve- ment. Finally, I’d like to thank David Gainer, Lead Program Manager for Excel at Microsoft, and his staff for clarifying some issues and for delivering this amazing update to a superb piece of software. — ...