Microsoft Office Excel 2003 Inside Out - Stinson_ Craig.pdf - Microsoft Office Excel 2003 Inside Out (419) - superktos86

PUBLISHED BY

Microsoft Press

A Division of Microsoft Corporation

One Microsoft Way

Redmond, Washington 98052-6399

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

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

Microsoft Office Excel 2003 Inside Out - Stinson_ Craig.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: