search for books and compare prices
Tables of Contents for Crash Course Excel 97
Chapter/Section Title
Page #
Page Count
Chapter 1 How to create, print, and save a worksheet
2
36
An introduction to Excel 97
2
5
How to interpret the Excel window
2
1
How to remove the Microsoft Office Shortcut Bar and the Office Assistant from the display
3
1
How to move the cell pointer
4
1
How to use the toolbar buttons
5
2
How to enter data into a worksheet
7
8
How to enter text into a worksheet
7
1
How to change the width of a column
8
1
How to enter numbers into a worksheet
9
1
How the General format works
10
1
How to use the range entry technique
11
1
How to enter dates and times into a worksheet
12
1
How to edit the contents of a cell
13
2
How to format the entries in a worksheet
15
5
How to select cells
15
1
How to use toolbar buttons to align entries
16
1
How to use toolbar buttons to format numbers
17
1
How to use the Format Cells command to format data
18
2
How to enter formulas and functions into a worksheet
20
7
How to enter formulas into a worksheet
20
1
General procedures and rules for entering formulas
21
1
How to copy formulas to adjacent cells
22
1
How to enter functions into a worksheet
23
1
General procedures and rules for entering functions
24
1
How to use the AutoSum button
25
1
How to align and format the result of a formula or function
25
2
How to use the commands in the File menu
27
11
How to change the setup for a worksheet
28
1
How to print a worksheet
29
1
How to save a workbook
30
1
How to close a workbook
31
1
How to open a workbook
32
1
How to change the file display in a dialog box
33
1
How to start a new workbook
34
1
How to exit from Excel
34
4
Perspective
Summary
Chapter 2 Essential Worksheet skills
38
30
Ten essential editing skills
38
10
How to use shortcut menus
38
1
How to undo or redo actions
39
1
How to repeat the last action
39
1
How to switch from one open workbook to another
40
1
How to move or copy data using commands
41
1
How to move or copy data using drag-and-drop editing
42
1
How to delete data
43
1
How to insert or delete one or more rows or columns
44
1
How to use the AutoFill feature to generate a series
45
1
How to sort the data in selected rows
46
1
How to check the spelling in a worksheet
47
1
Ten essential formatting skills
48
10
How to change the font
48
1
How to change the font size
49
1
How to change the font attributes
50
1
How to add borders
51
1
How to use the AutoFormat command
52
1
How to merge cells and center data across columns
53
1
How to justify text within columns
54
1
How to align cells and wrap text within cells
55
1
How to create a header or footer
56
1
How to preview a worksheet
57
1
Nine essential skills for working with larger worksheets
58
10
How to display a worksheet in Full Screen view
58
1
How to zoom in or out
58
1
How to split or unsplit the workbook window
59
1
How to hide and reveal columns and rows
60
1
How to freeze or unfreeze columns and rows
61
1
How to change the orientation and sizing of a worksheet
62
1
How to print titles on each page of a worksheet
63
1
How to insert and delete page breaks
64
1
How to print part of a worksheet
65
3
Perspective
Summary
Chapter 3 Two features that help you work like a PRO
68
How to use more than one worksheet at a time
68
6
How to use the worksheet controls
68
1
How to group or ungroup worksheets
69
1
How to add or delete worksheets
70
1
How to enter data in more than one worksheet at the same time
71
1
How to enter formulas that refer to other worksheets
72
1
How to enter functions that refer to other worksheets
72
1
How to move or copy worksheets
73
1
How to set up and print the worksheet pages
73
1
How to create charts
74
Ten types of charts you can create with Excel
74
1
The components of a typical chart
75
1
How to create a chart
76
3
How to select a chart, component, or subcomponent
79
1
How to size, move, copy, or delete a chart or a component
79
1
How to modify a chart
80
1
How to change a chart by changing its data
80
1
How to set up and print charts
80
Perspective
Summary