Using Microsoft Excel 97 Book

I Workbook Basics

1 Starting, Quitting, and Getting Help ..... 11
2 Opening, Searching For, and Closing Files ..... 31
3 Saving Files and Using Templates ..... 45
4 Selecting and Navigating Worksheets ..... 65
5 Changing Your View of the Worksheet ..... 81

II Building Worksheets

6 Entering Data ..... 95
7 Copying and Importing Data from Other Files ..... 107
8 Editing Data ..... 117
9 Simple Calculations ..... 137
10 Complex Calculations ..... 153

III Formatting

11 Formatting Cells ..... 195
12 Formatting Numbers ..... 223
13 Formatting with Styles for Less Effort ..... 237

IV Sorting, Filtering, and Summarizing Data

14 Sorting Lists ..... 249
15 Filtering Lists ..... 263
16 Summarizing Details with Consolidation or Subtotals ..... 287
17 Summarizing Details with a PivotTable ..... 301
18 Finding Answers and Making Decisions ..... 329

V Charts

19 Creating a Chart ..... 347
20 Formatting a Chart ..... 365
21 Putting Data on a Map ..... 391

VI Printing

22 Deciding What to Print ..... 409
23 Formatting the Printed Page ..... 421

VII Sharing Data with Other Users and Other Applications

24 Sharing a Workbook with Other Users ..... 443
25 Sharing Data Between Applications ..... 457

VIII Customizing and Automating

26 Customizing Your Excel Screen ..... 471
27 Automating Repetitive Work with Macros ..... 489
28 Using Excel's Built-in Templates ..... 503

IX Creative Excel

29 Drawing Objects..... 519
30 Creative Worksheets ..... 531
31 Creative Charts ..... 549

Glossary ..... 559

Index ..... 573