Dummies 101: Excel 97 for Windows (with CD-ROM)

Overview

You don't have to spend weeks taking an expensive class to learn how to use Excel 97 for Windows. Dummies 101: Excel 97 For Windows takes you step by step though all the essentials of using this popular and powerful spreadsheet program in the office, at home, or in class. Self-paced and punctuated with fun quizzes and summaries to help reinforce what you've learned, Dummies 101: Excel 97 For Windows reveals how to . . .
  • Create your own Excel ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (11) from $1.99   
  • New (1) from $34.49   
  • Used (10) 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
$34.49
Seller since 2014

Feedback rating:

(273)

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 Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

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

Overview

You don't have to spend weeks taking an expensive class to learn how to use Excel 97 for Windows. Dummies 101: Excel 97 For Windows takes you step by step though all the essentials of using this popular and powerful spreadsheet program in the office, at home, or in class. Self-paced and punctuated with fun quizzes and summaries to help reinforce what you've learned, Dummies 101: Excel 97 For Windows reveals how to . . .
  • Create your own Excel spreadsheet and use or adapt spreadsheets created by others
  • Transform worksheets and workbooks of dull data into informative, colorful charts that bring home your point
  • Build and manage databases right in Excel
  • Even generate Web pages from your Excel spreadsheet for publication on the Internet or your organization's intranet

Plus, Dummies 101: Excel 97 For Windows comes complete with a companion CD. On it, you'll not only find sample files to use with the book's exercises but also find Microsoft's Internet Explorer Web browsing software and AT&T WorldNetSM Service for instant dial-up access to the Internet.

This handy, easy-to-use tutorial provides hands-on learning for any user in the . . . For Dummies tradition. Users will get the instruction they need to actually learn how to use this spreadsheet. Progress checks help the reader decide if he is ready to move on to the next task. The CD contains document files to be used in conjunction with the lessons.

Read More Show Less

Product Details

  • ISBN-13: 9780764500961
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 2/11/1997
  • Series: Dummies 101 Series
  • Edition number: 1
  • Pages: 272
  • Product dimensions: 8.49 (w) x 9.98 (h) x 0.84 (d)

Table of Contents

Introduction

Using This Book
A Word about Doing the Exercises
Special Icons and Features in the Book
Getting Started: What You Need to Do

Part I: Creating the Spreadsheet

