Mastering Excel 2000: Premium Edition

Mastering Excel 2000: Premium Edition

Paperback(5TH CD-ROM)

$39.99

Product Details

ISBN-13: 9780782123173
Publisher: Sybex, Incorporated
Publication date: 04/01/1999
Series: Mastering Series
Edition description: 5TH CD-ROM
Pages: 1328
Product dimensions: 7.54(w) x 9.02(h) x 2.68(d)

Table of Contents

Introduction
Part I: EASING INTO EXCEL 2000
Chapter 1: The Excel Environment
Chapter 2: Managing Your Files
Chapter 3: Managing Windows and Workbooks

Part II: WORKSHEETS
Chapter 4: Worksheet Basics
Chapter 5: Entering and Editing Data
Chapter 6: Formatting Your Worksheet
Chapter 7: Layout and Printing

Part III: FUNCTIONS
Chapter 8: Working with Functions and Formulas
Chapter 9: Essential Functions
Chapter 10: Dates and Times
Chapter 11: Financial Functions
Chapter 12: Statistical Functions

Part VI: CHARTS, MAPS, AND GRAPHICS
Chapter 13: Charting Basics
Chapter 14: Advanced Charting Techniques
Chapter 15: Mapping
Chapter 16: Drawing and Graphics

Part V: ANALYZING YOUR DATA
Chapter 17: Outlines and Data Consolidation
Chapter 18: What-If Analysis
Chapter 19: Using Excel Add-Ins
Part VI: WORKING WITH DATABASES
Chapter 20: Creating Excel Databases
Chapter 21: Advanced Database Management Techniques
Chapter 22: Getting At External Data

Part VII: MASTERING PIVOT REPORTS
Chapter 23: Understanding and Using PivotTable Reports
Chapter 24: Tapping into the Power of PivotTable Reports
Chapter 25: Pivot Reports in the Enterprise
Part VIII: NETWORKING WITH EXCEL
Chapter 26: Internet, Intranet, and Extranet
Chapter 27: Importing and Exporting Files
Chapter 28: Collaborating with Excel
Chapter 29: Distributing Your Excel Application

Part IX: EXCEL AND VBA
Chapter 30: VBA Macros and the Visual Basic Editor
Chapter 31: Basics of VBA
Chapter 32: Using VBA with Excel
Chapter 33: Creating Useful Forms
Appendices:
Appendix A: What's New in Excel 2000
Appendix B: Excel Functions
Appendix C: Excel Shortcut Keys
Index

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews