Excel 2000 - Intro

Platform: PC

Description

The comprehensive tools in Microsoft^® Excel 2000, the spreadsheet module of Microsoft Office 2000, 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	8018	1:23
2.	Understanding keyboard moves	8019	1:12
3.	Entering info in a spreadsheet	8020	0:57
4.	Using a template	8021	1:11
5.	Entering numbers into a cell	8022	0:54
6.	Using AutoEntry	8023	1:16
7.	Editing a cell	8024	0:53
8.	Using spell check	8025	1:19
9.	Renaming an existing workbook	8026	0:53
10.	Selecting ranges	8027	0:55
11.	Entering values in a range	8028	0:29
12.	Using AutoFill	8029	0:53

B. Formulas

		Key #	Length
1.	Entering formulas	8030	1:30
2.	Using AutoSum	8031	0:47
3.	Using basic functions	8032	1:25
4.	Inserting functions in formulas	8033	1:06
5.	Editing functions	8034	0:50
6.	Using AutoCalculate	8035	1:00
7.	Modify formulas with range borders	8036	1:00
8.	Tracing errors in formulas	8037	1:49

C. Handy Things to Know

		Key #	Length
1.	Using Cut, Copy, and Paste in Excel	8038	1:33
2.	Using the clipboard	8039	1:30
3.	Creating an absolute reference	8040	2:27
4.	Using Drag Down Fill	8041	0:28
5.	Using drag and drop editing	8042	1:02
6.	Using Undo and Redo	8043	0:52

D. Printing

		Key #	Length
1.	Using Print Preview and Page Setup	8044	1:13
2.	Printing selected ranges	8045	0:33
3.	Creating headers and footers	8046	2:08
4.	Changing Print gridlines	8047	0:48
5.	Repeating row and column labels	8048	1:16
6.	Using Page Break Preview	8049	1:08
7.	Setting and removing a print area	8050	0:45

E. Formatting Cells

		Key #	Length
1.	Changing number formatting	8051	1:40
2.	Formatting using the toolbar	8052	0:49
3.	Formatting using the dialog box	8053	1:03
4.	Rotating text in a cell	8054	0:48
5.	Wrapping text in a cell	8055	0:53
6.	Shrinking text in a cell	8056	0:54
7.	Changing cell alignment and indentation	8057	1:26

F. Column and Row Options

		Key #	Length
1.	Selecting columns and rows	8058	1:34
2.	Changing column width	8059	1:32
3.	Changing row height	8060	1:01
4.	Hiding and unhiding columns	8061	1:12
5.	Hiding and unhiding rows	8062	1:12
6.	Inserting a column	8063	0:37
7.	Inserting a row	8064	0:36
8.	Inserting selected cells	8065	0:44
9.	Deleting columns or rows	8066	0:19
10.	Deleting selected cells	8067	0:47

G. More Cell Formatting

		Key #	Length
1.	Using the Clear command to edit	8068	1:24
2.	Using the Merge and Center button	8069	0:59
3.	Changing vertical alignment in a cell	8070	0:28
4.	Splitting cells	8071	1:06
5.	Using the Borders button	8072	0:51
6.	Using the Fill Color button	8073	0:48
7.	Using the Format Painter	8074	1:42
8.	Applying AutoFormat	8075	0:44
9.	Customizing AutoFormat options	8076	1:16
10.	Using the Extend List and Formula features	8077	1:28

H. Styles

		Key #	Length
1.	Creating a style by example	8078	1:03
2.	Applying a style	8079	0:32
3.	Modifying a style	8080	0:36
4.	Merging styles	8081	0:58

I. Help

			Key #	Length
1.		Using Help	8082	2:23

Tutorial series by Diana Trettel

Box shot reprinted with 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 2000 - Intro

Description

Tools

Browse Training

Find an Answer to a Tech Question