MS Press - Microsoft Office Excel 2003 Inside Out, excel - książki
[ Pobierz całość w formacie PDF ]
PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2004 by Craig Stinson and Mark Dodge
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form
or by any means without the written permission of the publisher.
Library of Congress Cataloging-in-Publication Data
Stinson, Craig, 1943-
Microsoft Office Excel 2003 Inside Out / Craig Stinson, Mark Dodge.
p. cm.
Includes index.
ISBN 0-7356-1511-X
1. Microsoft Excel (Computer file) 2. Business--Computer programs. 3. Electronic
spreadsheets. I. Dodge, Mark. II. Title.
HF5548.4.M523S753 2003
005.369--dc21
2003052673
Printed and bound in the United States of America.
1 2 3 4 5 6 7 8 9 QWT 8 7 6 5 4 3
Distributed in Canada by H.B. Fenn and Company Ltd.
A CIP catalogue record for this book is available from the British Library.
Microsoft Press books are available through booksellers and distributors worldwide. For further informa-
tion about international editions, contact your local Microsoft Corporation office or contact Microsoft
Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress.
Send comments to
mspinput@microsoft.com
.
AutoSum, FrontPage, IntelliMouse, Microsoft, Microsoft Press, MS-DOS, PivotChart, PivotTable,
SharePoint, Visual Basic, Windows, and Windows NT are either registered trademarks or trademarks of
Microsoft Corporation in the United States and/or other countries.
Other product and company names
mentioned herein may be the trademarks of their respective owners.
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places,
and events depicted herein are fictitious. No association with any real company, organization, product,
domain name, e-mail address, logo, person, place, or event is intended or should be inferred.
Acquisitions Editor:
Alex Blanton
Project Editor:
Sandra Haynes
Series Editor:
Sandra Haynes
Body Part No. X09-69527
Contents At A Glance
Contents at a Glance
Part 1
Examining the Excel
Environment
Part 4
Adding Graphics
and Printing
Chapter 1
What’s New in Microsoft
Office Excel 2003 . . . . . . . . . . . . . 3
Chapter 10
Creating Spiffy Graphics . . . . . . . 283
Chapter 11
Printing and Presenting . . . . . . . 331
Chapter 2
Excel Fundamentals . . . . . . . . . . .13
Chapter 3
Custom-Tailoring the Excel
Workspace . . . . . . . . . . . . . . . . . .65
Part 5
Creating Formulas and
Performing Data
Analysis
Part 2
Building Worksheets
Chapter 12
Building Formulas. . . . . . . . . . . . 351
Chapter 4
Worksheet Design Tips . . . . . . . . .93
Chapter 13
Using Functions . . . . . . . . . . . . . 401
Chapter 5
How to Work a Worksheet . . . . . .101
Chapter 14
Everyday Functions . . . . . . . . . . 411
Chapter 6
How to Work a Workbook . . . . . .133
Chapter 15
Formatting and Calculating
Date and Time . . . . . . . . . . . . . . 435
Part 3
Formatting and Editing
Worksheets
Chapter 16
Functions for Financial
Analysis . . . . . . . . . . . . . . . . . . . 449
Chapter 7
Worksheet Editing Techniques . . .147
Chapter 17
Functions for Analyzing
Statistics . . . . . . . . . . . . . . . . . . 463
Chapter 8
Worksheet Formatting
Techniques . . . . . . . . . . . . . . . . .195
Chapter 18
Performing What-If Analysis . . . . 493
Chapter 9
Advanced Formatting and
Editing Techniques . . . . . . . . . . .241
iii
Contents At A Glance
Part 6
Collaboration and
the Internet
Part 9
Managing Databases
and Lists
Chapter 19
Collaborating with Excel . . . . . . .521
Chapter 28
Managing Information in Lists . . . 701
Chapter 20
Transferring Files to and
from Internet Sites . . . . . . . . . . .553
Chapter 29
Working with External Data . . . . 757
Part 7
Integrating Excel with
Other Applications
Chapter 30
Analyzing Data with PivotTable
Reports . . . . . . . . . . . . . . . . . . . 797
Part 10
Automating Excel
Chapter 21
Linking and Embedding . . . . . . . .569
Chapter 31
Recording Macros . . . . . . . . . . . 841
Chapter 22
Using Hyperlinks . . . . . . . . . . . . .581
Chapter 32
Creating Custom Functions. . . . . 859
Chapter 23
Using Excel Data in Word
and PowerPoint Documents . . . . .589
Chapter 33
Debugging Macros and
Custom Functions . . . . . . . . . . . 869
Part 8
Creating Charts
Part 11
Appendixes
Chapter 24
Basic Charting Techniques. . . . . .609
Appendix A
Installing Microsoft Excel . . . . . . 883
Chapter 25
Enhancing the Appearance
of Your Charts . . . . . . . . . . . . . . .623
Appendix B
Using Speech and Handwriting
Recognition . . . . . . . . . . . . . . . . 889
Chapter 26
Working with Chart Data . . . . . . .667
Appendix C
Keyboard Shortcuts . . . . . . . . . . 903
Chapter 27
Advanced Charting Techniques . .683
Appendix D
Function Reference . . . . . . . . . . 921
iv
Table of Contents
Table of Contents
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv
We’d Like to Hear from You! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xxvii
About the CD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix
What’s on the CD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix
Using the CD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxx
Support Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxx
Conventions and Features Used in This Book . . . . . . . . . . . . . . . . . . . . . . . . xxxi
Text Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxi
Design Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxi
Part 1
Examining the Excel Environment
Chapter 1
What’s New in Microsoft Office Excel 2003 3
New and Improved for 2003 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Online Assistance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Comparing Worksheets Side by Side . . . . . . . . . . . . . . . . . . . . . . . . . 4
Improved Statistical Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
New Task Panes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Document Workspaces . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
Information Rights Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Improved List Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
If You Missed the Last Upgrade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Onward . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Chapter 2
Excel Fundamentals 13
What Happens After You Install Excel? . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Registering Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Subscribing to Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Recovering from Crashes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Using AutoRecover . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Heroic Measures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Examining the Excel Workspace. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Facts About Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Using the Workbook Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Exploring Menus and Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . . 23
Understanding the Formula Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
About the Status Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
v
[ Pobierz całość w formacie PDF ]