Microsoft Office 2001 for Macs for Dummies

Contents

Introduction

About This Book

Conventions Used in This Book

What You're Not to Read

Foolish Assumptions

How This Book Is Organized

Part I: Getting Started with Microsoft Office 2001

Part II: Using Word 2001

Part III: Organizing Your E-Mail and Time with Entourage 2001

Part IV: Crunching Your Numbers with Excel 2001

Part V: Putting on a Show with PowerPoint 2001

Part VI: Working Well with Others

Part VII: The Part of Tens

Icons Used in This Book

Where to Go from Here

Part I: Getting Started with Microsoft Office 2001

Chapter 1: Why Office 2001?

Introducing Microsoft Office 2001

Word 2001

Excel 2001

PowerPoint 2001

Entourage 2001

Internet Explorer 5.0

Microsoft Office 2001 versus AppleWorks

Chapter 2: Running Office 2001

Installing Office 2001

Using Office 2001 Programs

Using the Project Gallery

Creating a new document

Saving a document

Closing a document

Opening an existing document

Printing a document

Quitting Office 2001 Programs

Chapter 3: Help Is Everywhere You Turn

Getting to Know the Office Assistant

Asking the Assistant for help

Using the Help window

Picking up tips from the Assistant

Installing and changing Assistants

Using the Other Help Files

Getting to the Help index

Using Balloon Help

Finding Help on the Web

Part II: Using Word 2001

Chapter 4: Getting Friendly with Word 2001

Creating a New Document

Opening an Existing Document

Navigating Your Document

Taking a different view

Zooming in and out

Much Ado about Toolbars

Hiding and showing toolbars

Introducing the Standard toolbar

Whipping text into shape with the Formatting Palette

Formatting Documents with the Ruler

Setting margins

Setting tabs

Indenting paragraphs

Don't Lose It: Saving Your Files

Saving your file

Saving a file under another name

Saving a file in a different format

Saving a file automatically

Printing a Document

Previewing before you print

Printing a document

Printing a range of pages

Printing in reverse order

Creating a Backup Strategy

Following a Backup Strategy

Chapter 5: Working with Words

Selecting and Editing Text

Selecting text with the mouse

Selecting text with the keyboard

Moving and copying text

Introducing the Office Clipboard

Dragging and dropping

Deleting text

Searching for Text

Finding text

Finding and replacing text

Advanced finding and replacing

Using Browse Objects

Using the Spelling and Grammar Checkers

Checking as you type

Checking everything at the same time

Using the Built-In Dictionary

Using the Built-In Thesaurus

Having Word 2001 Do the Work for You

Correcting mistakes with AutoCorrect

Inserting text automatically with AutoText

Useful Stuff to Know

Printing envelopes

Printing mailing labels

Counting your words

Inserting the date or time into your document

Numbering pages

Chapter 6: Looks Matter: A Guide to Attractive Formatting

Making Text Look Good

Choosing fonts and font sizes

Picking character styles

Copying character formats with Format Painter

Changing case

Using Wizards and Templates to Jump-Start a Document

We're off to see the Wizard

Using templates

Do It with Styles

Creating styles

Applying styles

Modifying styles

AutoFormat Steps In

AutoFormatting entire documents

AutoFormatting as you type

Using AutoFormat for numbered and bulleted lists

Instant hyperlinks

Using the Style Gallery

Working with Tables

Creating a table

Changing table size

Merging and splitting table cells

Cleaning up your tables

Sorting a table

Doing table calculations

Deleting a table

Chapter 7: Creating Reports and Newsletters

Creating Reports

Pat yourself on the back: Adding a title page with Click and Type

Give your document a break!

Using sections

Using headers and footers

Adding footnotes and endnotes

A Nose for Newsletters

Starting with the Newsletter Wizard

Working with text boxes

Adding pictures to your newsletter

Wrapping words around the pictures

Using drop caps

Part III: Organizing Your E-Mail and Time with Entourage 2001

Chapter 8: E-Mail Basics: Reading, Writing, Replying

Setting Up Entourage for E-mail

Working with E-Mail

Reading your e-mail

Replying to your e-mail

Forwarding e-mail

Creating and sending new e-mail

Attaching a file

Receiving file attachments

Deleting e-mail

Using Schedules

Modifying an existing schedule

Changing the timing of a schedule

Chapter 9: Taming Your E-Mail with Folders and Rules

File Messages in Folders

Creating a custom mail folder

Filing mail in folders

Ruling Your E-Mail

Using the Junk Mail Filter

Using a Rule to add people to your Address Book

Sorting your mail to folders

Filtering messages out with Rules

Using the Mailing List Manager

Searching for E-Mail (Or Anything Else)

Chapter 10: Managing Your Contacts, Calendar, and Tasks

Managing Contacts with the Address Book

Importing Contacts from other programs

Creating a new Contact

Using Contacts

Deleting a Contact

Managing Your Calendar

Displaying calendar views

Creating an event

Working with recurring events

Inviting a Contact to an event

Dealing with Reminders

Deleting events

Tracking Your Tasks

Creating Tasks

Setting task progress

Changing and deleting Tasks

Creating Notes

Working with Notes

Changing or deleting Notes

Data to Go

Installing the Entourage conduit

