Microsoft Excel 2000: Complete Edition

Book Details

0072348089 By Sarah Hutchinson & Glen Coulthard
McGraw-Hill Higher Education

Purchase from Amazon
ISBN-10: 0072348089
Copyright: 2000
Pages: 718 pages
Binding: Spiral Coil
Online Resources:


Table of Contents

BRIEF EDITION: (view details)
Chp.1 Creating a Worksheet
Chp.2 Modifying a Worksheet
Chp.3 Formatting and Printing
Chp.4 Analyzing Your Data

INTRO EDITION: (view details)
Chp.5 Presenting Your Data
Chp.6 Performing Calculations
Chp.7 Managing Worksheets and Workbooks

Chp.8 Managing Lists
8.1 Working with Lists
8.2 Manipulating Lists
8.3 Analyzing Lists
8.4 Using Subtotals and Outlines

Chp.9 Analyzing Alternatives
9.1 Performing What-If Analysis
9.2 Working with Data Tables
9.3 Working with PivotTables and PivotCharts
9.4 Managing and Reporting Results

Chp.10 Working Smarter
10.1 Using Lookup Tables
10.2 Documenting Your Work
10.3 Protecting Your Work
10.4 Working with Templates
10.5 Importing and Exporting Data

Chp.11 Developing Workbook Application
11.1 Planning a Workbook Application
11.2 Validating Data
11.3 Auditing a Worksheet
11.4 Automating a Workbook
11.5 Customizing Menus and Toolbars

Chp.12 Working with Visual Basic for Applications
12.1 Introducing the VBA Environment
12.2 Understanding the VBA Language
12.3 Controlling Your Procedures
12.4 Interacting with the User
12.5 Working with Controls