Quick, Simple Microsoft Excel 2000 / Edition 1

Quick, Simple Microsoft Excel 2000 / Edition 1

by Linda Ericksen
     
 

ISBN-10: 0130813338

ISBN-13: 9780130813336

Pub. Date: 06/07/1999

Publisher: Pearson

Product Details

ISBN-13:
9780130813336
Publisher:
Pearson
Publication date:
06/07/1999
Edition description:
SPIRAL
Pages:
240
Product dimensions:
8.27(w) x 10.87(h) x 4.33(d)

Table of Contents

Preface vii
UNIT 1 Getting Started 1(32)
Starting Microsoft Excel 2000
2(1)
Becoming Familiar with the Excel Interface
3(7)
Worksheets and Workbooks
4(1)
Title Bar
4(1)
Menu Bar
4(3)
Toolbars
7(1)
Worksheet
8(1)
Formula Bar
9(1)
Status Bar
9(1)
Windows Taskbar
9(1)
Getting Help
10(4)
Moving Around a Worksheet
14(2)
Creating a Worksheet Using Text, Numbers, and the AutoSum Function
16(4)
Saving a Workbook
20(3)
Choosing a File Name
21(1)
Choosing a Drive and Folder
22(1)
Printing a Worksheet
23(2)
Exiting from Excel
25(1)
Opening and Closing Workbooks
26(2)
Review
28(5)
Summary
28(1)
Key Terms
28(1)
Test Your Skills
29(2)
Projects
31(2)
UNIT 2 Working with Workbooks 33(37)
Creating a New Workbook and Entering Data in a Series
34(2)
Creating Formulas
36(6)
Creating a Formula by Typing It
37(1)
Creating a Formula by Selecting Cells
38(1)
The Order of Operations
38(4)
Specifying Ranges with AutoSum
42(3)
Ranges
42(1)
The Syntax of a Function
43(1)
Using AutoSum
43(2)
Editing Worksheets
45(6)
Editing Cell Contents
46(1)
Deleting Cell Contents
46(1)
Undoing an Action
47(1)
Inserting and Deleting Rows and Columns
48(3)
Checking Spelling in the Worksheet
51(2)
Using the Page Setup Dialog Box
53(5)
Page Tab
53(1)
Margins Tab
54(1)
Header/Footer Tab
55(1)
Sheet Tab
56(2)
Viewing and Printing Formulas
58(1)
Copying and Moving Data
59(5)
Copying by Filling
59(2)
Moving by Dragging
61(1)
Copying or Moving Using the Clipboard
61(3)
Review
64(6)
Summary
64(1)
Key Terms
65(1)
Test Your Skills
65(2)
Projects
67(3)
CHECK POINT for Units 1-2 70(3)
UNIT 3 Formatting the Worksheet 73(28)
Using AutoFormat
74(2)
Using Bold, Italic, and Underline
76(2)
Formatting Text Using the Font Dialog Box
78(2)
Formatting Numbers
80(3)
Changing Column Widths
83(3)
Using the Menus
84(1)
Using the Mouse
84(2)
Aligning Data in Cells
86(3)
Using the Menu
86(2)
Using the Toolbar
88(1)
Adding a Border and Shading
89(3)
Adding a Border Using the Menu
90(1)
Adding a Border Using the Toolbar
90(1)
Adding Shading and Patterns
91(1)
Adding a Graphic
92(3)
Review
95(6)
Summary
95(1)
Key Terms
95(1)
Test Your Skills
95(2)
Projects
97(4)
UNIT 4 Using Functions and Other Calculations 101(23)
Using the MIN Function
102(3)
The Paste Function Dialog Box
102(1)
The Formula Palette
103(1)
Constructing the MIN Function
103(2)
Using the MAX Function
105(1)
Using the AVERAGE Function
106(2)
Using Auto Calculate
108(1)
Using the PRODUCT Function
109(2)
Copying Functions and Formulas
111(3)
Using Edit | Fill
111(1)
Using the Fill Handle
111(1)
Relative Cell References
112(2)
Using Absolute Cell References
114(3)
Performing What-If Analysis
117(1)
Review
118(6)
Summary
118(1)
Key Terms
118(1)
Test Your Skills
119(2)
Projects
121(3)
CHECK POINT for Units 3-4 124(3)
UNIT 5 Using Financial Functions 127(16)
Using the PMT Function
128(4)
Constructing the Function
129(3)
Using the PPMT Function
132(2)
Using the IPMT Function
134(1)
Using the FV Function
135(2)
Using the SLN Function
137(1)
Review
138(5)
Summary
138(1)
Key Terms
138(1)
Test Your Skills
139(1)
Projects
140(3)
UNIT 6 Using Date, Count, and IF Functions 143(16)
Using the TODAY Function
144(2)
Using the IF Function
146(4)
Using the SUMIF Function
150(1)
Using the COUNT, COUNTA, and COUNTBLANK Functions
151(2)
Using the COUNTIF Function
153(1)
Review
154(5)
Summary
154(1)
Key Terms
154(1)
Test Your Skills
154(2)
Projects
156(3)
CHECK POINT for Units 5-6 159(2)
UNIT 7 Working with Multiple Worksheets 161(20)
Inserting, Deleting, and Selecting Worksheets
162(2)
Renaming Worksheets
164(1)
Moving and Copying Worksheets
165(4)
Using the Menus
165(1)
Using the Mouse
166(1)
Why Copy?
167(2)
Calculating Between Sheets
169(3)
Creating a Consolidation Worksheet
172(1)
Review
173(8)
Summary
173(1)
Key Terms
174(1)
Test Your Skills
174(1)
Projects
175(6)
UNIT 8 Using Excel with Charts, Word, and the Web 181(24)
Creating Charts
182(7)
Chart Elements and Types
183(1)
Creating a Chart
184(5)
Enhancing a Chart
189(2)
Copying Worksheet Data to a Microsoft Word Document
191(2)
Linking Worksheet Data to a Microsoft Word Document
193(3)
Linking to the World Wide Web
196(3)
Saving a Workbook as a Web Document
199(2)
Review
201(4)
Summary
201(1)
Key Terms
201(1)
Test Your Skills
201(2)
Projects
203(2)
CHECK POINT for Units 7-8 205(2)
WRAP-UP 207(8)
APPENDIX A
Alphabetized List of Tasks
209(2)
APPENDIX B
Toolbars and Buttons
211(4)
Glossary 215(3)
Index 218

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >