Excel 2010- Visual Quick Tips.pdf

(25379 KB) Pobierz
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
Microsoft ®
Excel ® 2010
Paul McFedries
843556705.156.png
 
 
 
843556705.001.png 843556705.003.png
 
843556705.009.png 843556705.020.png 843556705.030.png 843556705.041.png 843556705.051.png 843556705.062.png 843556705.073.png 843556705.083.png 843556705.094.png 843556705.105.png 843556705.116.png 843556705.126.png 843556705.137.png 843556705.143.png 843556705.144.png 843556705.145.png 843556705.146.png 843556705.147.png 843556705.148.png
 
 
 
 
 
 
843556705.149.png
 
 
 
 
843556705.150.png
 
 
 
 
 
 
 
 
 
 
843556705.151.png
 
843556705.152.png 843556705.153.png 843556705.154.png 843556705.155.png 843556705.157.png 843556705.158.png 843556705.159.png 843556705.160.png 843556705.161.png 843556705.162.png 843556705.163.png 843556705.164.png 843556705.165.png 843556705.166.png 843556705.167.png 843556705.168.png 843556705.169.png
 
843556705.170.png 843556705.171.png
 
 
 
 
843556705.172.png
 
 
 
 
 
 
 
843556705.173.png
 
 
 
 
 
843556705.174.png
 
 
843556705.175.png
 
 
 
 
843556705.002.png
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
843556705.004.png
 
 
 
 
843556705.005.png 843556705.006.png 843556705.007.png 843556705.008.png 843556705.010.png 843556705.011.png 843556705.012.png 843556705.013.png 843556705.014.png 843556705.015.png 843556705.016.png 843556705.017.png 843556705.018.png 843556705.019.png 843556705.021.png 843556705.022.png 843556705.023.png 843556705.024.png 843556705.025.png 843556705.026.png 843556705.027.png 843556705.028.png
 
843556705.029.png 843556705.031.png 843556705.032.png 843556705.033.png 843556705.034.png 843556705.035.png 843556705.036.png 843556705.037.png 843556705.038.png 843556705.039.png 843556705.040.png 843556705.042.png 843556705.043.png 843556705.044.png 843556705.045.png
 
Excel ® 2010
by Paul McFedries
843556705.046.png 843556705.047.png 843556705.048.png 843556705.049.png 843556705.050.png 843556705.052.png 843556705.053.png 843556705.054.png 843556705.055.png 843556705.056.png 843556705.057.png 843556705.058.png 843556705.059.png 843556705.060.png 843556705.061.png 843556705.063.png 843556705.064.png 843556705.065.png 843556705.066.png 843556705.067.png 843556705.068.png 843556705.069.png 843556705.070.png 843556705.071.png 843556705.072.png 843556705.074.png 843556705.075.png 843556705.076.png 843556705.077.png 843556705.078.png 843556705.079.png 843556705.080.png 843556705.081.png
 