Synchronizing your handheld with Entourage

Part IV: Crunching Your Numbers with Excel 2001

Chapter 11: Spreadsheets 101: Behind the Rows and Columns

What the Heck Is a Spreadsheet?

Parts of the spreadsheet

What spreadsheets are good for

Things that spreadsheets don't do well

Cruising through a Worksheet

Selecting cells with the mouse

Using the keyboard

Naming cells and ranges

Entering Information into a Worksheet

Putting information in a cell

Editing or deleting the contents of a cell

Managing Lists with Excel 2001

Creating a list

Sorting and filtering lists

Making Your Worksheet Look Good

Using AutoFormat

Formatting numbers and text

Chapter 12: Formulas Work -- So That You Don't Have To!

Introducing Formulas

Starting with formulas

Using names in formulas

Formatting the spreadsheet with AutoFormat

Adding another formula

Editing a formula

Deleting a formula

May I See Your References?

Creating cell and range references

Grouping references with parentheses

Using Functions

Using AutoSum

Using the Calculator

Chapter 13: Working with Worksheets and Workbooks

Naming Worksheets

Creating and Deleting Worksheets

Linking Worksheets with Formulas

Using AutoSum

Analyzing your data

Using worksheet references

Adding Worksheets to Workbooks

Chapter 14: Turning Numbers into Pictures with Charts

The Right Kind of Chart

Creating a Chart with the Chart Wizard

Modifying a Chart

Changing the chart size

Changing the chart orientation

Changing the chart type

Changing the axis of a bar chart

Part V: Putting on a Show with PowerPoint 2001

Chapter 15: Creating PowerPoint Slide Shows

Creating Your First Presentation

Using the AutoContent Wizard

Using a PowerPoint template

Working with Your Slides

Creating a new slide

Deleting a slide

Working with text boxes

Reviewing Your Presentation

Using Normal view

Using Outline view

Using Slide view

Using Slide Sorter view

Using Notes Page view

Playing a slide show

Printing Your Presentation

Chapter 16: Spiffing Up Your Presentations

Adding Graphics and Media

Putting in pictures

Adding movies and sounds

Boosting PowerPoint's Memory

Drawing in PowerPoint

Drawing lines and boxes

Using AutoShapes

Moving or deleting drawn objects

Changing Slide Backgrounds and Styles

Swapping backgrounds

Changing slide layouts

Creating Transitions

Making slide transitions

Creating text transitions

Chapter 17: Doing the Presentation

Adding Interactivity to Your Show

Adding Action Buttons

Inserting hyperlinks to Web sites

Creating Custom Shows

Practicing Your Presentation

Running through your slide show

Rehearsing your timing

Conquering Stage Fright and Doing the Show

Presentation Tips

Part VI: Working Well with Others

Chapter 18: Using the Office 2001 Collaboration Features

Share and Share Alike

Copying and moving information

Dragging and dropping information

Linking information

Sharing Information Using Entourage

E-mailing Office documents with Entourage (or other programs)

Creating reminders in Entourage

Sharing Information with Word

Making comments

Tracking changes

Keeping track of versions

Creating Excel worksheets in Word

Sharing Information with Excel

Sharing workbooks

Using Word text in an Excel spreadsheet

Sharing Information with PowerPoint

Building tables and charts from Excel information

Linking Word text to your PowerPoint presentation

Chapter 19: Sharing Information Over the Internet

Using Hyperlinks

Linking to Web pages

Linking to other Office documents

Inserting e-mail hyperlinks

Creating internal links

Removing hyperlinks

Using the Web Toolbar

Displaying the Web toolbar

Browsing with the Web toolbar

Creating Web Pages with Office 2001

Building Web pages in Word 2001

Turning Excel spreadsheets into Web pages

Publishing Entourage Calendars on the Web

Part VII: The Part of Tens

Chapter 20: Ten (Or So) Ways to Customize Office 2001

Add Custom Menu Commands

Rename Menu Commands

Add Your Own Shortcut Keys

Make a Custom Menu

Customizing Contextual Menus

Record a Macro

Macros in Word 2001

Macros in Excel 2001

Macros in PowerPoint and Entourage

Helping the Visually Impaired

Blow up those buttons

Zoom in for a better view

Customize the Recently Used File List

Eliminate Automatic Grammar Checking

Chapter 21: Ten Tips to Tune Up Your Toolbars

Toolbars: Now You See Them, Now You Don't

Adding a Button to a Toolbar

Removing a Button from a Toolbar

Adding Menus and Macros to a Toolbar

Putting one of the built-in menus on a toolbar

Creating a custom menu on a toolbar

Adding a macro to a toolbar

Letting Those Toolbars Float

Making an AutoText Toolbar

Adding the Style Menu in Excel 2001

Moving and Copying Toolbar Buttons

Separating Those Toolbar Buttons

Putting Your Toolbars Where You Want Them

Chapter 22: Ten Quick Time-Saving Tips

Paint Your Formats

Flash Your Formulas

Save 'Em All, Close 'Em All

Have AutoCorrect Do It for You

Select Just One Part

Insert Alternate Rows or Columns

Give an Automatic List a Break

Use the Spike

Quick Selections in Excel

Move It, Mr. Paragraph!

Appendix