EXCEL 2000 Bible

About the Author John Walkenbach is a leading authority on spreadsheet software, and principal of JWalk and Associates Inc., a Southern California - based consulting firm that specializes in spreadsheet application development. John is the author of about 30 spreadsheet books, and has written more than 300 articles and reviews for a variety of publications, including PC World, Info World, PC Magazine, Windows, and PC/Computing magazines. He's currently contributing editor for PC World and writes the magazine's monthly "Here's How" spreadsheet tips column. He also maintains a popular Internet Web site called "The Spreadsheet Page" at www.j-walk.com/ss, and is the developer of the Power Utility Pak, an award-winning add-in for Microsoft Excel. John graduated from the University of Missouri, and earned a Ph.D. from the University of Montana. John's other interests include guitar, MIDI music, novels, digital photography, and gardening.

Preface. Acknowledgments. PART I: Getting Started. Chapter 1: What's New in Excel 2000? Chapter 2: Getting Acquainted with Excel. Chapter 3: Navigating Through Excel. Chapter 4: Working with Files and Workbooks. PART II: Working with Excel. Chapter 5: Entering and Editing Worksheet Data. Chapter 6: Essential Spreadsheet Operations. Chapter 7: Working with Cell Ranges. Chapter 8: Creating and Using Formulas. Chapter 9: Using Worksheet Functions. Chapter 10: Manipulating Text. Chapter 11: Working with Dates and Times. Chapter 12: Counting and Summing Formulas. Chapter 13: Lookup Formulas. Chapter 14: Printing Your Work. Chapter 15: Customizing Toolbars and Menus. Chapter 16: Using and Creating Templates. PART III: Adding Visual Elements. Chapter 17: Worksheet Formatting. Chapter 18: Chart-Making Basics. Chapter 19: Advanced Charting. Chapter 20: Enhancing Your Work with Pictures and Drawings. Chapter 21: Creating Maps with Microsoft Map. Chapter 22: Putting It All Together. PART IV: Advanced Excel Features. Chapter 23: Creating and Using Worksheet Outlines. Chapter 24: Linking and Consolidating Worksheets. Chapter 25: Introducing Arrays. Chapter 26: Performing Magic with Array Formulas. Chapter 27: Using Excel in a Workgroup. Chapter 28: Sharing Data with Other Applications. Chapter 29: Excel and the Internet. Chapter 30: Making Your Worksheets Error-Free. Chapter 31: Fun Stuff. PART V: Analyzing Data with Excel. Chapter 32: Importing Data from Other Sources. Chapter 33: Working With Lists. Chapter 34: Using External Database Files. Chapter 35: Analyzing Data with Pivot Tables. Chapter 36: Performing Spreadsheet What-If Analysis. Chapter 37: Analyzing Data Using Goal Seeking and Solver. Chapter 38: Analyzing Data with Analysis ToolPak. PART VI: Programming Excel 2000 with VBA. Chapter 39: Essentials of Spreadsheet Application Development. Chapter 40: Introducing Visual Basic for Applications. Chapter 41: VBA Programming Fundamentals. Chapter 42: Working with VBA Sub Procedures. Chapter 43: Creating Custom Worksheet Functions. Chapter 44: Introducing UserForms. Chapter 45: UserForm Techniques. Chapter 46: Understanding Excel's Events. Chapter 47: Interacting with Other Applications. Chapter 48: Creating Custom Excel Add-Ins. Chapter 49: Creating Custom Toolbars. Chapter 50: Creating Custom Menus. Chapter 51: Providing Help for Your Applications. Appendix A: Using Online Help: A Primer. Appendix B: Online Excel Resources. Appendix C: Worksheet Function Reference. Appendix D: Importing 1-2-3 Formulas. Appendix E: Excel's Shortcut Keys. Appendix F: VBA Statements and Function Reference. Appendix G: VBA Error Codes. Appendix H: ANSI Code Reference. Appendix I: What's on the CD-ROM? Index. End -User License Agreement. CD-ROM Installation Instructions.