Generate Direct Linking HTML

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

Excel 2003 - Intermediate
- A. Viewing Worksheets
- - Comparing Excel workbooks side by side
  - Working with zoom
  - Full Screen Mode
  - Splitting a worksheet window into panes
  - Freezing and Unfreezing Panes
- B. Working with Worksheets
- - Selecting worksheets
  - Renaming worksheets
  - Coloring worksheet tabs
  - Inserting a worksheet
  - Removing a worksheet
  - Changing the order of worksheets
- C. Working in 3-D
- - Creating a 3-D formula
  - Using 3-D ranges
  - Dragging 3-D formulas
  - Assigning a name to a cell
  - Jumping to a cell using the name box
  - Using range names in formulas
  - Creating range names using column or row headings
  - Replacing cell addresses with range names
  - Deleting range names
  - Creating a 3-D formula using range names
  - Creating a 3-D range name
- D. Functions
- - Creating an IF function
  - Creating a DATE function
  - Formatting a date
  - Editing a function
- E. Lists
- - Creating a list in Excel
  - Sorting a list
  - Filtering and sorting in an Excel list
  - Inserting columns and rows in a list
  - Moving, hiding, and converting lists
  - Creating a toggle total row in a list
- F. Search, Find, Autofilter
- - Using find and replace
  - Running AutoFilter
  - Changing formatting with Find and Replace
  - Creating a Custom AutoFilter
  - The Excel Search Task Pane
- G. Objects, Pictures, and Diagrams
- - Inserting a draw object in a worksheet
  - Drawing a line in a worksheet
  - Formatting a line
  - Drawing an arrow
  - Selecting filled and unfilled objects
  - Resizing an object
  - Adding text to an object
  - Changing an object's fill and text colors
  - Adding 3-D effects to an object
  - Adding a shadow to an object
  - Drawing a text box
  - Inserting a picture
  - Formatting a picture or graphic
  - Inserting a diagram
  - Using diagram Layout options

Excel 2003 - Intermediate

Platform: PC

Microsoft^® Excel 2003, the spreadsheet module of Office 2003, makes it easy to create powerful spreadsheets. This intermediate skills series will take you many steps beyond the basics.

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. Viewing Worksheets

		Key #	Length
1.	Comparing Excel workbooks side by side	11003	1:37
2.	Working with zoom	11004	1:38
3.	Full Screen Mode	11005	1:25
4.	Splitting a worksheet window into panes	11006	1:33
5.	Freezing and Unfreezing Panes	11007	1:42

B. Working with Worksheets

		Key #	Length
1.	Selecting worksheets	11008	1:51
2.	Renaming worksheets	11009	1:21
3.	Coloring worksheet tabs	11010	1:32
4.	Inserting a worksheet	11011	1:06
5.	Removing a worksheet	11012	0:43
6.	Changing the order of worksheets	11013	0:57

C. Working in 3-D

		Key #	Length
1.	Creating a 3-D formula	11014	1:30
2.	Using 3-D ranges	11015	1:42
3.	Dragging 3-D formulas	11016	0:43
4.	Assigning a name to a cell	11017	1:08
5.	Jumping to a cell using the name box	11018	0:54
6.	Using range names in formulas	11019	0:58
7.	Creating range names using column or row headings	11020	2:03
8.	Replacing cell addresses with range names	11021	1:10
9.	Deleting range names	11022	0:53
10.	Creating a 3-D formula using range names	11023	0:47
11.	Creating a 3-D range name	11024	1:30

D. Functions

		Key #	Length
1.	Creating an IF function	11025	1:35
2.	Creating a DATE function	11026	2:24
3.	Formatting a date	11027	0:46
4.	Editing a function	11028	0:47

E. Lists

		Key #	Length
1.	Creating a list in Excel	11029	2:29
2.	Sorting a list	11030	2:12
3.	Filtering and sorting in an Excel list	11031	1:09
4.	Inserting columns and rows in a list	11032	1:29
5.	Moving, hiding, and converting lists	11033	1:30
6.	Creating a toggle total row in a list	11034	1:17

F. Search, Find, Autofilter

		Key #	Length
1.	Using find and replace	11035	1:25
2.	Running AutoFilter	11036	1:11
3.	Changing formatting with Find and Replace	11037	1:37
4.	Creating a Custom AutoFilter	11038	2:02
5.	The Excel Search Task Pane	11039	1:11

G. Objects, Pictures, and Diagrams

		Key #	Length
1.	Inserting a draw object in a worksheet	11040	1:13
2.	Drawing a line in a worksheet	11041	1:16
3.	Formatting a line	11042	1:29
4.	Drawing an arrow	11043	1:03
5.	Selecting filled and unfilled objects	11044	1:00
6.	Resizing an object	11045	1:36
7.	Adding text to an object	11046	1:05
8.	Changing an object's fill and text colors	11047	0:47
9.	Adding 3-D effects to an object	11048	1:31
10.	Adding a shadow to an object	11049	0:56
11.	Drawing a text box	11050	0:45
12.	Inserting a picture	11051	1:02
13.	Formatting a picture or graphic	11052	1:04
14.	Inserting a diagram	11053	1:04
15.	Using diagram Layout options	11054	0:24

Tutorial series by Diana Trettel

Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.