search for books and compare prices
Tables of Contents for Microsoft Excel 97 Illustrated Advanced
Chapter/Section Title
Page #
Page Count
From the Illustrated SeriesTM Team
iii
Preface
iv
e Excel 97
Using 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
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 PivotTables
1
1
Planning and Designing a PivotTable
2
2
Creating a PivotTable
4
2
Changing the Summary Function of a PivotTable
6
2
Analyzing Three-Dimensional Data
8
2
Updating a PivotTable
10
2
Maintaining original table data
11
1
Changing the Structure and Format of a PivotTable
12
2
Creating a Chart from a PivotTable
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
Importing a Database Table
6
2
Exporting Excel data
7
1
Inserting a Graphic File in a Worksheet
8
2
Creating and Modifying 3-D Shapes
9
1
Embedding a Worksheet
10
2
Linking a Worksheet to Another Program
12
2
Managing links
13
1
Pasting 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
2
2
Auditing a Worksheet
4
2
Circular References
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
Sharing Workbooks
15
1
Saving a Workbook as a Template
16
2
Opening a Template
17
1
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Programming with Excel
1
1
Viewing Existing VBA Code
2
2
Understanding the Visual Basic Editor
2
2
Analyzing Existing VBA Code
4
2
Object Properties
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 Procedure
12
2
Creating a Main Procedure
14
2
Running a Main Procedure
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Glossary
1
3
Index
4