BN.com Gift Guide

Dummies 101: 1-2-3 97 for Windows (with CD-ROM)

Overview

Of all the popular spreadsheet programs on the market, 1-2-3 is the most venerable. But it wouldn't have stood the test of time if it hadn't grown in features, power, and ease of use. Dummies 101: 1-2-3 97 For Windows is the perfect step-by-step, hands-on tutorial for anyone new to 1-2-3 or just new to this latest version. With simple-to-follow, real-world exercises capped off with fun quizzes and helpful summaries to reinforce what you've just learned, Dummies 101: 1-2-3 97 For Windows is your self-paced ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (6) from $1.99   
  • New (1) from $125.00   
  • Used (5) 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
$125.00
Seller since 2014

Feedback rating:

(193)

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.

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

Of all the popular spreadsheet programs on the market, 1-2-3 is the most venerable. But it wouldn't have stood the test of time if it hadn't grown in features, power, and ease of use. Dummies 101: 1-2-3 97 For Windows is the perfect step-by-step, hands-on tutorial for anyone new to 1-2-3 or just new to this latest version. With simple-to-follow, real-world exercises capped off with fun quizzes and helpful summaries to reinforce what you've just learned, Dummies 101: 1-2-3 97 For Windows is your self-paced classroom in a book. Plus, you get a bonus CD-ROM containing sample spreadsheets right out of the book; practice on those spreadsheets and see 1-2-3 in action just as you'll use it in the office or at home.
Read More Show Less

Product Details

  • ISBN-13: 9780764500046
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 3/28/1997
  • Series: Dummies 101 Series
  • Edition number: 1
  • Pages: 265
  • Product dimensions: 8.48 (w) x 9.96 (h) x 0.88 (d)

Table of Contents

Introduction

Who Are You?
Listen Up, Class!
Giving Commands
About This Book
How the Book Is Organized
Part I: Getting Comfortable with 1-2-3
Part II: Mastering the Basic Skills
Part III: Manipulating Your Data
Part IV: Adding Final Touches
Icons Used in the Book
About the CD-ROM
Installing the CD-ROM
Installing the CD-ROM files
After installing the files . . .
Accessing the CD-ROM files
Removing the CD-ROM files
Send Me E-Mail

Part I: Getting Comfortable with 1-2-3

Unit 1: Making a Simple Worksheet
Lesson 1-1: Running Lotus 1-2-3 for Windows 95
Starting 1-2-3
The 1-2-3 Window
Lesson 1-2: Building a Worksheet
Entering data
Calculating a sum
Lesson 1-3: Saving Your Work
Saving your workbook
Recess
Lesson 1-4: Printing the Worksheet
Lesson 1-5: Exiting 1-2-3
Closing the 1-2-3 window
Closing Windows 95
Recess
Unit 1 Quiz
Unit 1 Exercise
Unit 2: Improving Your Worksheet: Using Gadgets and Gizmos
Lesson 2-1: Controlling the 1-2-3 Window
Opening a workbook when you open 1-2-3
Changing the size of the 1-2-3 window
Lesson 2-2: Using Menus
Lesson 2-3: Using Dialog Boxes to Open and Save Workbook Files
Using the Open dialog box to open a workbook
Using the Save dialog box to save to a diskette
Recess
Lesson 2-4: Moving Around Worksheets That Are Bigger Than Your Screen
Using scroll bars to see a large worksheet
Pressing keys on the keyboard to move around the worksheet
Lesson 2-5: Getting Help
Using F1 to get help
Recess
Unit 2 Quiz
Unit 2 Exercise
Part I Review
Unit 1 Summary
Unit 2 Summary
Part I Test
Part I Lab Assignment
Step 1: Enter the labels
Step 2: Enter the data
Step 3: Calculate the totals
Step 4: Print the worksheet
Step 5: Close 1-2-3

Part II: Mastering the Basic Skills

