Learning Microsoft Excel 2000

by Fulton, Jennifer; Kaczmarczyk, Nancy

• ISBN13: 9781562437053
• ISBN10: 1562437054
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: Pearson College Div

Summary

Provides a compendium of ten lessons comprising short exercises designed for using Excel 2000 in real-life business settings. Spiral. CD-ROM included.

Table of Contents

Introduction	p. vi
Directory of Files	p. ix
Excel 2000 Basics	p. 1
	p. 2
About Microsoft Excel 2000
Start Excel
The Excel Window
Exit Excel
Use the Mouse
Use the Keyboard
Mouse and Keystroke Procedures
Menus and Commands
Shortcut Menus
Toolbars
Dialog Box Options
	p. 11
Change the Size of a Window
Set View Preferences
The View Menu
The Zoom Option
	p. 16
The Office Assistant
Other Help Features
Help on the Internet
	p. 21
Change the Active Cell
Explore the Worksheet with the Mouse or the Keyboard
Use Go To
Use the Name Box
The Excel Keyboard Template
	p. 25
Manage Multiple Workbooks
Internet Basics
Web Features in Excel 2000
Use Web Toolbars
Key Worksheet Procedures	p. 31
	p. 32
Start a Blank Workbook
Enter Labels
Make Corrections
Save a Workbook
Close a Workbook
	p. 36
Enter Numeric Labels and Values
Enter Fractions and Mixed Numbers
Change Data Alignment
Center a Title (Merge and Center)
Change Column Width
Adjust Row Height
Indent Text in Cells
Add Comments to Cells
	p. 43
AutoComplete
Pick From List
AutoCorrect
Undo and Redo
Clear Cell Contents
Check Spelling
	p. 47
Enter Line Breaks in a Cell Entry
Enter Dates
Format Dates
	p. 50
Open a Workbook
Change Workbook Properties
Save a Workbook with a Different Name
Create a New Folder
Create Backup Files
Check for Potential Viruses
Send a File
	p. 55
Critical Thinking
Use Formulas And Formatting	p. 57
	p. 58
Use Formulas
Mathematical Operators
Natural Language Formulas
	p. 62
Format Data with Formatting Toolbar
Fonts and Font Size
Add Bold, Italic, and Underline
Currency, Percent, Comma, and Accounting Formats
Increase or Decrease Decimals
Format Numbers with the Format Cells Dialog Box
Create Custom Number Formats
	p. 67
Use Ranges
Name Ranges
	p. 72
Copy Data
Copy Using AutoFill
Copy Part of a Cell's Contents
Copy a Formula (Absolute, Relative, and Mixed Reference)
	p. 76
Create a Series
AutoSum
	p. 80
Use Functions
Formula Bar and Palette
Paste Function
Noncontiguous Ranges in a Function
AutoCalculate
	p. 85
Critical Thinking
Print A Worksheet	p. 87
	p. 88
Preview a Worksheet
Quickly Print a Worksheet
	p. 91
Set the Print Area
Print Options
Page Setup
	p. 95
Page Breaks
Page Break Preview
Headers and Footers
	p. 99
Print Titles
	p. 102
Critical Thinking
Edit and Manipulate Worksheets and Workbooks	p. 103
	p. 104
Insert and Delete Selected Cells
Insert and Delete Columns and Rows
Move Data (Cut/Paste)
Drag-and-Drop Editing
Copy or Move Data with the Office Clipboard
	p. 110
Copy and Paste Special
Transpose Data
	p. 113
Move Between Worksheets
Rearrange Worksheets
Name a Worksheet
Add and Delete Worksheets
Copy a Worksheet
Group Sheets
	p. 118
Copy and Paste Special (Combine Data)
	p. 121
Freeze Titles
Split Panes
Scroll Tips
Move Between Workbooks
Arrange Workbooks
Save the Workspace
New (or Duplicate) Workbook Window
	p. 127
3-D Formulas
	p. 130
Drag-and-Drop Editing Between Workbooks
Find and Replace
	p. 133
Use Templates (Spreadsheet Solutions)
	p. 139
Create Original Templates
	p. 142
Critical Thinking
Modify the Appearance of a Worksheet	p. 143
	p. 144
Use the Font Tab
Rotate Text
Wrap Text
Merge Cells
	p. 148
Change Cell Colors and Patterns
Change Cell Borders
Hide Worksheet Gridines
Format Worksheet Background
Copy Formats with Format Painter
Clear Cell Formats
Create Styles
	p. 154
The Drawing Toolbar
Insert AutoShapes
Draw Objects
Format Objects
	p. 159
