Kurzbeschreibung The new version of Office for Mac is Microsoft’s most collaborative, compatible, and easy-to-use version for Mac to date--bringing the Mac version on an even level with Office 2010 for the PC while remaining truly Mac-like. Using Microsoft Office 2011 for Mac explains the tasks you need to perform if you must switch between platforms, as well as the rich, new features in this version if you are upgrading from an older Mac version. Using Microsoft Office 2011 for Mac is broken into five sections--one section for each of the four applications and a fifth section on Document Connection that teaches you how to use the collaboration features of Office via SharePoint or SkyDrive. For Word, PowerPoint, and Excel, each section includes an introductory chapter to get you comfortable with the basics and subsequent chapters that teach you how to enhance your work and use productivity tools. Additionally, online audio and video instruction enhance the book by explaining additional topics and demonstrating real-world tasks.

nexusstc/Using Microsoft Office for Mac/5972bbdfe56f085f38e815e20157ddad.pdf

lgli/Pearson-Using.Microsoft.Office.for.Mac.2011.RETAiL.EBook-DiGiBook 0-7897-4558-5,978-0-7897-4558-3.pdf

lgrsnf/Pearson-Using.Microsoft.Office.for.Mac.2011.RETAiL.EBook-DiGiBook 0-7897-4558-5,978-0-7897-4558-3.pdf

zlib/Computers/Programming/Yvonne Johnson/Using Microsoft Office for Mac_783249.pdf

Safari books online

Alpha Books

Hayden

Que

United States, United States of America

Indianapolis, Ind, c2011

demonoid.me

lg358454

{"isbns":["0789745585","9780789745583"],"last_page":372,"publisher":"Pearson"}

Title from cover (Safari, September 21, 2011).

MiU

