You, too, can excel -- especially with expert advice from one of the country's leading authorities on spreadsheet software. Whenever you get stuck or need to learn something you've never done before, turn to Microsoft Excel 2000 Bible. With plenty of examples and little-known tips, John Walkenbach guides you step-by-step through the entire program -- from basic cell formatting to the exciting new Web capabilities of Excel 2000.
John Walkenbach is one of the country's leading authorities on spreadsheet software. He holds a Ph.D. from the Univerity of Montana and has worked as an instructor, programmer, and market research manager. He finally found a job he's good at: principal of JWalk and Associates Inc., a one-person San Diego-based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the award-winning Power Utility Pak add-in for Excel -- which is used by thousands of people throughout the world. John started writing about spreadsheets in 1984, and he has since written more than 250 srticles and reviews for publications such as PC World, InfoWorld, Windows magazine, and PC/Computing. In addition he's the author of a dozen other spreadsheet books, including Excel 2000 Power Programming Techniques, Excel Programming For Dummies and Excel 2000 For Windows For Dummies Quick Reference (all from IDG Books Worldwide). In his spare time John enjoys digital photography and composing and playing music in a variety of styles. John also maintains "The Spreadsheet Page" on the Web. Pay him a visit at http://www.j-walk.com
Table of Contents
Part I: Getting Started.
Chapter 1: A Bit of Background.
Chapter 2: What's New in Excel 2000?
Chapter 3: Getting Acquainted with Excel.
Part II: Introductory Concepts.
Chapter 4: Navigating Through Excel.
Chapter 5: Working with Files and Workbooks.
Chapter 6: Entering and Editing Worksheet Data.
Chapter 7: Essential Spreadsheet Operations.
Chapter 8: Working with Cell Ranges.
Chapter 9: Creating and Using Formulas.
Chapter 10: Using Worksheet Functions.
Chapter 11: Worksheet Formatting.
Chapter 12: Printing Your Work.
Chapter 13: Chart-Making Basics.
Chapter 14: Enhancing Your Work with Pictures and Drawings.
Chapter 15: Putting It All Together.
Part III: Advanced Features.
Chapter 16: Advanced Charting.
Chapter 17: Creating Maps with Microsoft Map.
Chapter 18: Creating and Using Worksheet Outlines.
Chapter 19: Linking and Consolidating Worksheets.
Chapter 20: Creating and Using Array Formulas.
Chapter 21: Using Excel in a Workgroup.
Part IV: Analyzing Data.
Chapter 22: Importing Data from Other Sources.
Chapter 23: Working With Lists.
Chapter 24: Using External Database Files.
Chapter 25: Analyzing Data with Pivot Tables.
Chapter 26: Performing Spreadsheet What-If Analysis.
Chapter 27: Analyzing Data Using Goal Seeking and Solver.
Chapter 28: Analyzing Data with Analysis ToolPak.
Part V: Other Topics.
Chapter 29: Sharing Data with Other Applications.
Chapter 30: Excel and the Internet.
Chapter 31: Making Your Worksheets Error-Free.
Chapter 32: Fun Stuff.
Part VI: Customizing Excel.
Chapter 33: Customizing Toolbars and Menus.
Chapter 34: Using and Creating Templates.
Chapter 35: Using Visual Basic for Applications.
Chapter 36: Creating Custom Worksheet Functions.
Chapter 37: Creating Custom Dialog Boxes.
Chapter 38: Using Dialog Box Controls in Your Worksheet.
Chapter 39: VBA Programming Examples.
Chapter 40: Creating Custom Excel Add-Ins.
Appendix A: Using Online Help: A Primer.
Appendix B: Worksheet Function Reference.
Appendix C: Excel's Shortcut Keys.
Appendix D: What's on the CD-ROM.
End-User License Agreement.
CD-ROM Installation Instructions.