Office for Mac remains the leading productivity suite for Mac, with Apple’s iWork and the free OpenOffice.org trailing far behind. Now, it's been updated with a cleaner interface and more compatibility with Exchange and SharePoint. Learn Office 2011 for Mac OS X offers a practical, hands-on approach to using Office 2011 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user. This book provides the best combination of accessible and focused coverage of the Office 2011 applications. Rather than cover every seldom-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office. What you’ll learn How to use the common features of the Office applications—creating files, editing text and graphics, and customizing the applications to suit your needs How to create all kinds of word processing documents with Microsoft Word How to create worksheets and analyze data with Excel How to use PowerPoint to create persuasive presentations and present them in person or via the Internet How to use Outlook—now on the Mac for the first time—to keep e-mail, contacts, appointments, notes, and tasks organized Who this book is for Beginning and intermediate Mac users looking to get up to speed quickly with the Office 2011 applications and use them productively, both online and offline. Table of Contents Getting Up to Speed with the Office Applications Learning Common Tools Across the Office Suite Working with Text Using Pictures and Shapes in Your Documents Customizing Office to Suit You Entering Text and Using Views Adding Style: Formatting Your Documents Creating Complex Documents and Layouts Creating Business Documents with Mail Merge Revising and Reviewing Documents Printing, Securing, and Sharing Documents Creating Workbooks and Entering Data Formatting Your Worksheets Creating Powerful and Persuasive Charts Crunching Numbers with Formulas and Functions Creating Simple Databases and Solving Business Problems Manipulating Data with PivotTables Starting to Build a Presentation in PowerPoint Creating Clear and Compelling Slides Adding Life and Interest to a Presentation Delivering a Presentation Live or Online Using E-mail Effectively Keeping Your Contacts in Order Managing Your Calendar Working with Tasks and Notes Office for Mac remains the leading productivity suite for Mac, with Apple’s iWork and the free OpenOffice.org trailing far behind. And now it's being updated with a cleaner interface and more compatibility with Exchange and SharePoint. Learn Office 2011 for Mac OS X offers a practical, hands-on approach to using Office 2011 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user. This book provides the best combination of accessible and focused coverage of the Office 2011 applications. Rather than cover every little-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office. What you’ll learn How to use the common features of the Office applications—creating files, editing text and graphics, and customizing the applications to suit your needs. Create all kinds of word processing documents with Microsoft Word. Create worksheets and analyze data with Excel. Use PowerPoint to create persuasive presentations and present them in person or via the Internet. Use Outlook—now on the Mac for the first time—to keep e-mail, contacts, appointments, notes, and tasks organized. Who this book is for Beginning and intermediate users looking to get up to speed quickly with the Office 2011 applications and use them productively, both online and offline. Table of Contents Getting Up to Speed with the Office Applications Learning Common Tools Across the Office Suite Working with Text Using Pictures and Shapes in Your Documents Customizing Office to Suit You Entering Text and Using Views Adding Style: Formatting Your Documents Creating Complex Documents and Layouts Creating Business Documents with Mail Merge Revising and Reviewing Documents Printing, Securing, and Sharing Documents Creating Workbooks and Entering Data Formatting Your Worksheets Creating Powerful and Persuasive Charts Crunching Numbers with Formulas and Functions Creating Simple Databases and Solving Business Problems Manipulating Data with PivotTables Starting to Build a Presentation in PowerPoint Creating Clear and Compelling Slides Adding Life and Interest to a Presentation Delivering a Presentation Live or Online Using E-mail Effectively Keeping Your Contacts in Order Managing Your Calendar Working with Tasks and Notes Front Matter....Pages i-xxv Front Matter....Pages 1-1 Getting Up to Speed with the Office Applications....Pages 3-24 Learning Common Tools Across the Office Suite....Pages 25-80 Working with Text....Pages 81-109 Using Pictures and Shapes in Your Documents....Pages 111-142 Customizing Office to Suit You....Pages 143-178 Front Matter....Pages 179-180 Entering Text and Using Views....Pages 181-206 Adding Style: Formatting Your Documents....Pages 207-246 Creating Complex Documents and Layouts....Pages 247-284 Creating Business Documents with Mail Merge....Pages 285-302 Revising and Reviewing Documents....Pages 303-329 Printing, Securing, and Sharing Documents....Pages 331-342 Front Matter....Pages 343-343 Creating Workbooks and Entering Data....Pages 345-375 Formatting Your Worksheets....Pages 377-420 Creating Powerful and Persuasive Charts....Pages 421-450 Crunching Numbers with Formulas and Functions....Pages 451-477 Creating Simple Databases and Solving Business Problems....Pages 479-507 Manipulating Data with PivotTables....Pages 509-539 Front Matter....Pages 541-541 Starting to Build a Presentation in PowerPoint....Pages 543-570 Creating Clear and Compelling Slides....Pages 571-596 Adding Life and Interest to a Presentation....Pages 597-622 Front Matter....Pages 541-541 Delivering a Presentation Live or Online....Pages 623-645 Front Matter....Pages 647-647 Using E-mail Effectively....Pages 649-688 Keeping Your Contacts in Order....Pages 689-707 Managing Your Calendar....Pages 709-723 Working with Tasks and Notes....Pages 725-737 Back Matter....Pages 739-794 Office for Mac remains the leading productivity suite for Mac, with Apple ́ s iWork and the free OpenOffice.org trailing far behind. Now, it's been updated with a cleaner interface and more compatibility with Exchange and SharePoint.℗ Learn Office 2011 for Mac OS X offers a practical, hands-on approach to using Office 2011 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user. This book provides the best combination of accessible and focused coverage of the Office 2011 applications. Rather than cover every seldom-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office