Microsoft Excel 2002 Fast and Easy

Overview

Relax. Learning how to use Excel 2002 is now a breeze. With this book's easy to understand instructions, you'll be building professional-looking worksheets in no time. From the basics of creating a new workbook and using toolbars to the exciting new features of Excel 2002 like creating your own templates and collaborating online, this book has everything you need to master the latest version of Excel.
Read More Show Less
... See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (13) from $1.99   
  • New (2) from $59.99   
  • Used (11) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$59.99
Seller since 2007

Feedback rating:

(17)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New Book: Ships F A S T !!!! : 2 to 4 Business days to deliver to most locations within Continental USA if you pay EXPEDITED SHIP Option.

Ships from: Phoenix, AZ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$60.00
Seller since 2015

Feedback rating:

(215)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Relax. Learning how to use Excel 2002 is now a breeze. With this book's easy to understand instructions, you'll be building professional-looking worksheets in no time. From the basics of creating a new workbook and using toolbars to the exciting new features of Excel 2002 like creating your own templates and collaborating online, this book has everything you need to master the latest version of Excel.
Read More Show Less

Editorial Reviews

Booknews
This introduction to the Excel spreadsheet program shows how to create and edit worksheets, apply formulas, work with templates, format numbers and cells, add clipart, generate a chart, and integrate Excel with other programs. Abundant screenshots of example worksheets illustrate the concepts. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780761533986
  • Publisher: Premier Press
  • Publication date: 4/1/2002
  • Series: Fast and Easy Series
  • Pages: 368
  • Product dimensions: 7.39 (w) x 9.13 (h) x 0.78 (d)

Table of Contents

Introduction xix
Part I Building Your First Worksheet 1
Chapter 1 Welcome to Excel 2002 3
Starting Excel 4
Entering Text and Numbers 5
Moving Between Cells 7
Entering a Formula 7
Playing "What If?" 9
Chapter 2 What's on the Excel Screen? 11
Using Menus 12
Understanding Menu Items 13
Using Shortcut Menus 14
Using Toolbars 15
Using Lists on Toolbars 15
Working with Dialog Boxes 16
Using the Task Pane 18
Displaying Different Task Panes 18
Working with the Status Bar 19
Displaying Hiding On-Screen Controls 20
Changing How Menus and Toolbars Work 21
Moving Around the Screen with Scroll Bars 22
Getting Help 22
Chapter 3 Saving, Printing and Exiting Excel 25
Saving Your Work 26
Changing the Save Location 28
Printing a Worksheet 29
Printing with the Print Button 29
Printing with the Print Dialog Box 29
Exiting Excel 31
Chapter 4 Managing Workbooks and Worksheets 33
Creating a New Workbook 34
Moving Between Workbooks 35
Viewing Multiple Workbooks 35
Closing a Workbook 37
Opening an Existing Workbook 38
Opening a Recently Used File 38
Opening a File with the Open Dialog Box 39
Opening a File from Another Location 40
Working with Worksheets 41
Naming a Worksheet 41
Adding Worksheets to a Workbook 42
Deleting a Worksheet 43
Part I Review Questions 44
Part II Constructing Larger Worksheets 45
Chapter 5 Editing Worksheets 47
Selecting Cells 48
Editing Cell Content 49
Replacing Cell Content 50
Removing Cell Content 50
Adding Rows and Columns 51
Oops!--Using Undo and Redo 52
Undoing Multiple Actions 52
Moving Data 53
Copying Data 54
Using Clipboard Copy Options 55
Specifying Paste Options 56
Using the Clipboard Task Pane 57
Using Drag and Drop 58
Filling a Range 59
Filling with a Series 60
Transposing Cells 61
Adjusting Column Width and Row Height 63
Resizing a Column to Fit 64
Setting a Specific Column Width 65
Checking Your Spelling 66
Chapter 6 Using Formulas and Functions 69
Entering a Simple Calculation 70
Using Built-In Functions 71
Using the Formula Palette with the SUM Function 72
Using AutoSum 75
Creating an IF Function 76
Copying Formulas with Relative and Absolute References 79
Using AutoCalculate 83
Inserting Today's Date 83
Some Common Mistakes to Avoid 85
Chapter 7 Navigating Your Worksheets 87
Naming a Range 88
Moving Directly to a Cell or Range 90
Finding and Replacing Cell Entries 91
Finding Cell Entries 91
Replacing Cell Entries 93
Viewing Different Parts of Your Worksheet at the Same Time 94
Hiding Rows and Columns 94
Displaying Hidden Rows or Columns 96
Splitting a Window 98
Removing a Split 99
Keeping Row or Column Labels Visible 99
Removing the Freeze 100
Chapter 8 Working with Data 101
Sorting Data 102
Sorting the Order of Rows in a Range 102
Sorting the Order of Columns in a Range 106
Filtering Data 108
Turning Off AutoFilter 110
Chapter 9 Working with Templates 111
Creating a New Workbook with a Template 112
Modifying a Template 113
Modifying the Default Workbook Settings 116
Chapter 10 Exploring Print Options 121
Setting Paper Size and Orientation 122
Setting Margins 124
Adding Headers and Footers 125
Selecting Rows and Columns to Appear on Every Page 128
Setting the Print Area 131
Clearing the Print Area 132
Previewing Your Worksheet 132
Zooming 133
Adjusting Margins 134
Previewing Page Breaks 135
Closing Page Break Preview 136
Printing Your Worksheet 137
Part II Review Questions 138
Part III Making Your Data Look Good 139
Chapter 11 Formatting Text 141
Using AutoFormat 142
Removing AutoFormat 143
Using Fonts 145
Adding Bold, Italic, and Underline 146
Aligning Your Text 148
Centering a Heading Over More Than One Column 148
Other Alignment Options 149
Copying Text Formatting 151
Chapter 12 Formatting Numbers and Cells 153
Applying Number Formatting 154
Formatting Currency 154
Formatting Percentages 155
Adding and Removing Decimal Places 156
Formatting Dates 157
Applying Borders 160
Applying Colors and Patterns 162
Adding a Background Color 162
Adding a Pattern 163
Part III Review Questions 166
Part IV Adding Pictures and Charts 167
Chapter 13 Adding Clip Art and WordArt to a Worksheet 169
Adding Clip Art 170
Opening the Clip Art Controls 170
Searching for a Clip Art Image 171
Adjusting then Size and Location of Clip Art 174
Adjusting the Size of Clip Art 174
Moving the Clip Art Image 176
Adjusting the Quality of the Picture 177
Inserting a Picture from a File 178
Cropping an Image 179
Adding WordArt 181
Changing the Look of Your WordArt 183
Rotating WordArt 183
Changing the WordArt Shape 185
Editing WordArt Text 185
Chapter 14 Generating a Chart 187
Creating a Chart with the Chart Wizard 188
Changing the Chart Type 194
Changing How the Data Is Plotted 195
Changing Which Cells Are Plotted 196
Chapter 15 Formatting Your Chart 199
Making Labels Easier to Read 200
Changing Label Size and Color 200
Rotating Label Text 202
Adding Data Labels 203
Moving Labels 205
Resizing the Legend 205
Displaying or Hiding the Legend 206
Displaying or Hiding a Data Table 207
Formatting Chart Elements 207
Changing Series Colors 208
Setting a Number Format for an Axis 209
Part IV Review Questions 212
Part V Sharing with other Programs and People 213
Chapter 16 Integrating Excel with Word 215
Creating an Excel Worksheet from within Word 216
AutoFormatting an Embedded Worksheet 219
Inserting Rows or Columns in an Embedded Worksheet 221
Inserting an Existing Excel Worksheet into Word 223
Linking a Part of an Existing Excel Sheet 225
Importing Word Data into Excel 229
Chapter 17 Integrating Excel with Access 231
Importing Excel Data into Access 232
Beginning a Data Import from Excel to Access 232
Importing Excel Data as a New Table 235
Appending Excel Data to an Existing Table 240
Linking an Excel Worksheet to Access 242
Exporting an Access Table or Query to Excel 246
Chapter 18 Using Excel to Analyze Data from the Web 249
Opening Web Documents in Excel 250
Copying Data from a Web Page 252
Creating a Simple Web Query 255
Creating a Multi-Table Web Query 256
Starting a Web Query from a Web Page 256
Starting a Web Query from Excel 257
Refreshing a Web Query 259
Saving a Web Query 260
Running a Saved Web Query 262
Chapter 19 Sharing Excel Data on the Internet 265
Inserting a Hyperlink 266
Inserting an E-Mail Link 271
Saving the Worksheet for the Web 273
Setting More Publishing Options 277
Sharing Excel Data via E-Mail 281
Including Excel Data in an E-Mail Message Body 281
Attaching an Excel Workbook to an E-Mail Message 284
Chapter 20 Collaborating with Others 285
Working with Comments 286
Editing a Comment 287
Deleting a Comment 288
Working with Revisions 289
Tracking Revisions 289
Examining Tracked Revisions 291
Accepting or Rejecting Revisions 291
Sharing a Workbook 293
Protecting Your Data 295
Protecting a Worksheet 295
Removing Password Protection from Worksheets 298
Protecting Your Workbook 299
Removing Password Protection from Workbooks 300
Preventing Your Workbook from Being Opened 301
Protecting Only Certain Cells 304
Part V Review Questions 306
Part IV Appendixes 307
Appendix A Installing Excel 309
Installing the Software 310
Choosing Components 314
Working with Maintenance Mode 314
Adding and Removing Components 315
Repairing or Reinstalling Office 318
Removing Office from Your PC 319
Appendix B Using Keyboard Shortcuts 320
Working with Menus 321
Opening Dialog Boxes 321
Moving Around in a Worksheet or Workbook 322
Typing Data into Cells 322
Applying Number Formats 323
Formatting Data 323
Getting Help 323
Selecting Ranges of Cells 324
Cutting, Copying, and Pasting 324
Glossary 325
Index 331
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)