Microsoft Excel 2000 / Edition 1

Microsoft Excel 2000 / Edition 1

by Pamela R. Toliver, Philip A. Koneman, Yvonne Johnson
     
 

ISBN-10: 0201458985

ISBN-13: 9780201458985

Pub. Date: 07/09/1999

Publisher: Pearson Education

The SELECT Lab Series uses a highly visual, project-based approach that teaches readers through tasks supported by step-by-step instruction, and extensive 4-color figures tat guide learners through the basic skills and procedures necessary to demonstrate proficiency using each software application. The content of this text is driven the Microsoft Office User

Overview

The SELECT Lab Series uses a highly visual, project-based approach that teaches readers through tasks supported by step-by-step instruction, and extensive 4-color figures tat guide learners through the basic skills and procedures necessary to demonstrate proficiency using each software application. The content of this text is driven the Microsoft Office User Specialist (MOUS) guidelines. Students work through step-by-step instructions in three projects designed to integrate files and data among Word, Excel, Access, and PowerPoint. For anyone interested in becoming more proficient in Microsoft Office.

Product Details

ISBN-13:
9780201458985
Publisher:
Pearson Education
Publication date:
07/09/1999
Series:
Select Lab Series
Edition description:
Older Edition
Pages:
180
Product dimensions:
8.48(w) x 10.87(h) x 0.49(d)

Table of Contents

OVERVIEW OF WINDOWS
Overview of Windows
2(1)
Identifying the Desktop Elements
2(2)
Using a Mouse
4(2)
To Use the Mouse
5(1)
Using the Basic Features of Windows
6(2)
To Work with a Window
7(1)
Using Menus of Toolbars
8(3)
To Use Menus and Toolbars
9(2)
Working with Multiple Programs
11(1)
To Switch between Windows
11(1)
Getting Help
12(3)
To Use Help in Windows 95
12(1)
To Use Help in Windows 98
13(2)
Exiting Windows
15(1)
To Exit Windows
15(1)
Summary
16
COMMON ELEMENTS IN OFFICE 2000
Basic Common Elements
2(38)
Launching Applications
2(3)
Launching Microsoft Word 2000
5(1)
Performing Basic file Management Tasks
5(8)
Opening a Copy of a Document
7(5)
To Save a Copy of a File in a New Folder
12(1)
Changing File Properties
13(1)
Editing File Properties
13(1)
Using Help
14(6)
To Use of Office Assistant
15(3)
ToTurn of Office Assistant Off and On
18(2)
Selecting Printers and Printing
20(3)
To Select a Printer
20(3)
Existing Applications
23(1)
Summary and Exercises
24(16)
Common Text and Art Elements
40
Working with Text
27(7)
To Enhance and Format Text
29(3)
To Copy Text Formats Using the Format Painter
32(2)
Using Proofing Tools
34(3)
To Spell Check a File
35(1)
To Find and Replace Text
36(1)
Adding Art in Office 200
37(5)
To Insert Clip Art
37(2)
To Move and Size Clip Art Images
39(1)
To Create WordArt
40(2)
Creating and Manipulating Drawings
42(4)
To Create and Manipulate Drawings
42(2)
To Insert, Size, and Position File Images
44(2)
Summary and Exercises
46
EXCEL 2000
Introducing Excel 2000
2(1)
Worksheets and Workbooks
3(1)
Planning Excel Workbooks for Timely, Useful, and Accurate Information
4(3)
Launching Excel 2000
7(1)
To Launch Microsoft Excel
7(1)
The Excel, 2000 User Interface
8(2)
To Close Your Workbook and Exit Microsoft Excel
9(1)
Summary and Exercises
10(2)
Designing worksheets and Workbooks
12(32)
Designing a Workbook
14(1)
Navigating in a Workbook
15(3)
Entering Text in a Worksheet
18(2)
To Enter Text as Labels
18(2)
Filling in Data Based on Adjacent Cells
20(1)
To Use the Fill Handle to Complete a Data Series
20(1)
Adjusting Column Width and Entering Additional Text
21(3)
To Change the Width of Worksheet Columns
21(2)
To Enter Additional Text Labels and Adjust Column Width
23(1)
Saving Your Workbook
24(2)
To Create a Folder and Save Your Workbook
24(2)
Entering Numbers
26(2)
To Enter Numbers
27(1)
Creating Formulas
28(5)
To Enter Formulas Using a Variety of Methods
30(3)
Previewing and Printing Worksheets
33(2)
To Preview and Print Worksheets
33(2)
Closing Your Workbook
35(1)
To Save and Close Your Workbook
35(1)
Summary and Exercises
36(8)
Hands-On Exercises
40(2)
On Your Own Exercises
42(2)
Modifying Worksheets and Workbooks
44(30)
Opening an Excel Workbook
46(1)
To Open an Excel Workbook
46(1)
Woreking with Worksheets
47(1)
Editing a Workbook by Inserting Worksheets
48(3)
To Insert Worksheets into the Current Worksheet
48(1)
To Rename Worksheets
49(1)
To Delete a Worksheet
50(1)
Repositioning Worksheets in a Workbook
51(2)
To Change the Order of Worksheet Tabs
52(1)
Editing worksheet Data
53(1)
Editing Worksheets by Copying and Moving Data
53(6)
To Copy Ranges
53(3)
To Copy an Additional Range
56(1)
To Move Ranges
57(2)
Editing Worksheets by Revising Existing Data
59(1)
To Revise Existing Worksheet Data
59(1)
Entering Additional Text and Number Data
60(2)
To Enter Additional Text and Numeric Data
60(2)
Constructing Linking Formulas with 3-D References
62(3)
To Create Formulas Containing the SUM Function on Multiple Worksheets Simultaneously
62(1)
Creating 3-D References
63(2)
Entering Formulas to Sum the Sales Summary Data
65(2)
Creating Formulas to Sum the Sales Summary Data
66(1)
Summary and Exercises
67(7)
Hands-On Exercises
70(2)
On Your Own Exercises
72(2)
Formatting Worksheets and Workbooks
74(30)
About Worksheet Formats
77(1)
Formatting Numbers
77(1)
To Apply Number Formats
77(1)
Modifying Formats
78(1)
To Modifying Number Formats
78(1)
Copying Formats
79(1)
To Copy Cell Formats Using the Format Printer
79(1)
Applying Font Formats
80(3)
To Apply Font Formats and Change Cell Alignment
81(2)
Creating and Applying Styles
83(4)
Shading Worksheet Cells
84(1)
To Create and Apply Styles
85(2)
Working with Rows and Columns
87(3)
To Insert Columns into Worksheets
88(1)
To Add a Row to the Selected Worksheets and Resize the Row
89(1)
Adding Borders to Cells
90(2)
To Apply Borders to Selected Cells
90(2)
Applying Cell Formats to the Sales Summary Worksheet
92(3)
To Apply Cell Formats to the Sales Summary Worksheet
92(3)
using the Web Page Preview
95(2)
To Use Excel's Web Page Preview
95(1)
To Save the Workbook as HTML
96(1)
Summary and Exercises
97(7)
Hands-On Exercises
100(2)
On Your Own Exercises
102(2)
Creating More Complex Workbooks
104(34)
Naming Ranges
107(1)
To name Ranges
107(1)
Using Ranges to Select Data
108(1)
To Select Data Using a Range Name
108(1)
Using Range Names in Formulas
109(5)
To Use Range Names in Formulas
110(3)
To Create Additional formulas Using Range Names
113(1)
Using Logical Functions
114(1)
To Add an IF Function to Test Conditions
114(1)
Modifying the Page Setup of Worksheets
115(7)
To Change Worksheet Orientation
115(4)
To Add Headers and Footers to Worksheets
119(3)
Setting and Clearing Print Areas
122(2)
To Set and Clear Print Areas
112(12)
Setting Other Print Options
124(2)
To Set Print Options
124(2)
Summary and Exercises
126(12)
Hands-On Exercises EX
129(7)
Our Your Own Exercises
136(2)
Analyzing and Distributing Worksheet Data
138(38)
Using Charts to Analyze and Summarize Worksheet Data
141(1)
Creating Charts
142(9)
To Insert a Column Chart into the Workbook
142(5)
To Enter a Pie Chart into the Workbook
147(4)
Modifying Charts
151(3)
To Modify a Column Chart by Changing Its Properties
151(3)
Deleting Charts
154(2)
To Add a Chart to the Workbook and Then Delete It
155(1)
Previewing Charts
156(2)
To Preview Charts
156(2)
Printing Charts
158(1)
To Print Charts
158(1)
Adding Graphics to Workbooks
159(3)
To Add a Graphic to the Sales Summary Worksheet
159(3)
Publishing Workbooks to the Web
162(3)
To Publish Workbooks to the Web
162(1)
To View Excel Data on the Web
163(2)
Summary and Exercises
165(11)
Hands-On Exercises
168(6)
On Your Own Exercises
174(2)
Using Financial Functions
176(2)
Using Excel to Amortize a Loan
178(1)
Defining the Structure of the Amortization Schedule
179(1)
To Define the Structure of the Amortization Schedule
180(1)
To Apply Additional Formats to the Text Constants
181(2)
Entering Numeric Constants
183(1)
To Enter and Format Numeric Constants
183(2)
Calculating the Loan Payment Using Excel's PMT Function
185(1)
To Calculate the Loan Payment Using the PMT Function
185(1)
Calculating the Beginning Balance Using Excel's PV Function
186(1)
To Calculate the Beginning Balance Using the PV Function
186(1)
Calculating the Principal Paid in Each Payment Using Excel's PPMT Function
187(1)
To Calculate the Periodic Principal Payment Using the PPMT Function
188(1)
Calculating the Interest Paid in Each Payment Using the IPMT Function
189(1)
To Calculate the Periodic Interest Periodic Interest Payment
189(1)
Constructing Formulas to Calculate the Cumulative Principal, Cumulative Interest, Total Payments, and Ending Balance
190(1)
To Construct Formulas to Determine the Cumulative Interest, Cumulative Principal, Total Payments, and Ending Balance
190(1)
Using the Fill Handle to Complete the Amortization Schedule
191(1)
To Use the Fill Handle to Complete the Amortization Schedule
192(3)
Freezing Worksheet Panes to Assist in Viewing Large Worksheets
195(1)
To Freeze Worksheet Panes to Assist Viewing
195(3)
Changing the Loan Scenario
198(1)
To Change the Loan Scenario
198(1)
Summary and Exercises
199(3)
Hands-On Exercises
202(4)
On Your Own Exercises
206
Excel 2000 Function Reference Guide G-1
Glossary G-1
Index I-1

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >