search for books and compare prices
Tables of Contents for Microsoft Excel 97 Illustrated Basic
Chapter/Section Title
Page #
Page Count
From the Illustrated Series Team
iii
Preface
iv
e Excel 97
Getting Started with Excel 97
1
1
Defining Spreadsheet Software
2
2
Starting Excel 97
4
2
Viewing the Excel Window
6
2
Opening and Saving an Existing Workbook
8
2
Entering Labels and Values
10
2
Navigating the worksheet
11
1
Previewing and Printing a Worksheet
12
2
Using Zoom in Print Preview
13
1
Getting Help
14
2
Changing the Office Assistant
14
2
Closing a Workbook and Exiting Excel
16
2
Concepts Review
18
2
Skills Review
20
1
Independent Challenges
21
2
Visual Workshop
23
Building and Editing Worksheets
1
1
Planning, Designing, and Creating a Worksheet
2
2
Editing Cell Entries and Working with Ranges
4
2
Using range names in a workbook
5
1
Entering Formulas
6
2
Order of precedence in Excel formulas
7
1
Introducing Excel Functions
8
2
Introducting the Paste Function
9
1
Copying and Moving Cell Entries
10
2
Copying Formulas with Relative Cell References
12
2
Copying Formulas with Absolute Cell References
14
2
Project a What-If Analysis
15
1
Naming and Moving a Sheet
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Formatting a Worksheet
1
1
Formating Values
2
2
Using the Format Painter
3
1
Selecting Fonts and Point Sizes
4
2
Using the Formatting toolbar to change fonts and sizes
5
1
Changing Attributes and Alignment of Labels
6
2
Using AutoFormat
7
1
Adjusting Column Widths
8
1
Specifiying row height
9
1
Inserting and Deleting Rows and Columns
10
2
Using dummy columns and rows
11
1
Applying Colors, Patterns, and Borders
12
2
Using color to organize a worksheet
13
1
Using Conditional Formatting
14
2
Deleting conditional formatting
15
1
Checking Spelling
16
2
Modifying the spell checker
17
1
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Working with Charts
1
1
Planning and Designing a Chart
2
2
Creating a Chart
4
2
Moving and Resizing a Chart and Its Objects
6
2
Viewing multiple worksheets
7
1
Editing a Chart
8
2
Rotating a chart
9
1
Changing the Appearance of a Chart
10
2
Enhancing a Chart
12
2
Changing text font and alignment in charts
13
1
Adding Text Annotations and Arrows to a Chart
14
2
Pulling out a pie slice
15
1
Previewing and Printing a Chart
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Managing Workbooks
1
1
Freezing Columns and Rows
2
2
Splitting the worksheet into multiple panes
3
1
Inserting and Deleting Sheets
4
2
Referencing Worksheet Data
6
2
Linking workbooks
7
1
Hiding and Protecting Worksheet Areas
8
2
Specifying Headers and Footers
10
2
Saving Custom Views of a Worksheet
12
2
Controlling Page Breaks and Page Numbering
14
2
Using Page Break Preview
15
1
Setting Margins and Alignment
16
2
Concepts Review
18
1
Skills Review
19
2
Independent Challenges
21
3
Visual Workshop
24
Glossary
1
3
Index
4