Excel 2002 (XP) - Intro

Platform: PC

Description

The comprehensive tools in Microsoft^® Excel 2002 , the spreadsheet module of Office XP, make it easy to create powerful spreadsheets, and work with others to review and analyze them.

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

Click here to learn about subscribing to this collection!

Expand all / Collapse all

A. Basics

		Key #	Length
1.	Working with toolbars	2949	2:37
2.	Using the Excel Task Pane	2950	1:08
3.	Understanding keyboard moves	2951	1:27
4.	Entering info in a spreadsheet	2952	0:42
5.	Using a template	2953	1:11
6.	Using AutoEntry	2954	2:02
7.	Editing a cell	2955	1:23
8.	Using Spell check	2956	1:27
9.	Renaming an existing workbook	2957	1:41
10.	Selecting ranges	2958	1:41
11.	Entering values in a range	2959	1:18
12.	Using AutoFill	2960	1:51

B. Formulas

		Key #	Length
1.	Entering formulas	2961	1:48
2.	Using AutoSum and AutoSum list	2962	1:58
3.	Understanding basic functions	2963	1:11
4.	Inserting functions in formulas	2964	1:13
5.	Editing functions	2965	1:05
6.	Using AutoCalculate	2966	1:03
7.	Modify formulas with range borders	2967	1:13
8.	Checking errors in formulas	2968	1:02

C. Handy Things to Know

		Key #	Length
1.	Using Cut, Copy and Paste	2969	2:23
2.	Using the Paste Options button	2970	1:12
3.	Using the Paste List	2971	1:17
4.	Using the Clipboard Task Pane	2972	1:32
5.	Creating an absolute reference	2973	2:57
6.	Using drag down fill	2974	0:49
7.	Using drag and drop editing	2975	0:58
8.	Using Undo and Redo	2976	1:27

D. Printing

		Key #	Length
1.	Using Print Preview and Page Setup	2977	2:11
2.	Printing selected ranges	2978	0:54
3.	Creating headers and footers	2979	2:00
4.	Changing print gridlines	2980	1:11
5.	Repeating row and column labels	2981	1:19
6.	Using Page Break Preview	2982	1:33
7.	Setting and removing a print area	2983	1:06

E. Formatting Cells

		Key #	Length
1.	Using number formatting	2984	0:50
2.	Formatting using the toolbar	2985	0:57
3.	Formatting using the dialog box	2986	0:35
4.	Rotating text in a cell	2987	1:18
5.	Wrapping text in a cell	2988	1:27
6.	Shrinking text in a cell	2989	0:41
7.	Using cell alignment and indentation	2990	2:08

F. Columns & Row Options

		Key #	Length
1.	Selecting columns and rows	2991	0:25
2.	Changing column width	2992	1:03
3.	Changing row height	2993	1:05
4.	Hiding and unhiding columns	2994	0:40
5.	Hiding and unhiding rows	2995	0:45
6.	Inserting a column	2996	1:06
7.	Inserting a row	2997	1:16
8.	Inserting selected cells	2998	1:45
9.	Deleting a column or row	2999	0:31
10.	Deleting selected cells	3000	0:46

G. More Cell Formatting

		Key #	Length
1.	Using the Clear command to edit	3001	0:29
2.	Using the Merge and Center button	3002	1:20
3.	Changing vertical alignment in a cell	3003	0:30
4.	Splitting cells	3004	0:39
5.	Using the Borders button	3005	0:55
6.	Drawing cell borders	3006	1:02
7.	Using the Fill Color button	3007	0:48
8.	Using the Format Painter	3008	1:16
9.	Applying AutoFormat	3009	0:55
10.	Customizing AutoFormat options	3010	0:54
11.	Using the Extend list and Formula feature	3011	0:48

H. Styles

		Key #	Length
1.	Creating a style by example	3012	1:22
2.	Applying a style	3013	0:30
3.	Modifying a style	3014	0:43
4.	Merging styles	3015	1:51

I. Help

			Key #	Length
1.		Using Help	3016	2:08

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.

Tools

Generate Direct Linking HTML

Browse Training

Browse available training & projects

Log in to your account

My Profile & Settings

Direct Linking Preview

Direct Linking HTML

Generate Direct Linking HTML

Excel 2002 (XP) - Intro

Description

Tools

Browse Training

Find an Answer to a Tech Question