 Microsoft Excel 2000 Bible
ISBN: 978-0-7645-3259-7
Paperback
984 pages
May 1999
US $39.99
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. |
Instructors may request an evaluation copy for this title.
|
Preface.
Acknowledgments.
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.
Index.
End-User License Agreement.
CD-ROM Installation Instructions.
Acknowledgments.
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.
Index.
End-User License Agreement.
CD-ROM Installation Instructions.
