Excel 2002 (XP) - Intro

Topics Below are available in Microsoft Office Help 

or for purchase from http://www.atomiclearning.com

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 )

 

 


Forms, Procedures,
and Information
NEW...Transition SOP Forms