Unit 1: Entering the Spreadsheet Data
Lesson 1-1: Starting Excel and Opening a New Workbook
Exercise 1-1: Starting Excel from the Taskbar
Starting Excel from the Microsoft Office Shortcut Bar
Starting Excel by creating an Excel shortcut
Exercise 1-2: Creating an Excel shortcut
Starting Excel by opening an existing workbook
Opening a new workbook within Excel
Exercise 1-3: Opening a bunch of blank workbooks
Exercise 1-4: Switching between the open workbooks
Closing workbooks
Exercise 1-5: Closing up the open workbooks
Using the Office Assistant
Exercise 1-6: Getting help from the Office Assistant
Lesson 1-2: Moving the Cell Pointer
Moving the cell pointer with the mouse
Exercise 1-7: Changing the active cell with the mouse
Scrolling the worksheet
Scrolling with IntelliMouse
Exercise 1-8: Selecting cells in hidden parts of the worksheet
Moving the cell pointer with the keyboard
Exercise 1-9: Using the keyboard to move one cell at a time
Exercise 1-10: Using the keyboard to make larger moves
Moving the cell pointer with the Go To feature
Exercise 1-11: Making a cell active with Go To
Moving between the sheets of the workbook
Lesson 1-3: Adding Data to a Cell
Exercise 1-12: Entering the title for the spreadsheet
Exercise 1-13: Entering the headings for the sales table
Entering numeric data in a spreadsheet
Entering dates and times
Exercise 1-14: Entering the values in the sales table
Lesson 1-4: Calculating Values with Formulas
Exercise 1-15: Totaling values with AutoSum
Copying cell entries with the fill handle
Exercise 1-16: Copying SUM formulas with the fill handle
Introducing the Formula Palette
Exercise 1-17: Entering functions with the Formula Palette
Lesson 1-5: Saving Your Sales Spreadsheet
Exercise 1-18: Saving your sales table spreadsheet
Recess
Lesson 1-6: Using AutoFill to Enter a Data Series
Exercise 1-19: Creating a simple data series
Exercise 1-20: Creating a more complex data series
Exercise 1-21: Creating a custom AutoFill list
Unit 1 Quiz
Unit 2: Formatting the Spreadsheet
Lesson 2-1: Opening the Workbook for Formatting
Exercise 2-1: Changing the default file location
Exercise 2-2: Opening your MGE Quarterly Sales workbook
Lesson 2-2: Widening Columns and Rows
Exercise 2-3: Adjusting the column width with AutoFit
Exercise 2-4: Adjusting the column width with AutoFit Selection
Exercise 2-5: Adjusting the column width manually
Exercise 2-6: Adjusting the row height
Lesson 2-3: Formatting Cells from the Formatting Toolbar
Exercise 2-7: Indenting Total row headings on a P&L statement
Exercise 2-8: Changing the font and font size of the table headings
Exercise 2-9: Changing the alignment of the table headings
Exercise 2-10: Applying number formats to the sales figures
Exercise 2-11: Using borders and color in the sales table
Lesson 2-4: Formatting Cells from the Format Cells Dialog Box
Exercise 2-12: Changing the text wrap, vertical alignment, and orientation of cell entries
Exercise 2-13: Formatting column heading orientation
Exercise 2-14: Applying the Special number format
Lesson 2-5: Using AutoFormat on a Table of Data
Exercise 2-15: Using AutoFormat on the MGE 1st Quarter 1997 Sales table
Recess
Unit 2 Quiz
Unit 3: Printing the Spreadsheet
Lesson 3-1: Printing Spreadsheet Data
Exercise 3-1: Previewing the page layout
Exercise 3-2: Printing the worksheet with the Print button
Exercise 3-3: Printing the worksheet with the Print command
Exercise 3-4: Printing the entire workbook
Exercise 3-5: Printing selected worksheets
Exercise 3-6: Printing a range of cells in a worksheet
Lesson 3-2: Adding Headers, Footers, and Print Titles to a Report
Exercise 3-7: Modifying the default header and footer
Exercise 3-8: Adding a custom header and footer to a report
Exercise 3-9: Adding column headings as print titles
Exercise 3-10: Adding row headings as print titles
Lesson 3-3: Changing the Print Settings for a Report
Exercise 3-11: Centering the printing and changing the margins
Exercise 3-12: Adding manual page breaks to a report using Page Break Preview
Recess
Unit 3 Quiz
Part I Review
Unit 1 Summary
Unit 2 Summary
Unit 3 Summary
Part I Test
Part I Lab Assignment
Step 1: Creating the MGE 1st Quarter 1999 projected sales worksheet
Step 2: Formatting the MGE 1st Quarter 1999 projected sales worksheet
Step 3: Printing the MGE 1st Quarter sales worksheets

Part II: Modifying the Spreadsheet

Unit 4: Working with Cell Ranges
Lesson 4-1: Selecting Cell Ranges
Making cell selections with the mouse
Making cell selections with the keyboard
Exercise 4-1: Selecting cell ranges with the mouse
Exercise 4-2: Selecting cell ranges with the keyboard
Exercise 4-3: Selecting a cell range with Go To
Lesson 4-2: Using AutoCalculate
Exercise 4-4: Calculating totals on the fly with AutoCalculate
Lesson 4-3: Naming Cell Ranges
Exercise 4-5: Creating the retail price table
Exercise 4-6: Defining the markup constant for the retail price table
Exercise 4-7: Defining cell range names in the retail price table
Exercise 4-8: Creating range names from column and row headings
Exercise 4-9: Selecting various named ranges in the price table
Exercise 4-10: Applying column and row names to formulas
Exercise 4-11: Using Natural Formulas
Lesson 4-4: Copying and Moving Cell Ranges
Exercise 4-12: Copying and moving cell ranges with drag and drop
Exercise 4-13: Copying and moving cells with cut and paste
Exercise 4-14: Using Paste Special
Unit 4 Quiz
Unit 5: Editing the Spreadsheet
Lesson 5-1: Editing Data Entries
Exercise 5-1: Revising data entries in their cells
Exercise 5-2: Revising data entries on the formula bar
Exercise 5-3: Clearing cells of their data entries and using Undo/Redo
Lesson 5-2: Locating the Areas that Need Editing
Exercise 5-4: Zooming in and out on a worksheet
Exercise 5-5: Freezing panes as worksheet titles
Exercise 5-6: Dividing the worksheet into panes
Lesson 5-3: Inserting and Deleting Cell Ranges
Exercise 5-7: Deleting cells
Exercise 5-8: Inserting new cells
Lesson 5-4: Adding Notes to Cells
Exercise 5-9: Creating and selecting text notes in cells
Lesson 5-5: Finding and Replacing Data
Exercise 5-10: Finding data entries in the worksheet
Exercise 5-11: Replacing data entries in the worksheet
Lesson 5-6: Checking the Spelling of Spreadsheet Data
Exercise 5-12: Spell checking the worksheet
Lesson 5-7: Editing Worksheets in a Workbook
Exercise 5-13: Renaming worksheets
Exercise 5-14: Adding and deleting worksheets
Exercise 5-15: Rearranging the worksheets in a workbook
Exercise 5-16: Totaling the worksheets in a workbook
Exercise 5-17: Copying worksheets from different workbooks into a single, new workbook
Unit 5 Quiz
Part II Review
Unit 4 Summary
Unit 5 Summary
Part II Test
Part II Lab Assignment
Step 1: Copying the 1997 Mother Hubbard Dog Goodies income statement into the MGE 97 P&Ls workbook
Step 2: Adding a new worksheet to the MGE 97 P&Ls (totals) workbook
Step 3: Totaling the income statements in the MGE 97 P&Ls (totals) workbook

