Excel 2002

by Kathy Ivens (Conducted by)

Overview

Microsoft Excel is the leading spreadsheet application programme worldwide. As part of the Microsoft Office suite, Excell is the de facto standard for spreadsheet software. Excel 10 incorporates many significant new features such as speed recognition, enhanced user interfaces, improved multi-user document editing, digital signature support, improved crash recovery, multiple copy and paste clipboards, new web query interfaces, multi-use task panes, smart tags and improved pivot tables. Millions of Excel users worldwide, whether they are existing users looking for information on the many important upgrades or new computer workplace users needing an up-to-date text, will want comprehensive coverage on the new version of Excel.

Product Details

ISBN-13:	9780072132458
Publisher:	McGraw-Hill Companies, The
Publication date:	03/27/2001
Series:	Complete Reference
Pages:	759
Product dimensions:	7.51(w) x 9.34(h) x 1.65(d)

Table of Contents

Part I: Getting Started.
Chapter 1: Excel Basics.
Chapter 2: Entering Information.
Chapter 3: Working with Files.
Chapter 4: Manipulating Data.
Chapter 5: Structuring Worksheets.
Chapter 6: Printing.
Part II: Analyzing Data.
Chapter 7: Managing Data.
Chapter 8: Using Formulas.
Chapter 9: Worksheet Functions.
Chapter 10: Advanced Work with Formulas.
Chapter 11: Charting Data.
Chapter 12: Drawing Objects.
Chapter 13: Pivot Tables.
Chapter 14: Global Seek and Solver: Reaching Solutions with Brute Force.
Part III: The Outside World.
Chapter 15: Acquiring Data.
Chapter 16: Sharing Workbooks.
Chapter 17: Using Web Technology.
Part IV: Extending Excel's Reach with VBA.
Chapter 18: Repeating Tasks Automatically.
Chapter 19: The Visual Basic Editor and the Excel Object Model.
Chapter 20: Writing Subroutines.
Chapter 21: Writing Functions.
Chapter 22: Controlling Input with User Forms.
Chapter 23: Techniques for Handling VBA Arrays.
Chapter 24: Using Data Access Objects.
(and more...)