Running Microsoft� Excel 2000 - Brossura

Mark Dodge And Craig Stinson

9781572319356: Running Microsoft� Excel 2000

Brossura

ISBN 10: 1572319356 ISBN 13: 9781572319356

Casa editrice: MICROSOFT PRESS, 1999

RUNNING MICROSOFT EXCEL 2000 takes you through the most used tasks and functions of Microsoft’s popular spreadsheet program. Whether you need quick, how-to instructions or in-depth answers to more advanced questions, this one-stop reference has the answers you need to work more productively—every day—with Excel. Comprehensive � Get new information on topics ranging from creating and managing worksheets and incorporating external data to using pivot tables and working with VBA—plus much more � Learn to create Web pages with Excel 2000 � Discover how to collaborate with others almost anywhere using Microsoft Excel, workgroups, and the Internet � Gain insight into using Microsoft Excel 2000 as a component within Microsoft Office 2000 Easy Access to Information � “Chapters at a Glance” for quick reference � Master table of contents � Extensive cross-referenced index � Two-color interior for easier navigation Everything Is Clear � Step-by-step instructions � Hundreds of screen illustrations � Real-world examples � Tips and advice from the experts

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

L'autore:

Mark Dodge has coauthored several popular books on Excel�, including Microsoft� Office Excel� 2003 Inside Out. He is a former senior technical writer for the Microsoft� Office User Assistance group.

Craig Stinson is a journalist and author. He has written or coauthored more than 20 books including Windows Vista� Inside Out, Deluxe Edition and Microsoft� Office Excel� 2007 Inside Out.

Contenuti:

Chapters at a Glance

Acknowledgments xxiv

Part I Getting Started with Microsoft Excel 2000 1

Chapter 1 Getting Your Bearings 3

Chapter 2 Getting Help 23

Chapter 3 Toolbars and Menus 37

Chapter 4 Managing Files 61

Part II Worksheets 91

Chapter 5 Worksheet Basics 93

Chapter 6 Building Formulas 115

Chapter 7 Formatting a Worksheet 155

Chapter 8 Editing a Worksheet 233

Chapter 9 Worksheets and Windows 299

Chapter 10 Graphics 345

Chapter 11 Printing and Presenting 389

Part III Analyzing Data 409

Chapter 12 Common Worksheet Functions 411

Chapter 13 Dates and Times 459

Chapter 14 Financial Analysis 479

Chapter 15 Statistical Analysis 501

Chapter 16 What-If Analysis 535

Part IV Interfacing with the Rest of the World 571

Chapter 17 Integrating Applications with OLE 573

Chapter 18 Sharing Files with Others 583

Chapter 19 Hyperlinks and the Internet 603

Chapter 20 Creating Web Pages with Excel 629

Part V Charts 649

Chapter 21 Basic Charting Techniques 651

Chapter 22 Changing the Appearance of Your Charts 667

Chapter 23 Working with Chart Data 711

Chapter 24 Mapping Geographic Data 723

Part VI Database and List Management 745

Chapter 25 Managing Information in Lists 747

Chapter 26 Working with External Data 787

Chapter 27 Using PivotTables 835

Part VII Macros and Visual Basic 877

Chapter 28 Creating Macros 879

Chapter 29 Custom Functions 901

Chapter 30 A Sample Visual Basic Application 915

Index 945

Table of Contents

Acknowledgments xxiv

Part I Getting Started with
Microsoft Excel 2000 1

Chapter 1 Getting Your Bearings 3

Starting Microsoft Excel 2000 4

A Tour of the Excel Workspace 5

The Workbook Window 5

The Menu Bar 13

Shortcut Menus 17

The Formula Bar 19

The Status Bar 20

The Pointer 21

Exiting Microsoft Excel 2000 22

Chapter 2 Getting Help 23

Meet the Assistant 24

Firing the Assistant 27

Getting Answers to Unasked Questions 27

Selecting Office Assistant Options 28

Using the Help System 31

Navigating through the Help System 31

Getting Help on the World Wide Web 33

Help for Lotus 1-2-3 Users 33

Getting Context-Sensitive Help 34

Identifying Toolbar Buttons with ScreenTips 35

Chapter 3 Toolbars and Menus 37

Introducing Toolbars 38

"Rafting" Toolbars 38

Adding More Toolbars to Your Screen 40

Positioning Toolbars and Menu Bars on
Your Screen 41

Customizing Toolbars and Menus 43

Removing and Adding Buttons and
Commands 44

Creating New Toolbars 53

Deleting Custom Toolbars 54

Creating New Menus 54

Saving Toolbar and Menu Changes 55

Changing the Look of Buttons 56

Creating a Custom Button 57

Copying Button Faces 58

Editing and Button Size 58

Attaching a Toolbar to a Workbook 58

Chapter 4 Managing Files 61

Working with Files 62

Creating a New File 62

Creating a New File Based on an Existing File 63

Saving Files 65

Saving the Entire Workspace 76

Opening Files 77

Searching for Files 83

Adding Additional Search Criteria 84

Importing and Exporting Files 86

Using the Open and Save As Commands to
Import Files 86

Importing and Exporting Text Files 87

Exporting Files to Earlier Versions of Excel 88

Sharing Data with Microsoft Excel for
the Macintosh 88

Part II Worksheets 91

Chapter 5 Worksheet Basics 93

Moving Around the Worksheet 94

Selecting with the Mouse 94

Selecting with the Keyboard 100

Entering Data 103

Simple Numeric and Text Values 103

Entering Numeric Values 103

Entering Text Values 106

Making Entries in Ranges 108

Correcting Errors in Entries 109

Protecting Your Data 111

Unlocking Individual Cells 112

Hiding Cells and Sheets 113

Entering Passwords 114

Removing Protection 114

Chapter 6 Building Formulas 115

Creating Formulas 116

Precedence of Operators 116

Matching Parentheses 117

Using Cell References in Formulas 117

Editing Formulas 123

Using Numeric Text in Formulas 124

Text Values 125

Using Functions: A Preview 126

Formula Bar Formatting 129

Creating Formulas Using Plain Language 129

Naming Cells and Ranges 133

Using Names in Formulas 133

Defining Names with the Name Box 133

Defining Names with the Name Command 134

Rules for Naming Cells and Ranges 138

Editing Names 138

Creating Names from Text Cells 138

Naming Constants and Formulas 139

Three-Dimensional Names 140

Pasting Names into Formulas 141

Applying Names to Formulas 142

Using Range Names with the Go To
Command 143

Understanding Error Values 144

Working with Arrays 144

Introducing Arrays 145

Two-Dimensional Arrays 146

Array Formula Rules 147

Using Array Constants 147

Array Expansion 148

Calculating the Worksheet 149

Manual Recalculation 149

Copying Formulas and Pasting Values 151

Circular References 151

Intentional Circular References 153...