Microsoft Office v.X for Macs For Dummies

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 v. X
Part II: Using Word X
Part III: Organizing Your E-Mail and Time with Entourage X
Part IV: Crunching Your Numbers with Excel X
Part V: Putting on a Show with PowerPoint X
Part VI: Working Well with Others
Part VII: The Part of Tens

Icons Used in This Book
Where to Go from Here

Chapter 1: Why Office v. X?

Introducing Microsoft Office v. X

Word X
Excel X
PowerPoint X
Entourage X
Internet Explorer 5.1

Microsoft Office v. X versus AppleWorks

Chapter 2: Running Office v. X

Installing Office v. X
Using Office v. X Programs

Using the Project Gallery
Creating a new document
Saving a document
Closing a document
Opening an existing document
Printing a document

Quitting Office v. X 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
Finding Help on the Web

Chapter 4: Getting Friendly with Word X

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
Selecting noncontiguous text
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 X Do the Work for You

Correcting mistakes with AutoCorrect
Inserting text automatically with AutoText

Useful Stuff to Know

Counting your words
Live Word Count
Inserting the date or time into your document
Numbering pages
Printing envelopes
Printing mailing labels

Doing Data Merges

Creating the Main Document
Preparing the data source
Adding data fields to the Main Document
Previewing your data merge
Merging your data

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

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
Redirecting 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

Filing 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

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 X

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
Changing the transparency of chart elements

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

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
Using QuickTime 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
Packing Your Presentation To Go
Practicing Your Presentation

Running through your slide show
Rehearsing your timing

Conquering Stage Fright and Doing the Show
Presentation Tips

Chapter 18: Using the Office v. X 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 v. X

Building Web pages in Word X
Turning Excel spreadsheets into Web pages
Publishing Entourage Calendars on the Web

Chapter 20: Ten (Or So) Ways to Customize Office v. X

Add Custom Menu Commands
Rename Menu Commands
Add Your Own Shortcut Keys
Make a Custom Menu
Customizing Word's Contextual Menus
Record a Macro

Macros in Word X
Macros in Excel X
Macros in PowerPoint and Entourage

Helping the Visually Impaired
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 X
Moving and Copying Toolbar Buttons
Separating Those Toolbar Buttons
Putting Your Toolbars Where You Want Them

Chapter 22: Ten Quick Time-Saving Tips

Save 'Em All, Close 'Em All
Flash Your Formulas
Paint Your Formats
Have AutoCorrect Do It for You
Select Just One Part
Insert Alternate Rows or Columns

Give an Automatic List a Break

Use the Spike Instant Charts in Excel

Move It, Mr. Paragraph!