Excel 2010 for Dummies Quick Reference (ISBN - 0470527552).pdf - For Dummies E-Book Collection - sebaw83

M a k i n g E ve r y t h i n g E a s i e r !

M i c r o s o f t

Learn to:

Navigate the new interface

Use the Ribbon and Quick Access toolbar

Create formulas and functions

Save, protect, and recover

workbook files

Colin Banfield

John Walkenbach

Welcome to Excel 2010 For Dummies Quick Reference! Keep this book within

arm’s reach of your computer to find quick answers.

If you’re new to Excel, take a look at Part 1, which gives you an overview of

Excel and introduces terms that are used throughout the book. Part 1 is also

important if you already know Excel but are new to Excel 2010.

Remember: If you’re having trouble finding a particular topic, check out the

table of contents or the index. For topics not covered, we encourage you to

use Excel’s Help feature.

As you use this book, you’ll come across the following icons:

This icon indicates a feature that is available only in Excel

2010.

This icon flags the quickest way to complete a task.

This icon shows a way of using a feature that may not be

obvious to the average user.

This icon flags problem areas that can mess up your work if

you’re not careful.

Excel ® 2010

FOR

DUMmIES ‰

QUICK REFERENCE

by Colin Banfield and John Walkenbach

Excel ® 2010 For Dummies ® Quick Reference

Published by

Wiley Publishing, Inc.

111 River Street

Hoboken, NJ 07030-5774

www.wiley.com

Published by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

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.

Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The

Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress

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. Excel is a registered trademark of Microsoft Corporation in the

United States and/or other countries. All other trademarks are the property of their respective owners. Wiley Publishing,

Inc., is not associated with any product or vendor mentioned in this book.

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 MATERI-

ALS. 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 WEBSITE 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 U.S.

at 877-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 in

electronic books.

Library of Congress Control Number: 2010923562

ISBN: 978-0-470-52755-9

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

About the Authors

Colin Banfield has worked in the telecommunications field and has been using

spreadsheet programs for more than two decades. Colin works with organizations

to build business intelligence models, dashboards, and complex adjunct tools

using a combination of Excel, Microsoft Access, and other related Microsoft

software. 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. You can

reach Colin at www.biexcel.com.

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.

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 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 (not to mention on time). Pinkie has

a keen eye for even the smallest details. I’m indebted to Mike Talley, who

provided a thorough technical review, spotted important errors, and made

some useful suggestions. —C. B.

Excel 2010 for Dummies Quick Reference (ISBN - 0470527552).pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: