1-2-3 97 for Windows for Dummies Book

Introduction

What This Book Covers

Why I Wrote This Book

Read the Whole Thing?

How This Book Is Organized

Part I: Introducing 1-2-3 97

Part II: Getting Busy

Part III: Saving, Printing, and Creating New Sheets

Part IV: Making Yourself at Home

Part V: Expanding Your Horizons

Part VI: The Part of Tens

Glossary

Foolish Assumptions

Conventions -- Typographical and Otherwise

Of mice and menus

I think icon, I think icon

Now What?

Part I: Introducing 1-2-3 97

Chapter 1: So You Want to Use 1-2-3?

OK, So What Is 1-2-3?

But Is 1-2-3 Any Good?

What Can This Puppy Do?

Crunch some numbers

Create killer charts

Map your data geographically

Organize your lists

Manage that data (zzzz . . .)

Access other data

Automate actions with scripts

And into the great beyond . . .

What Can't 1-2-3 Do?

Excursions into Versions

What's New in 1-2-3 97?

Chapter 2: Jumping Right In (And Out)

Starting 1-2-3

Starting 1-2-3 from the Start button

Starting 1-2-3 from the SmartCenter menu

The Screen Tour (It's the Law)

Switching out of 1-2-3

Quitting 1-2-3

The right way to quit

The wrong way

Chapter 3: Your Wish Is 1-2-3's Command

Perusing the Main Menu

Using the main menu

What menus are good for

Other Types of Menus

Shortcut menus

Control menus

A Meaningful Dialog

The anatomy of a dialog box

Mousing through dialog boxes

If you prefer the keyboard

Introducing the InfoBox

It changes!

Click a tab, any tab

Getting InfoBox help

Part II: Getting Busy

Chapter 4: Filling Those Cells with Numbers, Text, and Other Stuff

Rows, Columns, Cells, and Sheets

Gimme your address

Point the way

Move it along

Ready, Set, Type

Minding your modes

Filling your cells

Entering a number

Entering text

Fitting a big entry into a small cell

Changing the way the Enter key works

Dressing Up Your Entries

Making numbers look right

Aligning text and numbers

Changing Your Work

Overwriting a cell

Editing a cell

Nuking a cell completely

Chapter 5: Formulas: Not Just for Babies Anymore

Formulas Defined

Hello, Operator?

Using parentheses in formulas

A formula with two answers

How 1-2-3 copes with ambiguity

The thing about formulas

No comment

Entering Formulas into Cells

Relative and Absolute References

It's all relative

Absolutely absolute

. . . And it gets even uglier: mixing absolute and relative references

Where Are the Formulas?

Controlling Recalculation

Other Types of Formulas

Chapter 6: Creating Functional Formulas

@Functions @Work

Okay, what is an @function?

A functional example

Cells and ranges

Adding sheets to cell references

Using @Functions

Having an argument

Entering @functions: two ways

Editing @functions

Insert @function here, Insert @function here!

@function categories

Numerical @Functions Examples

@MAX

@MIN

@SQRT

@ROUND

Date and Time @Function Examples

@DATE

@TODAY

@TIME

Using @Functions in Formulas

@functions inside of @functions

Testing conditions

What Shall We Name It?

A named cell example

A named range example

Naming cells and ranges

Chapter 7: Making Changes to Your Work (And Living to Tell about It)

How Do I Change You? Let Me Count the Ways

Cutting and Pasting (Without Using Glue)

How cutting and pasting works

Cutting and pasting a cell

Cutting and pasting a range

Cutting and pasting formulas

The E-Z way to move things

Copy-Catting

How copying works

Copying a cell to a cell

Copying a cell to a range

Copying a range to a range

Copying formulas

Drag-and-drop copying

Shortcut Keys for Copying

Adjusting Column Widths

Adjusting column widths automatically

Using the InfoBox to adjust columns

Changing Row Heights

Erasing Cells and Ranges

Adding New Rows and Columns

Adding new rows

Adding new columns

Getting Rid of Rows and Columns

Eliminating rows

Deleting columns

Transposing Rows and Columns

Finding and Replacing -- Wherefore Art Thou, Text String?

Sorting Rows

Let 1-2-3 do the sorting!

What to watch out for when sorting

Part III: Saving, Printing, and Creating New Sheets

Chapter 8: Fiddling with Files

Files and Windows

The 1-2-3 File Menu: The Important Stuff

A File Is Born

Naming your files

Protecting your precious files

If You Mess Up Big-Time

Backing Up Is Easy

Backing up using the Save As dialog box

Backing up using the Open dialog box

Other ways to back up your work

Chapter 9: Taking the Pain out of Printing

Simple Printing

Slightly Less Simple Printing

Psst . . . Wanna Sneak Preview?

Working with the preview window

Viewing multiple pages

Blowing up your image

Switching among pages

Printing Options

Specifying what to print

Dealing with headers and footers

Printing title rows or columns on every page

Adding page numbers

Printing multiple copies

Changing the print orientation

Adjusting margins

Sizing your printout

Specifying paper sizes

Selecting a printer

Creating and using print styles

Quick Reference for Printing

Printing Charts, Maps, and Drawings

Chapter 10: When One Sheet Just Isn't Enough

Why Use Multisheet Workbooks?

Clever Ideas for Using Multisheet Workbooks

Things You Should Know about Multisheet Workbooks

Fundamental Stuff

Adding sheets

Removing sheets

Naming sheets

Color-coding your sheet tabs

Printing multiple sheets

Navigating in the Third Dimension

Activating other sheets

Selecting multisheet ranges

Grouping Sheets

Creating a sheet group

Canceling a sheet group

Part IV: Making Yourself at Home

Chapter 11: Making 1-2-3 Look and Act the Way You Want It To

To View or Not to View

Zooming Windows

Splitting Windows -- What a Pane!

Freezing Rows and Columns (Brrrr!)

Chapter 12: Dressing Up Your Work

What Is Stylistic Formatting?

To Format or Not to Format?

General Principles of Formatting

Screen versus printer

General formatting how-to

Dealing with Fonts

Two categories of fonts

Using the InfoBox to change fonts

Quick font changes via the status bar

Lines and Borders and Frames (Oh My!)

Bordering on beautiful

Adding designer frames

Using Colors (Crayons Not Required)

Alignment and Misalignment

Word wrap

Centering across cells

Even spacing

Vertical spacing

Changing orientation

For Formatting Fanatics: Named Styles

Advantages of using named styles

Creating a named style

Modifying a named style

Applying a named style

One-Click Table Formatting

Be Careful Out There

Chapter 13: Presto Change-o: Turning Numbers into Charts

What Makes Up a Chart?

Chart parts

Chart-making essentials

Making Your First Chart

Easy as 1-2-3

A look at the chart

Taking Control of Your Charts

Moving and resizing charts

Annihilating charts

Printing charts

Introducing the Chart InfoBox

Changing the Chart Type

A quick overview of chart types

Ways to make your chart look different

Rearranging Your Chart's Furniture

Changing chart titles and labels

Moving a chart element

Adding a new data series to a chart

Changing a chart's data series

Changing a chart's scale

Displaying series labels in a chart

Hungry for More Chart Power?

Charming Chart Choices

A 3-D bar chart

A horizontal bar chart

A chart that knows how to accessorize

A mixed chart

Multiple doughnuts (mmm-mmm good)

An XY chart

A stock market chart

A 3-D line chart

A picture chart

Chapter 14: Presto Change-o II: Turning Numbers into Maps

To Map or Not to Map?

Types of Maps Available

Map-Making Overview

Ready, Set . . . Create That Map

Ladies and gentlemen, prepare your data

Creating your mapsterpiece

Getting your bearings

Modifying a Map

Selecting a map

The Map InfoBox

Moving and resizing a map

Adjusting the plot area

Zooming and recentering

Changing the title

Modifying the map bins: values and colors

Modifying a map legend

Chapter 15: SmartIcons and Shortcuts: Saving Precious Minutes Each Day

Why SmartIcons?

They're everywhere

Belly up to the SmartIcon Bar

So Many SmartIcons, So Little Time

Moving and Hiding SmartIcon Bars

Moving SmartIcon bars

Now you see it, now you don't

Knowing Which SmartIcon Does What

Making Your Own SmartIcon Bar

Removing SmartIcons

Adding new SmartIcons

Displaying the SmartIcon bar

Saving the SmartIcon bar

Trying out the new SmartIcon bar

Mouseless Shortcuts

Menu shortcuts

Stylistic shortcuts

Function keys

Part V: Expanding Your Horizons

Chapter 16: Using the Drawing Tools: Artistic Talent Not Required

Discovering the Secret Draw Layer

Introducing the Drawing Tools

Drawing with the Drawing Tools

Moving and copying objects

Resizing drawings

Changing the look of your drawings

Restacking objects

Combining objects

Working with text boxes

Adding Graphic Files to a Worksheet

Understanding graphic file formats

Using the Clipboard for graphic files

Getting Down to Business with the Drawing Tools

Hey! Look at me!

Improving your charts

Creating diagrams

Creating vertical labels

Chapter 17: Dealing with Lists and Databases

Considering a List versus a Database: What's the Diff?

Here's a list

Here's a database

Diving More Deeply into Databases

Creating a Worksheet Database

Querying a Worksheet Database

Creating a query table

Understanding the query table

Creating a query using a query table

Re-using queries

Deleting certain records

Working with External Database Files

Creating a query table for an external database

Creating an external query using a query table

Chapter 18: Recording and Running Scripts: What Every User Needs to Know

Scripting: It's Not Just for Playwrights Anymore!

Scripting Basics

Giving Birth to Your First Script

Recording a script

Running a script

Assigning the script to a key combination

Changing Your Point of View

Recording the CustomView script

Recording the NormalView script

Assigning the scripts to a key combination

Using Other People's Scripts

Chapter 19: Worksheet Outlining

Outline? In a Worksheet? Surely You Jest . . .

Collapsing the columns

Collapsing the rows

Creating an Outline

Creating a row outline

Creating a column outline

Expanding and Collapsing an Outline

Hiding Outline Symbols

Removing an Outline

Creating Multilevel Outlines

Chapter 20: What-If Analysis: Using the Version Manager

What-If Analysis: An Example

Asking what-if questions

. . . Getting well-then answers

Introducing Version Manager

Using Version Manager

Creating your versions

Creating the first version

Creating the second version

Creating more versions

Displaying a version

Changing the values for a version

Changing the name or comments for a version

Deleting a version

Producing a summary report

Tell Me More

Chapter 21: Bouncing from 1-2-3 to the Internet and Back Again

Launching into Cyberspace

What's available on the Internet?

How do you get on the Internet?

Using the 1-2-3 97 Internet Tools

Visiting the Lotus Web site

Accessing the Lotus FTP site

Saving data to an HTML document

Saving a file to the Internet

Opening a file from the Internet

Part VI: The Part of Tens

Chapter 22: Top Ten Good 1-2-3 Habits to Acquire

Use the SmartIcons, status-bar buttons, and shortcut keys

Use your hard disk wisely

Take advantage of multisheet workbooks

Use cell and range names whenever possible

Remember to multitask: Work with more than one program at once

Take advantage of the online help in 1-2-3

Be adventurous: Try new things

Be a good citizen -- use Print Preview

Keep it simple

Warm up to scripts

Chapter 23: Top Ten Essential Concepts for 1-2-3 Users

Many versions of 1-2-3 are available

1-2-3 is compatible with other Windows applications

1-2-3 has other windows in its window

You can select ranges in myriad different ways

You have many command options

Cell comments are free -- use them with abandon

1-2-3 has more @functions than you ever need

The online help system is comprehensive

Hard disks crash for no apparent reason

The more you use 1-2-3, the easier it gets

Chapter 24: More Than Ten Formulas You Can Pilfer

Formulas for Everyone

Calculating a sum

Computing subtotals and grand totals

Counting the number of nonblank cells in a column

Calculating a percentage change

Calculating a loan payment

Mathematical Formulas

Finding a square, cube, or other root

Generating a random number

Rounding numbers

Text Formulas

Changing the case

Joining text

Working with text and values

Date Formulas

Inserting today's date

Determining the day of the week

Determining the last day of the month

Still More Formulas

Showing the workbook's name and location

Determining the time you spent on a workbook

Looking up a corresponding value

Glossary

Index

Reader Response Card