Excel ® 2010 Visual™ Quick Tips
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Published simultaneously in Canada
Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana
Library of Congress Control Number: 2010923565
ISBN: 978-0-470-57776-9
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 www.wiley.com/go/permissions.
Trademarks Acknowledgments
Wiley, the Wiley Publishing logo, Visual, the Visual logo, Read
Less - Learn More, and related trade dress are registered
trademarks of Wiley Publishing, Inc., 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.
Contact Us
For general information on our other products and services or to
obtain technical support, 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.
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 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 PURPOSES OF ILLUSTRATING THE CONCEPTS AND TECHNIQUES
DESCRIBED IN THIS BOOK, THE AUTHOR HAS CREATED VARIOUS
NAMES, COMPANY NAMES, MAILING, E-MAIL, AND INTERNET
ADDRESSES, PHONE AND FAX NUMBERS, AND SIMILAR
INFORMATION, ALL OF WHICH ARE FICTITIOUS. ANY RESEMBLANCE
OF THE FICTITIOUS NAMES, ADDRESSES, PHONE AND FAX NUMBERS,
AND SIMILAR INFORMATION TO ANY ACTUAL PERSON, COMPANY
AND/OR ORGANIZATION IS UNINTENTIONAL AND PURELY
COINCIDENTAL.
Disclaimer
In order to get this information to you in a timely manner, this
book was based on a pre-release version of Microsoft Office 2010.
There may be some minor changes between the screenshots in
this book and what you see on your desktop. As always, Microsoft
has the final word on how programs look and function; if you have
any questions or see any discrepancies, consult the online help for
further information about the software.
Sales
Contact Wiley
at (877) 762-2974 or
fax (317) 572-4002.
843556705.082.png 843556705.084.png 843556705.085.png 843556705.086.png 843556705.087.png 843556705.088.png 843556705.089.png 843556705.090.png 843556705.091.png 843556705.092.png 843556705.093.png 843556705.095.png 843556705.096.png 843556705.097.png 843556705.098.png 843556705.099.png 843556705.100.png 843556705.101.png 843556705.102.png 843556705.103.png 843556705.104.png 843556705.106.png 843556705.107.png 843556705.108.png 843556705.109.png 843556705.110.png 843556705.111.png 843556705.112.png 843556705.113.png 843556705.114.png 843556705.115.png 843556705.117.png 843556705.118.png 843556705.119.png 843556705.120.png 843556705.121.png
 
Credits
Executive Editor
Jody Lefevere
Project Editor
Kristin DeMint
Technical Editor
Namir Shammas
Copy Editor
Marylouise Wiack
Editorial Director
Robyn Siesky
Business Manager
Amy Knies
Senior Marketing
Manager
Sandy Smith
Vice President and
Executive Group
Publisher
Richard Swadley
Vice President and
Executive Publisher
Barry Pruett
Project Coordinator
Lynsey Stanford
Graphics and
Production Specialists
Carrie A. Cesavice
Quality Control
Technician
Lauren Mandelbaum
Proofreading and
Indexing
Cindy Lee Ballew /
Precisely Write
Johnna VanHoose
Dinse
Screen Artist
Joyce Haughey
About the Author
Paul McFedries is a full-time technical writer. Paul has been authoring
computer books since 1991 and he has more than 70 books to his credit.
Paul’s books have sold more than three million copies worldwide. These
books include the Wiley titles Teach Yourself VISUALLY Excel 2010; Excel
PivotTables and PivotCharts Visual Blueprint, Second Edition; Teach Yourself
VISUALLY Windows 7; and Teach Yourself VISUALLY Office 2008 for Mac .
Paul is also the proprietor of Word Spy (www.wordspy.com and twitter.
com/wordspy), a Web site that tracks new words and phrases as they
enter the language. Paul invites you to drop by his personal Web site at
www.mcfedries.com or to follow him on Twitter at twitter.com/paulmcf.
Author’s Acknowledgments
It goes without saying that writers focus on text, and I certainly enjoyed
focusing on the text that you’ll read in this book. However, this book is more
than just the usual collection of words and phrases. A quick thumb-through of
the pages will show you that this book is also chock full of images, from sharp
screen shots to fun and informative illustrations. Those colorful images sure
make for a beautiful book, and that beauty comes from a lot of hard work by
Wiley’s immensely talented group of designers and layout artists. They are all
listed in the Credits section above, and I thank them for creating another gem.
Of course, what you read in this book must also be accurate, logically
presented, and free of errors. Ensuring all of this was an excellent group of
editors that included project editor Kristin DeMint, copy editor Marylouise
Wiack, and technical editor Namir Shammas. Thanks to all of you for your
exceptional competence and hard work. Thanks, as well, to acquisitions editor
Jody Lefevere for asking me to write this book.
843556705.122.png 843556705.123.png 843556705.124.png 843556705.125.png 843556705.127.png 843556705.128.png 843556705.129.png 843556705.130.png 843556705.131.png 843556705.132.png 843556705.133.png 843556705.134.png 843556705.135.png 843556705.136.png 843556705.138.png 843556705.139.png 843556705.140.png 843556705.141.png 843556705.142.png
 
Zgłoś jeśli naruszono regulamin