Insert WordArt
	p. 162
Insert and Size Clip Art
Download Clip Art from the Internet
	p. 165
Use AutoFormat to Format Ranges
	p. 168
Add and Format a Text Box
Add Callouts
Add Shadows
	p. 172
Critical Thinking
Integrate Excel with other Applications and the Internet	p. 173
	p. 174
Object Linking and Embedding (OLE)
Link Workbooks
Link Files
Edit a Linked File
Embed a File
Integrate Office Documents
	p. 178
Integrate an Excel Worksheet and a Word Document
Financial Data on the Internet
	p. 184
Save a Worksheet as a Web Page
Web Page Preview
Create an Interactive Worksheet
View a Web Page
	p. 191
Import Text Files
Import Data from Other Applications
Import a Table from an HTML File
Use the Clipboard to Import Data
Export Data to Other Applications
	p. 198
Critical Thinking
Use Advanced Functions	p. 199
	p. 200
Understand IF Functions
Enter an IF Function
Nested IF Functions
=SUMIF()
=COUNTIF()
Conditional Formatting
	p. 207
PMT Function
What-If Data Tables
	p. 213
Solve a Problem with Goal Seek
Use Solver to Resolve Problems
	p. 217
Conditional Sum Wizard
	p. 220
Audit Formulas
Error Messages
	p. 224
Hide Data
Save Different Views of the Workbook (Custom Views)
	p. 228
Scenarios
Report Manager
	p. 233
VLOOKUP Function
HLOOKUP Function
	p. 237
Lock/Unlock Cells in a Worksheet
Protect a Worksheet
Protect a Workbook
	p. 241
Share Workbooks
Track Changes
Merge Changes
	p. 245
Critical Thinking
Create and Modify Charts	p. 247
	p. 248
Chart Basics
Select Chart Data
Chart Elements
Create a Chart
Select a Chart
Change the Chart Type
Resize, Copy, Move, or Delete a Chart
	p. 254
Use the Chart Toolbar
Select a Chart Object
Resize, Move, or Delete a Chart Object
Add a Chart Object
Change Chart Text
Change the Orientation of Chart Text
	p. 259
Enhance the Chart Background
Format Category and Value Axes
Change Color and Patterns of Data Series
Add or Remove Data in a Chart
	p. 266
Preview a Chart
Print a Chart Sheet
Print an Embedded Chart
Publish a Chart to the Internet/intranet
	p. 271
Change the Location of a Chart
Change the Orientation of a Data Series
	p. 274
Create a Stock Chart
Add a Secondary Value Axis to a Chart
Change Data Marker Format
	p. 279
Create an Exploded Pie Chart
Size the Plot Area or Legend in a Chart
Create a Stacked Area Chart
	p. 283
Create a 3-D Chart
Change the View of a 3-D Chart
Display or Hide Gridlines or Data Labels
	p. 288
Map Excel Data with Microsoft Map
Edit and Format a Map
	p. 292
Link a Chart and a Word Document
Embed a Chart into a Word Document
Edit a Linked or Embedded Chart
	p. 296
Critical Thinking
Analyze Data	p. 299
	p. 300
Create a List/Database
Name a List/Database
Use a Data Form to Add Records
Adding Fields to a List
	p. 304
Modify a Record
Find a Record
Delete a Record
	p. 308
Control Data Entry
Copy and Paste Validation Rules
Circle Invalid Data
	p. 314
Sort Records in a List
Rules for Sorting
Undo a Sort
Restore the Record Order
	p. 319
AutoFilter a Database
	p. 323
Advanced Filters
Guidelines for Entering Criteria
Examples of Advanced Criteria
Remove an In-place Advanced Filter
Edit Extracted Records
	p. 330
Use Database (List) Functions
Excel's Database Functions
	p. 334
Subtotal a List
Create Nested Subtotals
Remove a Subtotal
Copy a Subtotal
Outline a Worksheet
	p. 340
Create PivotTables and PivotCharts
Publish a PivotTable or PivotChart
Use PivotTable Toolbar
	p. 347
Data Consolidation
Create Consolidation Tables
	p. 351
Critical Thinking
Create Macros and Hyperlinks	p. 353
	p. 354
Record a Macro
Stop Recording
Run a Macro
	p. 359
Open a Workbook Containing Macros
Edit a Macro
Delete a Macro
Assign a Macro to a Toolbar Button
Assign a Macro to a Control
	p. 365
Link Documents with Hyperlinks
Add a Hyperlink to a Worksheet
	p. 370
Critical Thinking
Table of Contents provided by Syndetics. All Rights Reserved.