search for books and compare prices
Tables of Contents for Microsoft Excel 2000
Chapter/Section Title
Page #
Page Count
From the Illustrated Series Team
iii
Preface
iv
Excel 2000
Using a What-If Analysis
1
1
Defining a What-If Analysis
2
2
Tracking a What-If Analysis with Scenario Manager
4
2
Merging scenarios
4
2
Generating a Scenario Summary
6
2
Using Report Manager
7
1
Projecting Figures Using a Data Table
8
2
Creating a Two-Input Data Table
10
2
Using Goal Seek
12
2
Setting Up a Complex What-If Analysis with Solver
14
2
Running Solver and Generating an Answer Report
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Summarizing Data with Pivot Tables
1
1
Planning and Designing a PivotTable Report
2
2
Creating a PivotTable Report
4
2
Changing the Summary Function of a PivotTable Report
6
2
Analyzing Three-Dimensional Data
8
2
Updating a PivotTable Report
10
2
Maintaining original table data
11
1
Changing the Structure and Format of a PivotTable Report
12
2
Creating a Pivot Chart Report
14
2
Using the GETPIVOTDATA Function
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Exchanging Data with Other programs
1
1
Planning a Data Exchange
2
2
Importing a Text File
4
2
Other ways to import text files
5
1
Importing a Database Table
6
2
Exporting Excel data
7
1
Inserting a Graphic File in a Worksheet
8
2
Importing data from HTML files
9
1
Embedding a Worksheet
10
2
Linking a Worksheet to Another Program
12
2
Managing links
13
1
Embedding an Excel Chart into a PowerPoint Slide
14
2
Converting a List to an Access Table
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Gaining Control over Your work
1
1
Finding Files
2
2
File properties
3
1
Auditing a Worksheet
4
2
Circular references
5
1
Hiding and displaying toolbars
5
1
Outlining a Worksheet
6
2
Controlling Worksheet Calculations
8
2
Creating Custom AutoFill Lists
10
2
Customizing Excel
12
2
Adding a Comment to a Cell
14
2
Preview and print multiple worksheets
15
1
Saving a Workbook as a Template
16
2
Storing, applying, and modifying templates
17
1
Concepts Review
18
2
Skills Review
20
2
Independent Challenges
22
2
Visual Workshop
24
Programming with Excel
1
1
Viewing VBA Code
2
2
Understanding the Visual Basic Editor
3
1
Analyzing VBA Code
4
2
Writing VBA Code
6
2
Entering code
7
1
Adding a Conditional Statement
8
2
Prompting the User for Data
10
2
Debugging a Macro
12
2
Creating a Main Procedure
14
2
Running a Main Procedure
16
2
Concepts Review
18
1
Skills Review
19
3
Independent Challenges
22
2
Visual Workshop
24
Word 2000 MOUS Certification Objectives
1
1
Glossary
1
4
Index
5