Unit 3: Putting Data in Your Worksheets
Lesson 3-1: Selecting Cells
Lesson 3-2: Entering Data into Ranges
Entering data in a row
Entering date and time data into a block of cells
Lesson 3-3: Editing the Data You Have
Lesson 3-4: Copying and Moving Data
Moving data
Copying data
Recess
Lesson 3-5: Making More Data Out of the Data You Already Have
Filling in a pattern
Understanding drag-and-fill
Lesson 3-6: Adding and Deleting Rows and Columns
Adding a row
Deleting a column
Recess
Unit 3 Quiz
Unit 3 Exercise
Unit 4: Formatting Your Worksheets
Lesson 4-1: The Most Basic Formatting: Bold, Italic, and Underline
Lesson 4-2: Using Different Fonts and Font Sizes
Changing fonts and font sizes
Recess
Lesson 4-3: Formatting Numbers
Lesson 4-4: Aligning Numbers and Text
Lesson 4-5: Controlling Formatting by Using the Properties Dialog Box
Wrapping text to multiple lines
Centering a heading across columns
Lesson 4-6: Adjusting Column Width
Using the mouse to change the width of a column
Making the column fit the contents
Unit 4 Quiz
Unit 4 Exercise
Unit 5: Printing Your Sheets
Lesson 5-1: Viewing before You Print
Previewing a worksheet
Zooming in on the Preview
Lesson 5-2: Improving the Way the Worksheet Looks on Paper
Turning your paper
Changing margins
Recess
Lesson 5-3: Putting More on the Paper
Headers, footers, and page numbers
Printing row and column titles on every page
Lesson 5-4: Printing Only What You Want
Printing the whole worksheet
Printing a selection
Recess
Unit 5 Quiz
Unit 5 Exercise
Part II Review
Unit 3 Summary
Unit 4 Summary
Unit 5 Summary
Part II Test
Part II Lab Assignment
Step 1: Open the workbook
Step 2: Format the worksheet
Step 3: Print the worksheet
Step 4: Save and close

Part III: Manipulating Your Data

Unit 6: Creating Formulas
Lesson 6-1: Creating Formulas
Typing formulas
Creating formulas by pointing to cells
Lesson 6-2: Copying Formulas
Using cut and paste to copy formulas
Copying a formula with drag-and-fill
Recess
Lesson 6-3: Editing Formulas
Lesson 6-4: Using Absolute and Relative Cell References in Formulas
Using absolute cell references in formulas
Recess
Unit 6 Quiz
Unit 6 Exercise
Unit 7: Making More Formulas: Functions and Named Ranges
Lesson 7-1: Using Functions
Using simple functions
Finding functions on the @Function List dialog box
Using functions with multiple arguments
Lesson 7-2: Naming Your Data
Naming a range
Finding a named range
Lesson 7-3: Using Named Ranges in Formulas
Unit 7 Quiz
Unit 7 Exercise
Unit 8: Managing Multiple Worksheets
Lesson 8-1: Creating, Naming, and Moving Around Multiple Worksheets
Lesson 8-2: Viewing More Than One Worksheet
Splitting the worksheet window by using the menu
Splitting the worksheet window by using the splitters
Recess
Lesson 8-3: Making Use of Multiple Worksheets
Copying from one worksheet to another
Referencing cells on other worksheets in formulas
Unit 8 Quiz
Unit 8 Exercises
Part III Review
Unit 6 Summary
Unit 7 Summary
Unit 8 Summary
Part III Test
Part III Lab Assignment
Step 1: Writing formulas using arithmetic
Step 2: Writing formulas using functions
Step 3: Calculate the grand total
Step 4: Write a formula that refers to values on other worksheets
Step 5: Save your work

Part IV: Adding Final Touches

Unit 9: Illustrating Your Data with Charts
Lesson 9-1: Creating a Chart
Lesson 9-2: Changing Chart Type
Changing the chart type with SmartIcons
Changing the type of chart with the Properties for: Chart dialog box
Lesson 9-3: Editing Charts
Editing text on a chart
Sizing and moving a chart
Lesson 9-4: Printing Charts
Printing a worksheet with a chart
Printing only the chart
Unit 9 Quiz
Unit 9 Exercise
Unit 10: Advanced Techniques for Formatting Your Data
Lesson 10-1: Jazzing Up Worksheets with Style Templates
Lesson 10-2: Using Borders and Shading
Turning grid lines on and off
Shading worksheet ranges
Creating lines with borders
Recess
Unit 10 Quiz
Unit 10 Exercise
Unit 11: 1-2-3 Tricks
Lesson 11-1: Sorting Your Data
Lesson 11-2: Finding and Replacing
Finding eggs
Replacing newspapers
Recess
Lesson 11-3: Checking Spelling
Unit 11 Quiz
Unit 11 Exercise
Part IV Review
Unit 9 Summary
Unit 10 Summary
Unit 11 Summary
Part IV Test
Part IV Lab Assignment
Step 1: Create a chart
Step 2: Add borders and shading
Step 3: Sort the table
Step 4: Check spelling
Step 5: Save your work
Appendix A: Answers
Part I Test Answers
Part II Test Answers
Part III Test Answers
Part IV Test Answers
Appendix B: About the CD
System Requirements
What's on the CD
Putting the CD Files on Your Hard Drive
Installing the files
After installing the files . . .
Accessing the CD files
Removing the CD files

Index

IDG Books Worldwide, Inc. End-User License Agreement

Dummies 101 CD-ROM 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)