Microsoft® Office v. X for Mac Inside Out

Author Tom Negrino, with Kirk McElhearn and Kate Binder Pages 1008 Disk N/A Level Int/Adv Published 05/29/2002 ISBN 9780735616288 Price $44.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD Rate this book

Table of Contents

Acknowledgments	xxv
We'd Like to Hear from You!	xxvii
Conventions and Features Used in This Book	xxix
PART 1   OFFICE V. X FUNDAMENTALS	1
CHAPTER 1   An Overview of Office v. X	3
What Is Office v. X?	3
Why Office v. X?	4
Finding Out What's New	5
New Office v. X Features	5
New Word Features	9
New Entourage Features	10
New Excel Features	11
New PowerPoint Features	12
Launching Office v. X Applications	13
Let's Get Started	14
CHAPTER 2   Creating and Managing Documents	15
Creating New Documents	15
Understanding the Project Gallery and Templates	16
Opening Existing Documents	21
Saving Your Documents	25
Using Save	25
Using AutoRecover	26
Using Save As	27
Saving Documents for Windows Users	27
CHAPTER 3   Getting Expert Help with Office v. X	31
Using the Office Assistant	31
Getting Help from the Office Assistant	32
Modifying the Office Assistant	35
Banishing the Office Assistant	38
Using the Help Index	38
Printing Help Files	39
Getting Web-Based Help	39
Accessing Tools On The Web	41
Accessing the Getting Started Book on the Office v. X CD	41
Turning on ScreenTips	42
Getting the Tip of the Day	44
CHAPTER 4   Office v. X: Do It Your Way	45
Wrangling Your Toolbars	45
Displaying and Hiding Toolbars	46
Arranging and Docking Toolbars	48
Adding a Button to a Toolbar	48
Removing a Button from a Toolbar	50
Moving, Copying, and Separating Toolbar Buttons	50
Adding Menus to a Toolbar	51
Creating Your Own Toolbars	53
Customizing Menus	53
Renaming Menu Commands	54
Creating Custom Menus for the Menu Bar	55
Customizing Word's Contextual Menus	55
Customizing Keyboard Shortcuts in Word and Excel	56
PART 2   WORD	59
CHAPTER 5   Word Essentials	61
The Word Document Window in Depth	61
Getting Different Views of Your Document	63
Working with Document Views	63
Zooming in on Your Document	65
Using the Window Menu	67
Displaying Multiple Document Windows	67
Minimizing Windows to the Mac OS X Dock	67
Splitting Windows	68
Arranging Windows	68
Sending Word Documents via E-Mail	70
Flagging Documents for Follow-Up	71
Previewing Your Document	72
Using the Print Preview Window	72
Viewing Multiple Pages in Print Preview	74
Editing in Print Preview	75
Adjusting Margins, Indents, and Tabs	75
Printing Documents	76
Using the Page Setup Dialog	77
Printing Portions of Your Document	79
Printing Information About Your Document	80
Printing Documents to Disk as PDF Files	82
Printing Envelopes	82
Printing Labels	85
CHAPTER 6   Effective Text Editing	87
Entering Text	87
Using Click and Type	88
Inserting Symbols	90
Inserting Special Characters into Your Document	90
Copying and Pasting with the Office Clipboard	91
Using the Spike to Move Many Items	93
Using AutoText and AutoComplete	94
Creating a New AutoText Entry	95
Letting AutoComplete Do the Work	96
Adding an AutoComplete Entry	97
Deleting an AutoComplete Entry	98
Inserting Text Blocks with AutoComplete	98
Fixing Common Mistakes with AutoCorrect	98
Creating AutoCorrect Entries	99
Setting AutoCorrect Options	100
Telling AutoCorrect About Exceptions	102
Formatting Your Document with AutoFormat	103
Applying AutoFormat Changes as You Type	103
Applying AutoFormat Changes	105
Selecting and Editing Text with Multi-Selection	108
Finding and Replacing Text and Formatting	108
Finding Text	109
Replacing Text	109
Advanced Text Replacement	110
Replacing Formatting	112
Navigating Through Your Document	113
Navigating with the Browse Buttons	114
Navigating with Go To	115
Using the Document Map View	116
Using Bookmarks	118
Showing Bookmarks in a Document	120
Hiding Bookmark Indicators in a Printed Document	121
CHAPTER 7   Formatting Your Work	123
Browsing the Formatting Palette	123
Setting Font Attributes	124
Setting Alignment and Spacing	125
Setting Borders and Shading	125
Setting Document Properties	126
Controlling Character Formatting	127
Applying Basic Text Formatting Options	128
Applying Advanced Character Formatting Options	130
Adjusting Kerning and Letterspacing	131
Specifying Superscripts and Subscripts	133
Creating Drop Caps	134
Changing Text Case and Text Direction	135
Setting Paragraph Formatting	137
Using the Ruler to Set Indents	138
Using the Ruler to Set Tabs	139
Manipulating Tab Stops	140
Applying Line Spacing	141
Adjusting Paragraph Indents, Alignment, and Spacing	142
Setting Line and Page Breaks	143
Adding Borders to a Paragraph	143
Adding Shading Behind Text	144
Formatting Using the Keyboard	145
Using the Format Painter	146
Clearing All Formatting	146
Revealing Formatting	147
Formatting the Whole Document	148
Setting Page Size and Orientation	148
Setting Page Margins	149
Adding Line Numbering	150
Working with Sections	151
Creating Headers and Footers	152
Adding AutoText to Headers and Footers	152
Positioning Headers and Footers	153
Adding Page Numbering	154
Formatting Page Numbers	154
Controlling the Appearance of Headers and Footers	156
Inserting a Section Break	157
CHAPTER 8   Advanced Formatting with Styles, Templates, and Themes	159
Understanding Styles	160
Applying Styles	161
Applying Styles from the Formatting Palette	161
Applying Styles with the Keyboard	162
Applying Styles in the Style Dialog	164
Defining Styles	165
Defining Styles by Example	165
Creating Styles from Scratch	166
Basing One Style on Another Style	168
Redefining Styles	169
Replacing Styles	170
Deleting Styles	171
Copying Styles Between Documents and Templates	172
Working with Templates	173
Understanding the Normal Template	174
Modifying the Normal Template	175
Creating Documents from an Included Template	175
Creating and Using Custom Templates	177
Attaching Templates to Documents	177
Working with Global Templates	178
Using Themes	180
Using the Style Gallery	181
CHAPTER 9   Laying Out Text	183
Creating Tables	183
Creating a Simple Table	184
Drawing a Table	185
Inserting a Table	187
Moving Around in Tables	189
Table Editing	190
Inserting or Deleting Rows and Columns	190
Inserting or Deleting Table Cells	191
Selecting Table Items	192
Moving Table Rows or Columns	192
Merging and Splitting Table Cells	192
Splitting a Table	194
Formatting Tables	194
Resizing an Entire Table	194
Moving an Entire Table	195
Adjusting Column Width and Row Height	196
Using AutoFit	196
Adding Borders and Shading	197
Formatting a Table Automatically	197
Setting Table Properties	199
Defining a Table's Size, Alignment, and Text Wrapping	199
Setting Properties for a Table Row	201
Setting Properties for a Table Column	203
Setting Properties for a Table Cell	204
Sorting Table Contents	206
Performing Calculations Within Tables	208
Using Functions for Table Calculations	208
Using AutoSum	209
Converting Tables	210
Converting Text to Tables	210
Converting a Table to Text	211
Creating Bulleted and Numbered Lists	212
Creating a List	212
Formatting Lists with the Formatting Palette	213
Customizing Lists Using the Bullets And Numbering Dialog	213
Increasing or Decreasing the Indentation of List Items	218
Creating Newspaper-Style Columns	218
Using Text Boxes	220
Creating and Deleting Text Boxes	220
Positioning Text Boxes	221
Formatting Text Inside Text Boxes	221
Working with Linked Text Boxes	221
Wrapping Text Around Text Boxes	222
Using the Equation Editor	224
CHAPTER 10   Working with Images, Movies, Sounds, and Objects	227
Understanding Graphics in Word	228
Inline and Page Graphics	228
Layering Graphics and Text	229
Inserting Graphics and Media Files	230
Using the Clip Gallery	230
Viewing and Editing Image Properties	232
Creating a New Category	233
Adding Clips to or Removing Clips from a Category	234
Getting More Pictures Online	235
Adding Images to the Clip Gallery	239
Placing Image Files	240
Working with the Drawing Tools	240
Adding AutoShapes to a Document	242
Adding Text to an AutoShape	243
Using the WordArt Gallery	243
Editing WordArt Text	244
Formatting WordArt	245
Acquiring Images from a Scanner or Camera	248
Inserting QuickTime Movies	249
Setting Poster Frames	249
Setting Background Sounds and Music for a Web Page	250
Modifying Graphics	251
Using the Format Picture Dialog	251
Adding Picture Effects	254
Cropping and Cutting Out Images	255
Adjusting the Colors of an Image	257
Inserting Watermarks	258
Inserting Objects	259
Using Microsoft Organization Chart	260
CHAPTER 11   Using Word's Proofing Tools	263
Checking Spelling	263
Checking Spelling as You Type	264
Checking Spelling in the Whole Document	266
Checking Spelling in Part of a Document	268
Setting Spelling Options	269
Working with Dictionaries	271
Adding Words to a Custom Dictionary	271
Creating a New Dictionary	272
Assigning a Dictionary to a Document	273
Checking Spelling in Foreign Languages	273
Installing Foreign Language Proofing Tools	274
Checking Grammar	276
Setting Grammar Checking Options	276
Customizing Grammar Settings	277
Checking Grammar in the Whole Document	278
Rechecking a Document	279
Enriching Your Word Choices with the Thesaurus	279
Hyphenating Your Documents Automatically	281
Getting Word Counts	282
Counting Words in Part of a Document	284
Turning Live Word Count On or Off	284
CHAPTER 12   Mastering Large or Specialized Documents	285
Building Documents from Outlines	285
Applying Outline Levels to Text	286
Expanding and Collapsing Outlines	289
Moving Headings	289
Numbering Your Outline	292
Using the Document Map	294
Inserting Other Files into Your Document	296
Working with Master Documents	296
Creating a New Master Document	297
Converting Documents into Subdocuments	299
Navigating Master Documents	299
Creating Document Summaries with AutoSummarize	303
Generating Tables of Contents and Indexes	305
Creating a Table of Contents	305
Building an Index	307
Inserting Footnotes and Endnotes	310
Creating Footnotes and Endnotes	310
Deleting Footnotes and Endnotes	312
Customizing the Footnote Separator	312
Inserting Figure Captions	313
CHAPTER 13   Collaborating with Word	317
Working with Comments	317
Adding Comments	318
Reviewing Comments	320
Deleting Comments	323
Highlighting Text	324
Tracking Changes	326
Setting Up the Track Changes Feature	326
Reviewing Changes	327
Merging Changes from Several Reviewers	330
Comparing Documents	331
Protecting Documents from Changes	332
Managing Document Versions	334
CHAPTER 14   Automating Mailing with Data Merging	337
Understanding Data Merges	337
Introducing the Data Merge Manager	338
Preparing Your Data Source	339
Preparing the Main Document	344
Limiting Records Used in a Merge	345
Previewing the Merged Data	347
Printing the Data Merge	348
Merging to a New Document	351
Understanding Fields	352
Defining Fields	353
Using Field Switches	358
Viewing Field Codes	359
Formatting Fields	360
CHAPTER 15   Creating Pages for the Web	363
Building Web Pages	363
Creating Web Documents	364
Opening Web Documents	365
Adding Web Page Elements	366
Inserting and Linking Hyperlinks	367
Adding a Background Color, Pattern, or Image to a Web Page	371
Building Web Forms	373
Saving a File as an HTML File	376
Setting Web Page Options	376
Previewing Your Web Page	379
Viewing the Source Code of an HTML Page	380
Publishing Your Web Pages	380
CHAPTER 16   Automating Word with Macros and AppleScripts	383
About Automating Word	384
Using Word Macros	385
Recording Macros	387
Running Macros	390
Using the Macro Dialog and the Organizer	392
Using the Visual Basic Editor to Edit a Macro	393
Using AppleScript with Word	395
Recording AppleScripts	395
Running the AppleScript	397
Using REALbasic for Automation	399
PART 3   ENTOURAGE	401
CHAPTER 17   Entourage Essentials	403
What You Can Do with Entourage	403
E-Mail	403
Newsgroups	404
Contact Manager	404
Calendar, Tasks, and Notes	405
Comparing Entourage with Outlook Express	405
The Entourage Window in Depth	406
Using the Entourage Setup Assistant	410
Setting Up E-Mail Accounts	412
Importing Data from Other Programs	415
Working with Multiple Users	418
Creating and Switching Between Identities	419
Moving Identity Files Between Macintoshes	420
Renaming or Deleting an Identity	421
Using Sound Sets	422
CHAPTER 18   Mastering Your E-Mail	425
Receiving and Reading Mail	425
Icons in the Message list	431
Deleting Unwanted Mail	433
Marking Mail	434
Replying to a Message	435
Adding Correspondents to Your Address Book	437
Forwarding and Redirecting E-Mail	438
Working with File Attachments	440
Viewing Internet Headers	442
Composing, Addressing, and Sending Mail	444
Creating a New Message	444
Formatting HTML Mail	445
Checking Spelling in Messages	447
Working with Message Quoting	448
Saving Message Drafts	450
Using Signatures	450
Attaching Files and Folders to Messages	452
Sending Your Messages	454
Online Access and Working Offline	454
Printing Mail Messages	456
Setting Up Mail Schedules	457
Organizing Your E-Mail	458
Using Folders	459
Using Priorities, Categories, and Flags	460
Sorting and Filtering the Message List	463
Searching Your E-Mail	464
Using the Junk Mail Filter	466
Handling Mailing Lists with the Mailing List Manager	468
Working with Mail Rules	470
Creating Mail Rules	471
Filtering Out Spam	472
Prioritizing Rules	473
Applying Rules Manually	475
Disabling, Duplicating, and Deleting Rules	475
Using Outgoing Mail Rules	476
Archiving Mail	477
Rebuilding the Entourage Database	478
CHAPTER 19   Using Newsgroups	481
About Usenet	481
Setting Up a News Account	484
Downloading the Newsgroup List	486
Selecting and Subscribing to Newsgroups	487
Reading News Messages	488
Composing and Replying to Messages	490
Using Newsgroup Rules	492
CHAPTER 20   Managing Your Contacts	495
Creating and Using Contacts	495
Setting Defaults	498
Working with the Personal Tab and Custom Fields	499
Defining Address Groups	500
Searching for Contacts	501
Using Contact Actions	502
Working with vCards	503
Importing and Exporting Contacts	504
Printing Contacts	505
CHAPTER 21   Managing Your Appointments, Tasks, and Notes	507
Working with Calendar Views	507
Importing Calendar Information	512
Importing Holidays	513
Creating and Editing Calendar Events	514
Editing and Deleting Calendar Events	518
Working with Recurring Events	519
Working with Office Notifications	519
Sending Invitations and Getting RSVPs	520
Printing Your Calendar	522
Working with Tasks	524
Creating Tasks	525
Printing Tasks	526
Working with Notes	526
Creating Notes	526
Printing Notes	527
CHAPTER 22   Organizing and Sharing Entourage Data	529
Using Custom Views	529
Creating a Custom View	531
Editing or Deleting a Custom View	534
Linking Information	534
Creating Links to Existing Items	535
Creating Links to New Items	536
Showing an Item's Links	536
Using Entourage Contacts in Word Documents	537
Publishing Your Calendar on the Web	538
Synchronizing Entourage to Your Palm Device	540
Using Entourage Contacts with Your iPod	541
CHAPTER 23   Extending Entourage with AppleScript	545
About Entourage's AppleScript Support	545
Finding and Installing Cool Scripts	547
Using the Scripts Menu	549
Anatomy of a Script	551
Where to Learn More	556
PART 4   EXCEL	557
CHAPTER 24   Excel Essentials	559
Introducing Excel's Workspace	559
Working with Worksheets	562
Adding and Deleting Worksheets	562
Navigating Worksheets and Workbooks	563
Moving Worksheets	566
Copying Worksheets	568
Using AutoRecover	568
Getting the Most Out of Workbooks	569
Naming and Renaming Worksheets	569
Using Multiple Workbooks at Once	570
Getting Different Views	572
Changing Window Views	572
Freezing Panes	573
Using Custom Views	574
Sending Excel Documents via E-Mail	574
Flagging Workbooks for Follow-Up	575
Printing Worksheets	576
Setting Up Worksheets for Printing	576
Adjusting Page Breaks	580
Specifying the Print Area	582
Exploring Other Printing Options	583
Previewing the Print Job	584
Printing the Worksheet	585
CHAPTER 25   Editing a Worksheet	587
Selecting Information	587
Selecting Cells That Contain Particular Contents	589
Using the Keyboard to Select Cells	591
Entering Information in Cells	592
Keyboard Shortcuts for Entering Data	593
Using AutoFill to Enter a Series	594
Editing Cell Contents	597
Copying, Pasting, and Moving Cells and Their Contents	598
Deleting Cells and Clearing Cell Data	602
Naming Cell Ranges	602
Working with Rows and Columns	604
Inserting Rows and Columns	605
Deleting Rows and Columns	605
Copying, Pasting, and Moving Rows and Columns	605
Hiding and Unhiding Rows and Columns	606
Finding and Replacing Information	607
Checking Spelling	608
CHAPTER 26   Mastering Worksheet Formatting	611
Formatting Cells	611
Using the Format Painter	612
Specifying Number Formats	612
Creating Custom Number Formats	616
Applying Borders and Shading	619
Changing Alignment, Text Orientation, and Text Wrapping	623
Merging Cells	626
Formatting Rows and Columns	626
Adjusting Row Heights	626
Adjusting Column Widths	627
Using AutoFit	628
Using the Formatting Palette	628
Letting AutoFormat Do It	630
Using Styles in Excel	632
Using Conditional Formatting	634
Using Templates	635
CHAPTER 27   Working with Functions and Formulas	637
Understanding Functions and Formulas	637
Using Functions	638
Employing the AutoSum Function	638
Inserting Built-in Functions	641
Building Formulas	644
Using the Formula Bar	645
Understanding Operators and Their Order	647
Putting the Calculator to Work	651
Understanding Cell References	653
Copying and Pasting Formulas	655
Using Named Cell Ranges in Formulas	656
Linking Data Between Worksheets and Workbooks	656
CHAPTER 28   Working with Lists and Databases	659
Building Lists with the List Manager	659
Creating a List	661
Using Data Validation	665
Sorting Columns and Rows	667
Selecting and Filtering Data	669
Using Forms for Working with Data	670
Subtotaling Data	672
Grouping and Outlining Data	675
Using External Data	677
Importing Text Files	677
Importing Data from FileMaker Pro	680
Importing Web Data	681
Using Excel Data as a Word Data Merge Source	683
Exporting Data from Excel	684
CHAPTER 29   Analyzing and Presenting Data with Charts	687
Understanding Chart Types	687
Creating Charts	690
Using the Chart Wizard	691
Creating Embedded Charts	694
Chart Formatting	695
Working with the Chart Menu and Chart Toolbar	695
Changing Chart Formatting	696
Changing Chart Types	697
Changing the Perspective of 3-D Charts	698
Changing Titles and Other Text	699
Adding Legends to Your Chart	699
Adding Gridlines	701
Setting Chart Transparency	702
Creating Combination Charts	706
Printing Charts	708
CHAPTER 30   Adding Graphics to Worksheets	709
Managing Images	709
Adding Pictures and Clip Art	710
Inserting Scanned Images	716
Adding Movie Files	717
Setting Background Images	718
Using the Drawing Tools	720
Adding AutoShapes	723
Using Text Graphics	725
Adding Text Boxes	726
Inserting WordArt	726
CHAPTER 31   Analyzing Data with Excel	729
Creating PivotTables	729
Rearranging PivotTable Data	738
Formatting PivotTables	743
Creating Charts from PivotTables	746
Grouping and Ungrouping Data	747
Performing What-If Analysis	748
Using Data Tables	748
Using Goal Seek	750
Using Scenarios	753
Working with the Solver	758
CHAPTER 32   Collaborating with Colleagues	765
Sharing a Workbook	765
Stopping Workbook Sharing	768
Using Advanced Sharing Options	768
Tracking Changes	770
Reviewing Tracked Changes	771
Protecting Worksheets and Workbooks	772
Protecting Worksheets	772
Protecting Workbooks	773
Protecting and Sharing Workbooks	774
Using a Password to Protect a Workbook	775
Merging Workbooks	775
Adding and Reviewing Cell Comments	776
Adding Cell Comments	777
Editing and Removing Cell Comments	777
Hiding Cell Comments	778
Reviewing Cell Comments	779
Sharing Excel Documents on the Web	780
Previewing Excel Documents as Web Pages	781
Saving Excel Documents as Web Pages	782
Generating Web Pages Automatically	783
Working with Hyperlinks	785
Adding Hyperlinks to Worksheets	785
Linking to a Web Page	786
Linking to a Document	787
Linking to an E-Mail Address	787
Assigning Hyperlinks to Graphics	788
CHAPTER 33   Customizing and Automating Excel	789
Customizing Excel Toolbars	789
Adding Buttons to Toolbars	790
Adding Menus to Toolbars	790
Creating Custom Toolbars	792
Using Excel Macros	794
Recording Macros	794
Running Macros	797
Assigning Macros to Toolbar Buttons	800
Writing Macros with Visual Basic	802
Editing Macros	805
Copying Macros	805
Using Add-ins	808
PART 5   POWERPOINT	811
CHAPTER 34   PowerPoint Essentials	813
The PowerPoint Workspace	814
Formatting Palette	815
Document Window	815
PowerPoint Views	816
Anatomy of a Slide	817
Creating Presentations	819
Starting with a Design Template	820
Starting with a Blank Presentation	821
Using the AutoContent Wizard	822
Adding Slides	824
Adding Text to Presentations	826
Writing Presentations in the Outline Pane	826
Entering Text Directly on Slides	827
Text Editing	827
Checking Spelling	828
Sending PowerPoint Documents via E-Mail	830
Flagging Presentations for Follow-Up	830
CHAPTER 35   Enhanced Presentation Formatting	833
Working with Headers and Footers	834
Using the Formatting Palette	835
Formatting Text	836
Changing Text Alignment, Indentation, and Spacing	837
Replacing Fonts	839
Using Bulleted and Numbered Text	839
Using the Format Painter	841
Adding Hyperlinks	841
Adding Text Boxes	844
Attaching Comments to Slides	844
Using Master Items	846
Editing Slide and Title Masters	847
Editing Notes and Handout Masters	848
Changing Slide Layouts	849
Applying Slide Templates	850
Applying Color Schemes and Backgrounds	851
Animating the Presentation	854
Animating Text and Graphics	854
Setting Slide Transitions	856
Rearranging Slides with the Slide Sorter	857
CHAPTER 36   Illustrating the Presentation	859
Managing Images	859
Adding Pictures and Clip Art	860
Inserting WordArt	864
Inserting Scanned Images	865
Adding AutoShapes	866
Adding Media Files	867
Adding Sounds	867
Adding Movie Files	868
Adding Animations	869
Working with Charts	870
Inserting Charts in PowerPoint	870
Creating Charts Based on Excel Worksheets	872
Inserting Charts from Excel	872
Working with Tables	873
Creating Tables in PowerPoint	874
Inserting Word or Excel Tables	875
Adding Other Objects to Slides	876
Inserting Equations	876
Adding Organization Charts	878
CHAPTER 37   Preparing to Present	881
Creating Speaker Notes	881
Creating Handouts	883
Printing Your Presentation	885
Printing Speaker Notes and Handouts	886
Printing Slides	887
Recording Narration	888
Creating Custom Shows	890
Creating Self-Running Presentations	893
Making a Presentation Self-Running	893
Playing a Self-Running Presentation	893
Setting Slide Timings	894
Previewing the Presentation	896
CHAPTER 38   Giving the Presentation	897
Running the Presentation	898
Controlling the Presentation with the Keyboard	902
Hiding and Showing Slides	903
Annotating the Presentation with the Pen	904
Taking Notes with the Meeting Minder	906
CHAPTER 39   Presenting Everywhere	909
Packaging Your PowerPoint Files	909
Saving Presentations as QuickTime Movies	910
Turning Your Presentation into a Web Site	913
Turning Your Presentation into Overheads or Slides	916
Printing Overheads	916
Ordering Slides	918
Index to Troubleshooting Topics	921
Index	925

Last Updated: May 29, 2002

Top of Page