Chapter 1 - How to create, print, and save a worksheet
|
|
An introduction to Excel 95
|
2 |
|
How to enter data into a worksheet
|
7 |
|
How to format the entries in a worksheet
|
15 |
|
How to enter formulas and functions into a worksheet
|
20 |
|
How to use the commands in the File menu
|
27 |
Chapter 2 - Essential worksheet skills
|
|
10 essential editing skills
|
38 |
|
How to use shortcut menus
|
38 |
|
How to undo or repeat the last operation
|
39 |
|
How to switch from one open workbook to another
|
40 |
|
How to move or copy data using commands
|
41 |
|
How to move or copy data using drag-and-drop editing
|
42 |
|
How to delete data
|
43 |
|
How to insert or delete one or more rows or columns
|
44 |
|
How to use the AutoFill feature to generate a series
|
45 |
|
How to sort the data in selected rows
|
46 |
|
How to check the spelling in a worksheet
|
47 |
|
10 essential formatting skills
|
48 |
|
How to change the font
|
48 |
|
How to change the font size
|
49 |
|
How to change the font attributes
|
50 |
|
How to add borders
|
51 |
|
How to use the AutoFormat command
|
52 |
|
How to center data across columns
|
53 |
|
How to justify text within columns
|
54 |
|
How to align cells and wrap text within cells
|
55 |
|
How to change the default header or footer
|
56 |
|
How to preview a worksheet
|
57 |
|
9 essential skills for working with larger worksheets
|
58 |
|
How to display a worksheet in Full Screen view
|
58 |
|
How to zoom in or out
|
58 |
|
How to split or unsplit the workbook window
|
59 |
|
How to hide and reveal columns and rows
|
60 |
|
How to freeze or unfreeze columns and rows
|
61 |
|
How to change the orientation and sizing of a worksheet
|
62 |
|
How to print titles on each page of a worksheet
|
63 |
|
How to insert and delete page breaks
|
64 |
|
How to print part of a worksheet
|
65 |
Chapter 3 - Two features that help you work like a
PRO
|
|
How to use more than one worksheet at a time
|
68 |
|
How to use the worksheet controls
|
68 |
|
How to group or ungroup worksheets
|
69 |
|
How to add or delete worksheets
|
70 |
|
How to enter data in more than one worksheet at the same
time
|
71 |
|
How to enter formulas that refer to other worksheets
|
72 |
|
How to enter functions that refer to other worksheets
|
73 |
|
How to move or copy worksheets
|
73 |
|
How to set up and print the worksheet pages
|
73 |
|
How to create charts
|
74 |
