search for books and compare prices
Tables of Contents for Excel 97 Secrets
Chapter/Section Title
Page #
Page Count
Introduction
1
10
Part I: Configuration Secrets: Laying the Foundation
11
78
Chapter 1: Before You Begin
13
8
Chapter 2: Setting Up and Configuring Excel
21
20
Chapter 3: Organizing Your Workspace
41
26
Chapter 4: Managing Workbooks, Sheets and Files
67
22
Part II: Data Management Secrets: Leveraging Your Input
89
150
Chapter 5: Strategies for Entering and Editing Data
91
28
Chapter 6: Connecting to Formulas, Functions and Links
119
38
Chapter 7: Way Beyond Basic Workbook Organization
157
38
Chapter 8: Taking Charts and Maps to the Limit
195
44
Part III: Spreadsheet Design Secrets: Insider Presentation Strategies
239
114
Chapter 9: The Essentials of Spreadsheet Design
241
28
Chapter 10: Power-Formatting with Styles and templates
269
22
Chapter 11: Illustrating Your Point with Graphics
291
34
Chapter 12: Advanced Printing and Reports
325
28
Part IV: Integration Secrets: Sharing Data Intelligently
353
142
Chapter 13: Sifting Your Data with Lists
355
44
Chapter 14: Excel in Workgroups
399
30
Chapter 15: Handling Old Excel and Alien Spreadsheet Files
429
30
Chapter 16: Excel and Its Microsoft Office Partners
459
36
Part V: Number-Crunching Secrets: To Prove a Point
495
154
Chapter 17: Charts as Data-Analysis Tools
497
22
Chapter 18: When Pivot Tables Swing the Decision
519
32
Chapter 19: Forecasting with What-If Techniques
551
40
Chapter 20: Solving Complex Problems with Solver
591
30
Chapter 21: Statistics Made Easy
621
28
Part VI: Programming Secrets: Making Excel Jump Through Hoops
649
94
Chapter 22: Controlling Excel from VBA
Chapter 23: VBA Coding So Excel Does All the Work
651
20
Chapter 24: Managing VBA Entry Points
671
42
Chapter 25: Communicating with the User
713
16
Chapter 26: Finishing Touches
729
12
Appendix: The Excel 97 SECRETS CD-ROM
741
2
Index
743
20
License and Disclaimer
763