Copy & Paste help topics into the search field of
Microsoft Excel. The review time is listed next to the topic.
A. Working
with Screens:
1.
Working
with Zoom (
1:05
)
2.
Full
Screen Mode (0:52 )
3.
Splitting
a worksheet window into panes (
1:29)
4.
Freezing
and Unfreezing Panes (
1:11 )
B. Working
with Worksheets:
1. Selecting
worksheets (
1:38
)
2. Renaming worksheets (0:33)
3. Coloring worksheet tabs (
1:01
)
4. Inserting a worksheet (0:28)
5. Removing a worksheet (0:28)
6. Changing the order of worksheets (0:41)
7. Grouping worksheets for one-step changes (
1:17
)
C. Formulas, Functions and
Ranges:
1. Creating a 3-D
formula (
2:35)
2. Using 3-D ranges (
1:37
)
3. Dragging 3-D formulas (0:53 )
4. Assigning a name to a cell (0:56)
5. Jumping to a cell using the name box (0:34)
6. Using range names in formulas (
1:22)
7. Creating range names using column or row headings (
2:29)
8. Replacing cell addresses to range names in existing formulas (
1:30)
9. Deleting range names (
1:26
)
10. Creating a 3-D formula using Range names (
1:03)
11. Creating a 3-D range name (
1:36)
12. Using 3-D range names in formulas (
1:07)
13. Creating an IF function (
2:54)
14. Creating a DATE function (
2:26
)
15. Formatting a Date (
1:02
)
16. Editing a function (0:38 )
D. Handy
Things to Know:
1. Sorting lists (
2:21
)
2. Using find and replace (1:3)
3. Running AutoFilter (
1:18)
4. Changing formatting with Find and Replace (
1:13
)
5. Creating a Custom AutoFilter (1:5)
6. Disabling AutoFilter (0:22)
7. The Excel Search Task Pane (
1:39
)
E. Working
with Objects:
1. Inserting a draw object in a worksheet (
1:19
)
2. Drawing a line in a worksheet (0:41)
3. Formatting a line (
1:12
)
4. Drawing an arrow (
1:01
)
5. Selecting filled and unfilled objects (0:40 )
6. Moving and resizing an object (0:22 -)
7. Adding text to an object (
1:16)
8. Resizing an object (0:40)
9. Changing an object's fill color (0:55 )
10. Changing an object's text color (0:50)
11. Deleting an object (0:28 )
12. Adding 3-D effects to an object (0:48)
13. Using 3-D options (
1:17
)
14. Adding a shadow to an object (0:54)
15. Drawing a text box (0:40 )
16. Inserting a picture (
1:47
)
17. Formatting a picture or graphic (
1:16)
18. Inserting a diagram (0:41)
19. Using diagram layout options (
1:18)
|
