| Introduction |
|
iii | |
| About the manual |
|
iv | |
| Setting your expectations |
|
vii | |
| Re-keying the course |
|
x | |
|
|
|
1 | (1) |
|
|
|
2 | (2) |
|
Exploring the Excel window |
|
|
4 | (5) |
|
|
|
9 | (5) |
|
Opening and navigating workbooks |
|
|
14 | (4) |
|
|
|
18 | (1) |
|
|
|
19 | |
|
Entering and editing data |
|
|
1 | (1) |
|
|
|
2 | (2) |
|
Entering and editing labels and values |
|
|
4 | (3) |
|
Entering and editing formulas |
|
|
7 | (6) |
|
Saving and updating workbooks |
|
|
13 | (3) |
|
Unit Summary: Entering and editing data |
|
|
16 | |
|
|
|
1 | (1) |
|
|
|
2 | (8) |
|
Moving and copying formulas |
|
|
10 | (4) |
|
Using absolute references |
|
|
14 | (2) |
|
Inserting and deleting ranges |
|
|
16 | (4) |
|
Unit Summary: Modifying a worksheet |
|
|
20 | |
|
|
|
1 | (1) |
|
|
|
2 | (5) |
|
|
|
7 | (1) |
|
Using AVERAGE, MIN, and MAX |
|
|
8 | (3) |
|
Unit Summary: Using functions |
|
|
11 | |
|
|
|
1 | (1) |
|
|
|
2 | (5) |
|
Formatting rows and columns |
|
|
7 | (6) |
|
|
|
13 | (6) |
|
Other formatting features |
|
|
19 | (6) |
|
Unit Summary: Formatting worksheets |
|
|
25 | |
|
|
|
1 | (1) |
|
|
|
2 | (3) |
|
|
|
5 | (7) |
|
|
|
12 | (3) |
|
|
|
15 | |
|
|
|
1 | (1) |
|
|
|
2 | (6) |
|
|
|
8 | (6) |
|
|
|
14 | (2) |
|
Unit Summary: Creating charts |
|
|
16 | |
|
|
|
1 | (1) |
|
Saving worksheets as Web pages |
|
|
2 | (4) |
|
|
|
6 | (2) |
|
|
|
8 | (1) |
|
Unit Summary: Web features |
|
|
9 | |
| Alternative user input |
|
1 | (1) |
|
|
|
2 | (5) |
|
|
|
7 | |
| MOUS exam objectives map |
|
1 | (1) |
|
|
|
2 | (3) |
|
|
|
5 | |
| Course summary |
|
1 | (1) |
|
|
|
2 | (2) |
|
Continued learning after class |
|
|
4 | |
| Quick reference |
|
1 | (1) |
| Index |
|
1 | |
Shopping Cart
