Microsoft® Excel Version 2002 Inside Out is the foremost reference to Excel version 2002 for PC "super users". Complete in one volume, this book provides a thorough overview of the most-used features and functions of Microsoft's popular spreadsheet program. The book provides the information advanced users really need. It delivers comprehensive information about each major Excel tool and task, including using worksheets, analyzing data, interfacing with other applications, using charts, creating databases and managing lists, and more. The book also shows how to create macros, use custom functions, and master Excel by using the Microsoft Visual Basic development system. Throughout the book you'll find a wealth of timesaving Excel tips and tricks, troubleshooting techniques, and indexes, plus a CD-ROM that holds an electronic version of the book's text, handy Web links, sample macros and code, tutorials, utilities and additional third party software. This is the authoritative handbook you'll keep by your computer and use whenever you're stuck or stumped!

Contents

Acknowledgments xxxiii

We'd Like to Hear from You xxxv

Conventions Used in This Book xxxvii

Part 1: Examining the Excel Environment 1

Chapter 1: What's New in Microsoft Excel 2002 3

Chapter 2: Running Excel 13

Chapter 3: Custom-Tailoring the Excel Workspace 65

Part 2: Building Worksheets 91

Chapter 4: Worksheet Design Tips 93

Chapter 5: How to Work a Worksheet 101

Chapter 6: How to Work a Workbook 133

Part 3: Formatting and Editing Worksheets 145

Chapter 7: Worksheet Editing Techniques 147

Chapter 8: Worksheet Formatting Techniques 199

Chapter 9: Advanced Formatting and Editing Techniques 245

Part 4: Adding Graphics and Printing 285

Chapter 10: Creating Spiffy Graphics 287

Chapter 11: Printing and Presenting 335

Part 5: Creating Formulas and Performing Data Analysis 353

Chapter 12: Building Formulas 355

Chapter 13: Using Functions 403

Chapter 14: Everyday Functions 413

Chapter 15: Formatting and Calculating Date and Time 439

Chapter 16: Functions for Financial Analysis 455

Chapter 17: Functions for Analyzing Statistics 471

Chapter 18: Performing What-If Analysis 499

Part 6: Collaborating and the Internet 529

Chapter 19: Collaborating with Excel 531

Chapter 20: Transferring Files to and from Internet Sites 553

Chapter 21: Linking and Embedding 569

Chapter 22: Using Hyperlinks 579

Part 7: Integrating Excel with Other Applications 589

Chapter 23: Integrating Excel with Word and PowerPoint 591

Part 8: Creating Charts 609

Chapter 24: Basic Charting Techniques 611

Chapter 25: Enhancing the Appearance of Your Charts 625

Chapter 26: Working with Chart Data 671

Chapter 27: Advanced Charting Techniques 687

Part 9: Managing Databases and Lists 703

Chapter 28: Managing Information in Lists 705

Chapter 29: Working with External Data 749

Chapter 30: Analyzing Data with PivotTable Reports 789

Part 10: Working with Visual Basic and Macros 831

Chapter 31: Recording Macros 833

Chapter 32: Creating Custom Functions 853

Chapter 33: A Sample Visual Basic Application 863

Chapter 34: Debugging Macros and Custom Functions 887

Part 11: Appendixes 901

Appendix A: Installing Microsoft Excel 903

Appendix B: Using Speech and Handwriting Recognition 911

Appendix C: Keyboard Shortcuts 925

Appendix D: Function Reference 949

Index of Troubleshooting Topics 983

Index 987