Generate Direct Linking HTML

Select the tutorials you would like to include in the Direct Linking HTML, then click the "Preview" button.

Excel 2004 - Intro
- A. Workbook Skills
- - Working with toolbars
  - Working with the menus
  - Setting the default sheet number
  - Keyboard moves
  - Entering info in a spreadsheet
  - Using a template
  - Renaming an existing workbook
- B. Working with Cells
- - Auto entry
  - Editing a cell
  - Spell check
  - Selecting ranges
  - Entering values in a range
  - Autofill
- C. Formulas & Functions
- - Entering formulas
  - AutoSum and AutoSum list
  - Basic functions
  - Inserting functions in formulas
  - Editing functions
  - Using AutoCalculate
  - Checking errors in formulas
  - Creating an absolute reference
  - Drag down fill
- D. Editing Skills
- - Cut, Copy, Paste in Excel
  - Using the Paste Options button
  - Using the paste list
  - Using the Scrapbook tool
  - Drag and drop editing
  - Using Undo and Redo
  - Using the Clear command to edit
- E. Page Setup
- - Print Preview and Page Setup
  - Printing selected ranges
  - Creating headers and footers
  - Changing print gridlines
  - Repeating row and column labels
  - Using Page Break preview
  - Setting and removing a print area
- F. Formatting Skills
- - Number formatting
  - Formatting using the toolbar
  - Formatting using the Formatting palette
  - Cell alignment & spacing
  - Shrinking or wrapping text in a cell
  - Selecting columns and rows
  - Changing column width & row height
  - Hiding and unhiding columns & rows
  - Inserting or deleting a column or row
  - Inserting or deleting selected cells
  - Using the Merge & Center button
  - Using the Format Painter
  - Applying AutoFormat
  - Using the Extend List and Formula features
- G. Borders & Styles
- - Using the Borders button
  - Drawing cell borders
  - Using the Fill Color button
  - Creating a style by example
  - Modify a style
  - Merging styles
- H. Help
- - Using help

Excel 2004 - Intro

Platform: Mac

The comprehensive tools in Microsoft^® Excel 2004 make it easy to create powerful spreadsheets and work with others to review and analyze them.

Click here to learn about subscribing to this collection!

Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.

Expand all / Collapse all

A. Workbook Skills

		Key #	Length
1.	Working with toolbars	13726	1:43
2.	Working with the menus	13727	1:46
3.	Setting the default sheet number	13728	2:31
4.	Keyboard moves	13729	3:11
5.	Entering info in a spreadsheet	13730	1:32
6.	Using a template	13731	1:40
7.	Renaming an existing workbook	13732	1:57

B. Working with Cells

		Key #	Length
1.	Auto entry	13733	2:08
2.	Editing a cell	13734	1:14
3.	Spell check	13735	2:11
4.	Selecting ranges	13736	1:43
5.	Entering values in a range	13737	1:12
6.	Autofill	13738	2:27

C. Formulas & Functions

		Key #	Length
1.	Entering formulas	13739	2:44
2.	AutoSum and AutoSum list	13740	2:50
3.	Basic functions	13741	2:09
4.	Inserting functions in formulas	13742	2:36
5.	Editing functions	13743	1:46
6.	Using AutoCalculate	13744	1:45
7.	Checking errors in formulas	13745	1:34
8.	Creating an absolute reference	13746	2:47
9.	Drag down fill	13747	1:04

D. Editing Skills

		Key #	Length
1.	Cut, Copy, Paste in Excel	13748	3:12
2.	Using the Paste Options button	13749	1:33
3.	Using the paste list	13750	0:50
4.	Using the Scrapbook tool	13751	2:52
5.	Drag and drop editing	13752	1:22
6.	Using Undo and Redo	13753	1:58
7.	Using the Clear command to edit	13754	1:47

E. Page Setup

		Key #	Length
1.	Print Preview and Page Setup	13755	2:20
2.	Printing selected ranges	13756	0:50
3.	Creating headers and footers	13757	1:53
4.	Changing print gridlines	13758	1:51
5.	Repeating row and column labels	13759	1:30
6.	Using Page Break preview	13760	2:39
7.	Setting and removing a print area	13761	1:14

F. Formatting Skills

		Key #	Length
1.	Number formatting	13762	2:31
2.	Formatting using the toolbar	13763	2:22
3.	Formatting using the Formatting palette	13764	1:02
4.	Cell alignment & spacing	13765	2:39
5.	Shrinking or wrapping text in a cell	13766	1:26
6.	Selecting columns and rows	13767	1:44
7.	Changing column width & row height	13768	2:56
8.	Hiding and unhiding columns & rows	13769	1:49
9.	Inserting or deleting a column or row	13770	3:02
10.	Inserting or deleting selected cells	13771	1:50
11.	Using the Merge & Center button	13772	1:13
12.	Using the Format Painter	13773	1:34
13.	Applying AutoFormat	13774	1:19
14.	Using the Extend List and Formula features	13775	1:19

G. Borders & Styles

		Key #	Length
1.	Using the Borders button	13776	1:55
2.	Drawing cell borders	13777	1:55
3.	Using the Fill Color button	13778	0:43
4.	Creating a style by example	13779	1:48
5.	Modify a style	13780	0:52
6.	Merging styles	13781	1:10

H. Help

			Key #	Length
1.		Using help	13782	1:32

Tutorial series by Diana Trettel

Box shot reprinted with permission from Microsoft Corporation. Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries. Mac is a trademark of Apple Computer, Inc., registered in the U.S. and other countries.