The
comprehensive tools in Microsoft®
Excel and the spreadsheet
help files make it easy to create powerful spreadsheets . This introductory
series gets you started.
Copy & Paste help topics into the search field of
Microsoft Excel. The review time is listed next to the topic.
1.
Working
with toolbars (
2:37
)
2.
The
Excel Task Pane (
1:08
)
3.
Keyboard
moves (
1:27
)
4.
Entering
info in a spreadsheet (0:42)
5.
Using
a template (
1:11)
6. Auto entry (
2:02)
7. Editing a cell (
1:23)
8. Spell check (
1:27)
9. Renaming an existing workbook (
1:41)
10. Selecting ranges (
1:41)
11. Entering values in a range (
1:18)
12. Auto fill (
1:51)
B. Formulas:
1. Entering formulas
(
1:48)
2. Auto sum and auto sum list (
1:58)
3. Basic functions (
1:11)
4. Inserting functions in formulas (
1:13)
5. Editing functions (1:50)
6. Using AutoCalculate (
1:03)
7. Modify formulas with range borders (
1:13)
8. Checking errors in formulas (
1:02)
C. Handy Things to Know:
1. Cut, copy, paste in Excel (
2:23)
2. Using the paste options button (
1:12 )
3. Using the paste list (
1:17
)
4. Using the clipboard task pane (
1:32
)
5. Creating an absolute reference (
2:57 )
6. Drag down fill (0:49)
7. Drag and drop editing (0:58)
8. Using undo and redo (
1:27 )
D. Printing:
1. Print preview and
page set up (
2:11)
2. Printing selected ranges (0:54)
3. Creating headers and footers (
2:00)
4. Changing print gridlines (
1:11 )
5. Repeating row and column labels (
1:19)
6. Using page break preview (
1:33 )
7. Setting and removing a print area (
1:06)
E.
Formatting Cells:
1. Number formatting
(0:50)
2. Formatting using the toolbar (0:57 )
3. Formatting using the dialog box (0:35 )
4. Rotating text in a cell (
1:18
)
5. Wrapping text in a cell (
1:27)
6. Shrinking text in a cell (0:41 )
7. Cell alignment and indentation (
2:08)
F. Columns and Row Options:
1. Selecting columns
and rows (0:25)
2. Changing column width (
1:03)
3. Changing row height (
1:05)
4. Hiding and unhiding columns (0:40)
5. Hiding and unhiding rows (0:45)
6. Inserting a column (
1:06)
7. Inserting a row (
1:16)
8. Inserting selected cells (
1:45 )
9. Delete a column or row (0:31 )
10. Deleting selected cells (0:46 )
G. More
Cell Formatting:
1. Using the Clear
command to edit (0:29)
2. Using the merge and center button (
1:20)
3. Changing vertical alignment in a cell (0:30)
4. Splitting cells (0:39)
5. Using the Borders button (0:55 )
6. Drawing cell borders (
1:02)
7. Using the fill color button (0:48)
8. Using the format painter (
1:16)
9. Applying AutoFormat (0:55)
10. Customizing AutoFormat options (0:54)
11. Using the extend list and formula feature (0:48)
H. Styles:
1. Creating a style
by example (
1:22)
2. Applying a style (0:30)
3. Modify a style (0:43 )
4. Merging styles (
1:51)
I. Help:
1. Using help (
2:08 )
|