Cover image for Teach yourself Microsoft Excel 2000 visually
Teach yourself Microsoft Excel 2000 visually
Maran, Ruth, 1970-
Personal Author:
Publication Information:
Foster City, CA : IDG Books Worldwide, [1999]

Physical Description:
303 pages : color illustrations ; 23 cm.
General Note:
"IDG Books from maranGraphics."

Includes index.
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
HF5548.4.M523 M272 1999 Adult Non-Fiction Central Closed Stacks
HF5548.4.M523 M272 1999 Adult Non-Fiction Reference material
HF5548.4.M523 M272 1999 Adult Non-Fiction Computer Books

On Order



Presents a way to learn Excel 2000 and then advance further with minimal reading. The book shows readers how to get up and running with the latest version of Microsoft Excel, and then goes on to cover such topics as using workbooks, integrating graphics with Excel, and working with Excel databases.

Table of Contents

Chapter 1 Getting Started
Introduction to Excelp. 4
Using the Mousep. 6
Start Excelp. 7
The Excel Screenp. 8
Worksheet Basicsp. 9
Change the Active Cellp. 10
Select Commands Using Toolbarsp. 11
Select Commands Using Menusp. 12
Enter Datap. 14
Select Cellsp. 16
Complete a Seriesp. 18
Scroll Through a Worksheetp. 20
Getting Helpp. 22
Chapter 2 Save and Open Your Workbooks
Save a Workbookp. 28
Create a New Workbookp. 30
Switch Between Workbooksp. 31
View All Open Workbooksp. 32
Save Workbooks in a Workspace Filep. 34
Save a Workbook With a New Namep. 35
Close a Workbookp. 36
Exit Excelp. 37
Open a Workbookp. 38
Find a Workbookp. 40
Protect a Workbookp. 44
Chapter 3 Edit Your Worksheets
Edit Datap. 50
Delete Datap. 52
Undo Changesp. 53
Move or Copy Datap. 54
Check Spellingp. 58
Using AutoCorrectp. 60
Find Datap. 62
Replace Datap. 64
Link Datap. 66
Change Column Widthp. 68
Change Row Heightp. 69
Insert a Row or Columnp. 70
Delete a Row or Columnp. 72
Insert Cellsp. 74
Delete Cellsp. 76
Name Cellsp. 78
Add a Commentp. 80
Chapter 4 Work With Formulas and Functions
Introduction to Formulasp. 86
Enter a Formulap. 88
Introduction to Functionsp. 90
Enter a Functionp. 92
Using AutoCalculatep. 96
Add Numbersp. 98
Copy a Formulap. 100
Display Formulasp. 104
Errors in Formulasp. 106
Create Scenariosp. 108
Create a Scenario Summary Reportp. 112
Chapter 5 Change Your Screen Display
Zoom In or Outp. 116
Display Full Screenp. 117
Display or Hide a Toolbarp. 118
Size a Toolbarp. 120
Move a Toolbarp. 121
Hide Rowsp. 122
Hide Columnsp. 124
Freeze Rows and Columnsp. 126
Split a Worksheetp. 128
Chapter 6 Format Your Worksheets
Bold, Italicize or Underline Datap. 132
Change Horizontal Alignment of Datap. 133
Change Font of Datap. 134
Change Size of Datap. 135
Change Font for All New Workbooksp. 136
Change Appearance of Datap. 138
Change Cell or Data Colorp. 142
Indent Datap. 144
Center Data Across Columnsp. 145
Wrap Text in Cellsp. 146
Change Vertical Alignment of Datap. 148
Rotate Data in Cellsp. 150
Copy Formattingp. 152
Add Bordersp. 154
Clear Formattingp. 155
Change Number Formatp. 156
Apply an AutoFormatp. 160
Apply Conditional Formattingp. 162
Chapter 7 Print Your Worksheets
Preview a Worksheetp. 168
Print a Worksheetp. 170
Set a Print Areap. 172
Center Data on a Pagep. 174
Change Page Orientationp. 175
Change Marginsp. 176
Change Print Optionsp. 178
Insert a Page Breakp. 180
View All Page Breaksp. 182
Add a Header or Footerp. 184
Change Size of Printed Datap. 188
Repeat Labels on Printed Pagesp. 190
Chapter 8 Work With Multiple Worksheets
Switch Between Worksheetsp. 194
Insert a Worksheetp. 196
Delete a Worksheetp. 197
Rename a Worksheetp. 198
Move a Worksheetp. 199
Move or Copy Data Between Worksheetsp. 200
Enter a Formula Across Worksheetsp. 202
Chapter 9 Work With Charts
Introduction to Chartsp. 206
Create a Chartp. 208
Move or Size a Chartp. 212
Print a Chartp. 214
Change Chart Typep. 216
Change Chart Titlesp. 218
Rotate Chart Textp. 219
Format Chart Textp. 220
Add Data to a Chartp. 222
Add a Data Table to a Chartp. 224
Change the Way Data is Plottedp. 225
Change Appearance of Data Seriesp. 226
Change View of a 3-D Chartp. 228
Chapter 10 Work With Graphics
Add an AutoShapep. 232
Add a Text Effectp. 234
Add a Text Boxp. 236
Add Clip Artp. 238
Add a Picturep. 240
Move or Size a Graphicp. 242
Change Color of a Graphicp. 244
Make a Graphic 3-Dp. 245
Rotate a Graphicp. 246
Add a Shadow to a Graphicp. 247
Chapter 11 Manage Data in a List
Create a Listp. 250
Edit Data in a Listp. 252
Find Data in a Listp. 254
Sort Data in a Listp. 256
Filter a Listp. 260
Add Subtotals to a Listp. 264
Chapter 12 Time-Saving Features
Create a Custom Seriesp. 270
Create a New Toolbarp. 272
Record a Macrop. 278
Run a Macrop. 280
Chapter 13 Excel and the Internet
E-mail a Worksheetp. 284
Create a Hyperlinkp. 286
Preview a Workbook as a Web Pagep. 290
Save a Workbook as a Web Pagep. 292