Part III: Beyond the Spreadsheet

Unit 6: Charting Spreadsheet Data
Lesson 6-1: Creating Charts
Exercise 6-1: Creating a chart with the Chart Wizard
Exercise 6-2: Creating a chart on its own Chart Sheet
Lesson 6-2: Editing a Chart
Exercise 6-3: Resizing the Chart Titles and Legend
Exercise 6-4: Formatting the plot area and changing the orientation of the data series
Lesson 6-3: Printing Charts
Exercise 6-5: Printing the embedded chart alone and with its spreadsheet data
Exercise 6-6: Printing the Q1 97 Chart sheet
Unit 6 Quiz
Unit 7: Building and Maintaining a Database
Lesson 7-1: Creating a Database
Exercise 7-1: Creating the field names for a new database
Exercise 7-2: Entering and formatting the first record in the Address Database
Lesson 7-2: Adding Records to the Database
Exercise 7-3: Adding a record with the data form
Exercise 7-4: Adding a record directly to the database table
Lesson 7-3: Editing the Database Records
Exercise 7-5: Moving from record to record in the database
Exercise 7-6: Locating the records with the Criteria form
Exercise 7-7: Modifying field entries within records
Exercise 7-8: Deleting records from the database
Lesson 7-4: Sorting the Records in a Database
Exercise 7-9: Sorting the Client List alphabetically
Exercise 7-10: Sorting the Client List by anniversary date
Exercise 7-11: Sorting the Client List by city, state, and zip code
Lesson 7-5: Selecting the Records in a Database
Exercise 7-12: Filtering the Client List with AutoFilter
Exercise 7-13: Filtering the Client List with an either/or Custom AutoFilter
Exercise 7-14: Filtering a range of values with Custom AutoFilter
Unit 7 Quiz
Unit 8: Using Hyperlinks and Adding Excel Data to Web Pages
Lesson 8-1: Adding Hypertext Links
Exercise 8-1: Creating a cover worksheet for the hypertext links
Exercise 8-2: Adding hypertext links to the cell entries
Exercise 8-3: Testing the hypertext links
Lesson 8-2: Adding Hyperlinks to Graphics
Exercise 8-4: Inserting a graphic image to use as a hyperlink
Exercise 8-5: Adding the hyperlink to the imported graphic image
Exercise 8-6: Copying the graphic hyperlink to the other worksheets
Lesson 8-3: Creating Hyperlinks that Open Other Office Documents
Exercise 8-7: Creating a hypertext link to a Word 97 document
Exercise 8-8: Testing the hyperlink to the Word 97 document
Exercise 8-9: Editing a hypertext link
Lesson 8-4: Creating Hyperlinks to Web Pages
Exercise 8-10: Adding a hyperlink to the mind over media Web site
Recess
Lesson 8-5: Outputting Worksheet Data and Charts to Web Documents
Exercise 8-11: Adding worksheet data and a chart to a new HTML document
Exercise 8-12: Viewing the HTML document with your Web browser
Exercise 8-13: Adding worksheet data to an existing HTML document
Unit 8 Quiz
Part III Review
Unit 6 Summary
Unit 7 Summary
Unit 8 Summary
Part III Test
Part III Lab Assignment
Step 1: Creating an embedded 3-D pie chart for the 1997 projected sales data
Step 2: Creating a 3-D bar chart on its own sheet for the 1997 projected sales data
Step 3: Sorting and filtering the Client List in the Bo-Peep Client List workbook
Appendix A: Answers
Unit 1 Quiz Answers
Unit 2 Quiz Answers
Unit 3 Quiz Answers
Part I Test Answers
Unit 4 Quiz Answers
Unit 5 Quiz Answers
Part II Test Answers
Unit 6 Quiz Answers
Unit 7 Quiz Answers
Unit 8 Quiz Answers
Part III Test Answers
Appendix B: About the CD

Index

Coupon

Disc License Agreement

Installation Instructions

Reader Response Card

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)