Media Table of Contents 6
Chapter 1: Getting Started with Word 24
Tell Me More Media 1.1—Creating Automator Workflows 28
Show Me Media 1.2—Printing a Document with the Print Command 37
Show Me Media 1.3—E-mailing a Document 43
Show Me Media 1.4—Creating a Calendar from a Template 44
Chapter 2: Editing Documents 49
Show Me Media 2.1—Using Browse Objects to Navigate 52
Show Me Media 2.2—Using the Advanced Find and Replace Command 54
Show Me Media 2.3—Using the Scrapbook 63
Tell Me More Media 2.4—Setting Grammar Preferences 68
Chapter 3: Formatting Documents 69
Show Me Media 3.1—Setting Paragraph Alignment, Indents, and Spacing 80
Show Me Media 3.2—Setting Tabs in the Tabs Dialog Box 82
Show Me Media 3.3—Setting Tabs on the Ruler 83
Tell Me More Media 3.4—Using Quick Styles 90
Show Me Media 3.5—Drawing a Table 97
Chapter 4: Exploring Other Features 110
Show Me Media 4.1—Creating an AutoText Entry 115
Show Me Media 4.2—Using the Thesaurus 116
Show Me Media 4.3—Recording a Macro 118
Tell Me More Media 4.4—Macros and Security Issues 120
Show Me Media 4.5—Removing the Background of a Photo 129
Chapter 5: Using the Notebook 134
Show Me Media 5.1—Numbering Text in a Notebook 140
Show Me Media 5.2—Recording Audio Notes in a Notebook 143
Tell Me More Media 5.3—Setting Audio Preferences 144
Show Me Media 5.4—Using the Scribble Tools 145
Chapter 6: Creating Documents for Publication 150
Show Me Media 6.1—Using a Template to Create a Publication 151
Tell Me More Media 6.2—Exploring Lorem Ipsum Text 153
Show Me Media 6.3—Creating Linked Text Boxes and Filling Them with a Story 158
Show Me Media 6.4—Inserting a SmartArt Graphic 167
Chapter 7: Using E-mail 178
Tell Me More Media 7.1—Setting Up an Exchange Account 182
Show Me Media 7.2—Applying a Background Color 190
Show Me Media 7.3—Creating Signatures 193
Show Me Media 7.4—Deleting E-mail Messages 198
Chapter 8: Using Contacts 202
Tell Me More Media 8.1—Performing Advanced Searches 210
Show Me Media 8.2—Adding and Deleting Fields on a Contact Form 214
Show Me Media 8.3—Creating a Contact Group 216
Show Me Media 8.4—Adding and Deleting Categories 219
Chapter 9: Using the Calendar 224
Show Me Media 9.1—Customizing the Work View 226
Show Me Media 9.2—Creating a Nonrecurring Appointment 230
Show Me Media 9.3—Setting a Recurring Appointment 232
Tell Me More Media 9.4—Setting Preferences for My Day 240
Chapter 10: Using Tasks and Notes 241
Show Me Media 10.1—Creating a Task 243
Show Me Media 10.2—Creating a Recurring Task 244
Show Me Media 10.3—Making Changes to a Task 245
Tell Me More Media 10.4—Creating Separate To-Do Lists with Categories 247
Show Me Media 10.5—Creating Notes 248
Chapter 11: Getting Started with PowerPoint 250
Show Me Media 11.1—Adding a Slide 256
Show Me Media 11.2—Adding Text to a Placeholder 257
Show Me Media 11.3—Adding a Photo to a Placeholder 259
Show Me Media 11.4—Working with Layers 262
Show Me Media 11.5—Typing the Outline for a Presentation 263
Show Me Media 11.6—Creating a Presentation with Both Methods 265
Tell Me More Media 11.7—Editing the Master Slide Layouts 267
Chapter 12: Creating Sophisticated Presentations 271
Show Me Media 12.1—Assigning an Action 278
Show Me Media 12.2—Animating Slide Elements 280
Show Me Media 12.3—Applying a Transition 283
Tell Me More Media 12.4—Annotating Slides 289
Chapter 13: Getting Started with Excel 291
Show Me Media 13.1—Taking a Tour of the Excel Window 293
Show Me Media 13.2—Entering a Formula with the Pointing Method 303
Show Me Media 13.3—Copying Formulas with Relative Cell References 305
Tell Me More Media 13.4—Using Absolute Cell References 305
Chapter 14: Enhancing Worksheets 312
Show Me Media 14.1—Inserting Cells 315
Show Me Media 14.2—Creating an Excel Style 324
Tell Me More Media 14.3—Using Conditional Formatting 325
Show Me Media 14.4—Modifying and Enhancing Charts 328
Chapter 15: Working with Databases and Multiple Worksheets 332
Show Me Media 15.1—Sorting a Database on Multiple Fields 334
Tell Me More Media 15.2—Sorting on Conditional Formatting 334
Show Me Media 15.3—Filtering Data 335
Show Me Media 15.4—Using the Pointing Method for 3D Formulas 342
Chapter 16: Using Review Features 344
Show Me Media 16.1—Reviewing Each Edit and Comment in Word 349
Show Me Media 16.2—Turning On and Protecting Track Changes in Excel 351
Show Me Media 16.3—Accepting and Rejecting Changes in Excel 355
Show Me Media 16.4—Comparing and Reviewing Presentations 358
Chapter 17: Collaborating 360
Show Me Media 17.1—Touring the Document Connection Window 363
Show Me Media 17.2—Uploading Files to a SkyDrive Folder 364
Tell Me More Media 17.3—Working with Documents on SharePoint 365
Show Me Media 17.4—Presenting a PowerPoint Presentation on the Web 368
Table of Contents 9
1 Getting Started with Word 24
Selecting a Document Template 24
Exploring the Word Window 25
Touring the Menus 27
Getting Familiar with the Toolbars 28
Getting Familiar with the Ribbon 28
Changing the View 29
Deciphering the Status Bar 32
Viewing Other Screen Features 32
Working with Documents 33
Creating a New Document 33
Saving a Document 34
Printing a Document 37
E-mailing a Document 43
Creating Special Documents from Templates 44
Setting Preferences for Word 45
Exploring the Preferences Dialog Box 45
Setting a Few Preferences 46
2 Editing Documents 49
Navigating 49
Using Scroll Bars 50
Using Keystrokes to Navigate 50
Using Browse Objects 51
Using Window Techniques 52
Finding and Replacing Text 53
Deleting, Copying, and Moving 59
Deleting Text 60
Copying and Pasting Text 60
Moving Text 64
Checking Spelling and Grammar 65
3 Formatting Documents 69
Formatting the Page 69
Setting Margins and Headers and Footers 69
Setting Layout Options 71
Setting Paper Size and Orientation 73
Setting Page Formats Using the Ribbon 74
Using Themes 74
Formatting Characters 75
Formatting Paragraphs 77
Using Styles 85
Applying Styles 86
Modifying Styles 88
Creating a User-Defined Style 90
Inserting Graphics 91
Using Columns 93
Working with Tables 94
Creating a Table 95
Setting Table Properties 98
Moving Around and Entering Text in a Table 99
Fine-Tuning the Structure of a Table 99
Formatting Tables 103
Creating Envelopes and Labels 106
4 Exploring Other Features 110
Using the AutoCorrect Components 110
Using AutoCorrect 110
Using AutoFormat As You Type 112
Using AutoText 114
Using the Thesaurus 116
Creating a Macro 118
Flagging for Follow-Up 121
Working with Photos 121
Adding a Photograph to a Document 121
Resizing and Cropping Photographs 122
Adding Borders and Styles 123
Adjusting Photos 125
Using Filters 127
Removing the Background of a Photograph 128
Adding Effects to Photos 130
Resetting a Photograph 131
Working with Layers 131
5 Using the Notebook 134
Creating and Customizing a Notebook 134
Setting Up the Notebook 136
Renaming Tabs 136
Adding Tabs 137
Deleting Tabs 137
Specifying Colors for Tabs 138
Using Page Numbers 139
Storing Information 139
Typing and Organizing Information 140
Inserting Outlook Information 142
Recording Audio 143
Scribbling 144
Inserting Media from the Media Browser 146
Managing Your Information 146
Flagging Text 147
Sorting Text 148
Creating an Outlook Task 148
Searching for Text 149
6 Creating Documents for Publication 150
Examining the Publishing Layout View 150
Creating a New Publication 151
Using a Blank Template 151
Using a Designed Template 151
Saving a Publication 153
Setting Up the Graphic Environment 153
Setting Options for Nonprinting Guides 153
Getting Acquainted with the Publishing Tools 155
Laying Out a Publication 156
Creating Master Pages 156
Creating Content Pages 157
Inserting and Working with Text Boxes 157
Adding the Story to the Linked Text Boxes 158
Breaking a Story into Two Stories 159
Deleting a Text Box in a Linked Set 159
Formatting Text Boxes 160
Inserting and Working with Shapes 161
Changing the Style of a Shape 163
Changing to a Different Shape 163
Changing the Fill and Outline 164
Inserting and Working with SmartArt 166
Modifying a SmartArt Graphic 168
Changing the Style of a SmartArt Graphic 168
Changing the Color of a SmartArt Graphic 169
Resetting a SmartArt Graphic 170
Inserting Media from the Media Browser 170
Getting Acquainted with the Photos Tab 170
Getting Acquainted with the Audio Tab 171
Getting Acquainted with the Movies Tab 172
Getting Acquainted with the Clip Art Tab 172
Getting Acquainted with the Symbols Tab 173
Getting Acquainted with the Shapes Tab 173
Manipulating the Objects in a Publication 173
Changing the Stacking Order of Objects 173
Resizing Objects 174
Aligning Objects 174
Distributing Objects 175
Rotating and Flipping Objects 176
Grouping Objects 176
7 Using E-mail 178
Exploring the Mail Interface 178
Understanding the Client/Server Relationship 180
Viewing and Reading E-mail 182
Opening and Saving Attachments 183
Sending Messages: The Basics 185
Composing a New Message 185
Sending Replies to Messages 187
Forwarding a Message 187
Changing Your Mind 188
Sending Messages with Bells and Whistles 188
Attaching Files and Inserting Pictures 188
Selecting the Message's Format 189
Formatting the Text 190
Using a Background Color 190
Using a Background Photo or Picture 191
Assigning a Priority 192
Using Signatures 192
Finding Messages 194
Sorting Messages 194
Grouping Messages in Conversations 195
Filtering 195
Searching for Messages with the Spotlight 196
Deleting Messages 198
Handling Junk Mail 199
Working with Folders 201
8 Using Contacts 202
Exploring the Contacts Interface 202
Adding Contacts to the Address Book 204
Finding Contacts 210
Sorting Contacts 210
Using a Spotlight Search 210
Using Contacts Search 211
Communicating with Contacts 212
Editing and Deleting Contacts 213
Editing the Contact Form 214
Sending an Electronic Business Card 215
Sending Mass E-mails 216
Categorizing Contacts 218
Editing Categories 218
Assigning and Removing Categories 220
Viewing Contacts by Category 221
Printing the Address Book 221
Using Folders 223
9 Using the Calendar 224
Exploring the Calendar Window 224
Viewing and Navigating the Calendar 225
Changing the View 225
Navigating 228
Creating Appointments and Meetings 229
Creating a Recurring Appointment 232
Creating an Event 233
Scheduling a Meeting 233
Searching for Appointments 235
Editing and Deleting Appointments 236
Printing the Calendar 238
Using My Day 239
10 Using Tasks and Notes 241
Exploring the Tasks and Notes Windows 241
Using Tasks 242
Creating Tasks 243
Editing and Deleting Tasks 245
Viewing Tasks 246
Marking a Task as Complete 247
Using Notes 248
Editing and Deleting Notes 248
Viewing Notes 249
E-mailing Notes 249
11 Getting Started with PowerPoint 250
Using Themes and Templates 250
Exploring the PowerPoint Window 253
Building the Presentation 255
Creating a Presentation One Slide at a Time 255
Creating a Presentation from an Outline 262
Creating a Presentation with Both Methods 264
Saving a Presentation 265
Modifying the Presentation 266
Editing a Slide 266
Deleting a Slide 267
Duplicating a Slide 268
Changing the Slide Order 268
Hiding a Slide 268
Adding Notes to a Slide 268
Changing the Theme 268
Presenting the Show 269
12 Creating Sophisticated Presentations 271
Grouping Slides in Sections 271
Adding Tables, Charts, and SmartArt 274
Inserting a Table 275
Inserting a Chart 276
Inserting SmartArt 277
Using Actions 277
Adding Animation and Transitions 280
Adding Animation to Presentations 280
Adding Transitions Between Slides 283
Adding Audio and Video 285
Adding Audio to a Presentation 285
Adding Video to a Presentation 285
Creating and Presenting Custom Slide Shows 286
Polishing Your Presentation Skills 288
Presenting with Presenter View 288
My Top Five Tips 289
13 Getting Started with Excel 291
Exploring the Window 291
Entering and Editing Data in Cells 293
Editing Data 295
Deleting Data 295
Copying, Cutting, and Pasting Cells 296
Enlisting Excel's Help Entering Data 296
Entering Comments 297
Working with Formulas 297
Constructing a Formula 298
Understanding the Order of Precedence 299
Using a Function 301
Entering a Formula or Function 303
Copying Formulas 304
Correcting Formula Errors 306
Printing a Worksheet 307
Setting the Page Layout and Print Options 307
Previewing the Sheet Before Printing 310
Sending the Sheet to Print 311
14 Enhancing Worksheets 312
Configuring the Worksheet for Your Data 312
Changing the Column Width 312
Changing the Row Height 314
Merging and Centering Cells 314
Inserting and Deleting Columns and Rows 315
Inserting and Deleting Cells 315
Hiding and Unhiding Columns and Rows 317
Formatting 317
Formatting the Font 317
Changing the Alignment 318
Changing the Orientation 318
Wrapping Text in a Cell 319
Using Number Formats 319
Using Styles 322
Using Conditional Formatting 324
Working with Large Worksheets 325
Freezing and Unfreezing Panes 325
Splitting the Pane 326
Working with Charts and Graphic Elements 326
Working with Charts 327
Inserting and Deleting Sparklines 329
Inserting and Deleting SmartArt 330
Adding Media 331
15 Working with Databases and Multiple Worksheets 332
Creating a Database 332
Sorting Data 333
Filtering a Database 335
Working with Additional Sheets 337
Adding and Renaming Sheets 337
Deleting a Sheet 338
Copying a Sheet 338
Moving a Sheet 338
Hiding and Unhiding a Sheet 338
Working with Grouped Sheets 339
Grouping Sheets 339
Ungrouping Sheets 340
Using 3D Formulas 341
Using the Proper Syntax for 3D Formulas 341
Entering 3D Formulas by Pointing 342
16 Using Review Features 344
Examining the Editorial Process 344
Reviewing Word Documents 345
Author: Getting a Document Ready for an Editor 345
Editor: Making Changes to the Document 347
Author: Reviewing the Edits 347
Reviewing Excel Workbooks 350
Author: Getting a Workbook Ready for an Editor 350
Editor: Making Changes to the Workbook 353
Author: Reviewing the Worksheet Edits 354
Reviewing PowerPoint Presentations 356
17 Collaborating 360
Surveying the Collaboration Landscape 360
Using Microsoft Document Connection 361
Exploring the Document Connection Window 362
Putting Files on SkyDrive 363
Working with Files in the Cloud 365
Collaborating on SkyDrive Files 366
Broadcasting a PowerPoint Presentation 368
Remote Desktop 370
Chapter 1: Getting Started with Word 24
Tell Me More: Media 1.1—Creating Automator Workflows 28
Show Me: Media 1.2—Printing a Document with the Print Command 37
Show Me: Media 1.3—E-mailing a Document 43
Show Me: Media 1.4—Creating a Calendar from a Template 44
Chapter 2: Editing Documents 49
Show Me: Media 2.1—Using Browse Objects to Navigate 52
Show Me: Media 2.2—Using the Advanced Find and Replace Command 54
Show Me: Media 2.3—Using the Scrapbook 63
Tell Me More: Media 2.4—Setting Grammar Preferences 68
Chapter 3: Formatting Documents 69
Show Me: Media 3.1—Setting Paragraph Alignment, Indents, and Spacing 80
Show Me: Media 3.2—Setting Tabs in the Tabs Dialog Box 82
Show Me: Media 3.3—Setting Tabs on the Ruler 83
Tell Me More: Media 3.4—Using Quick Styles 90
Show Me: Media 3.5—Drawing a Table 97
Chapter 4: Exploring Other Features 110
Show Me: Media 4.1—Creating an AutoText Entry 115
Show Me: Media 4.2—Using the Thesaurus 116
Show Me: Media 4.3—Recording a Macro 118
Tell Me More: Media 4.4—Macros and Security Issues 120
Show Me: Media 4.5—Removing the Background of a Photo 129
Chapter 5: Using the Notebook 134
Show Me: Media 5.1—Numbering Text in a Notebook 140
Show Me: Media 5.2—Recording Audio Notes in a Notebook 143
Tell Me More: Media 5.3—Setting Audio Preferences 144
Show Me: Media 5.4—Using the Scribble Tools 145
Chapter 6: Creating Documents for Publication 150
Show Me: Media 6.1—Using a Template to Create a Publication 151
Tell Me More: Media 6.2—Exploring Lorem Ipsum Text 153
Show Me: Media 6.3—Creating Linked Text Boxes and Filling Them with a Story 158
Show Me: Media 6.4—Inserting a SmartArt Graphic 167
Chapter 7: Using E-mail 178
Tell Me More: Media 7.1—Setting Up an Exchange Account 182
Show Me: Media 7.2—Applying a Background Color 190
Show Me: Media 7.3—Creating Signatures 193
Show Me: Media 7.4—Deleting E-mail Messages 198
Chapter 8: Using Contacts 202
Tell Me More: Media 8.1—Performing Advanced Searches 210
Show Me: Media 8.2—Adding and Deleting Fields on a Contact Form 214
Show Me: Media 8.3—Creating a Contact Group 216
Show Me: Media 8.4—Adding and Deleting Categories 219
Chapter 9: Using the Calendar 224
Show Me: Media 9.1—Customizing the Work View 226
Show Me: Media 9.2—Creating a Nonrecurring Appointment 230
Show Me: Media 9.3—Setting a Recurring Appointment 232
Tell Me More: Media 9.4—Setting Preferences for My Day 240
Chapter 10: Using Tasks and Notes 241
Show Me: Media 10.1—Creating a Task 243
Show Me: Media 10.2—Creating a Recurring Task 244
Show Me: Media 10.3—Making Changes to a Task 245
Tell Me More: Media 10.4—Creating Separate To-Do Lists with Categories 247
Show Me: Media 10.5—Creating Notes 248
Chapter 11: Getting Started with PowerPoint 250
Show Me: Media 11.1—Adding a Slide 256
Show Me: Media 11.2—Adding Text to a Placeholder 257
Show Me: Media 11.3—Adding a Photo to a Placeholder 259
Show Me: Media 11.4—Working with Layers 262
Show Me: Media 11.5—Typing the Outline for a Presentation 263
Show Me: Media 11.6—Creating a Presentation with Both Methods 265
Tell Me More: Media 11.7—Editing the Master Slide Layouts 267
Chapter 12: Creating Sophisticated Presentations 271
Show Me: Media 12.1—Assigning an Action 278
Show Me: Media 12.2—Animating Slide Elements 280
Show Me: Media 12.3—Applying a Transition 283
Tell Me More: Media 12.4—Annotating Slides 289
Chapter 13: Getting Started with Excel 291
Show Me: Media 13.1—Taking a Tour of the Excel Window 293
Show Me: Media 13.2—Entering a Formula with the Pointing Method 303
Show Me: Media 13.3—Copying Formulas with Relative Cell References 305
Tell Me More: Media 13.4—Using Absolute Cell References 305
Chapter 14: Enhancing Worksheets 312
Show Me: Media 14.1—Inserting Cells 315
Show Me: Media 14.2—Creating an Excel Style 324
Tell Me More: Media 14.3—Using Conditional Formatting 325
Show Me: Media 14.4—Modifying and Enhancing Charts 328
Chapter 15: Working with Databases and Multiple Worksheets 332
Show Me: Media 15.1—Sorting a Database on Multiple Fields 334
Tell Me More: Media 15.2—Sorting on Conditional Formatting 334
Show Me: Media 15.3—Filtering Data 335
Show Me: Media 15.4—Using the Pointing Method for 3D Formulas 342
Chapter 16: Using Review Features 344
Show Me: Media 16.1—Reviewing Each Edit and Comment in Word 349
Show Me: Media 16.2—Turning On and Protecting Track Changes in Excel 351
Show Me: Media 16.3—Accepting and Rejecting Changes in Excel 355
Show Me: Media 16.4—Comparing and Reviewing Presentations 358
Chapter 17: Collaborating 360
Show Me: Media 17.1—Touring the Document Connection Window 363
Show Me: Media 17.2—Uploading Files to a SkyDrive Folder 364
Tell Me More: Media 17.3—Working with Documents on SharePoint 365
Show Me: Media 17.4—Presenting a PowerPoint Presentation on the Web 368

2011-03-04