Skip to main content
main-content

Über dieses Buch

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.

Inhaltsverzeichnis

Frontmatter

Building Essential Office Skills

Frontmatter

Chapter 1. Getting Up to Speed with the Office Applications

Abstract
You’re probably in a hurry to start being productive using Office 2011, so this chapter gets you moving quickly. First, you’ll meet each of the applications, find out what you can do with them, and come to grips with key features such as the Ribbon and the toolbars. Then, I’ll show you how to launch the applications or make them launch themselves. Finally, you’ll look at how to create, save, and close documents, as well as how to reopen them when you need to work on them again.
Guy Hart-Davis

Chapter 2. Learning Common Tools Across the Office Suite

Abstract
To save you time and effort, the Office applications have many common features, starting with the three elements you use to give most commands: the menu bar, the toolbars, and the Ribbon control interface.
Guy Hart-Davis

Chapter 3. Working with Text

Abstract
In this chapter, I’ll show you how to work with text in the Office applications. As you’ll see, the operations are almost the same for each application, so once you learn to work with text in one application, you’ll be able to work with text in each of the other applications too.
Guy Hart-Davis

Chapter 4. Using Pictures and Shapes in Your Documents

Abstract
To give your documents visual interest, you can add various types of graphical content to them—graphics themselves (I’ll use the term to cover all kinds of pictures and images), shapes (anything from a simple arrow or circle to a complex shape), charts, and even movies.
Guy Hart-Davis

Chapter 5. Customizing Office to Suit You

Abstract
Microsoft has put a lot of work into making the Office applications easy to use, but only you know exactly how you work and what you need. To make the Office applications suit you better, you can customize both their looks and their behavior.
Guy Hart-Davis

Creating Documents with Microsoft Word

Frontmatter

Chapter 6. Entering Text and Using Views

Abstract
In this chapter, I’ll show you how to enter text quickly in Word documents by using extra features that Word provides beyond those in the other applications. You’ll see how to select text in advanced ways with the mouse and the keyboard, how to move around your documents using keyboard shortcuts and the mysterious “browse object,” and how to tell Word where to find your custom templates.
Guy Hart-Davis

Chapter 7. Adding Style: Formatting Your Documents

Abstract
To make your documents look good, you must apply formatting to the text and other elements in them.
Guy Hart-Davis

Chapter 8. Creating Complex Documents and Layouts

Abstract
Once you’ve mastered the art of formatting your documents with styles (as described in Chapter 7), you’re ready to create long or complex documents in Word.
Guy Hart-Davis

Chapter 9. Creating Business Documents with Mail Merge

Abstract
In this chapter, you learn how to use Word’s powerful Mail Merge feature to create business documents such as form letters, catalogs, mailing labels, and envelopes. Each of these types of documents is built around a common core, the main document, into which you merge variable data contained in records in a data source such as an Excel workbook or an address book.
Guy Hart-Davis

Chapter 10. Revising and Reviewing Documents

Abstract
Chances are that you’ll create some documents on your own, but for other documents, you’ll need to work with other people—either sharing the documents on a network or via the Internet or using e-mail to send the documents back and forth.
Guy Hart-Davis

Chapter 11. Printing, Securing, and Sharing Documents

Abstract
In this chapter, we’ll look at how you can share your documents with other people. You’ll start by seeing how to print an entire document or the relevant pages or sections of it, how to choose whether to include markup, and how to print other parts of the document, such as markup and document properties. After that, I’ll show you how to secure your Word documents by removing sensitive information, locking the documents with passwords, and marking the documents as read-only.
Guy Hart-Davis

Analyzing Data with Microsoft Excel

Frontmatter

Chapter 12. Creating Workbooks and Entering Data

Abstract
In this chapter, you’ll get started quickly with Excel by creating and saving a new workbook. You’ll then look at how to navigate the Excel interface and work with worksheets and workbooks. You’ll learn how to enter data in worksheets, how to select and manipulate cells, and how to use Excel’s various view features to see the worksheet data you need so that you can work easily with it.
Guy Hart-Davis

Chapter 13. Formatting Your Worksheets

Abstract
In this chapter, you’ll learn how to format your worksheets so that they show the information you need and present it clearly.
Guy Hart-Davis

Chapter 14. Creating Powerful and Persuasive Charts

Abstract
In this chapter, you’ll learn how to create powerful charts that present your data clearly and persuasively. You’ll also learn how to use sparklines, miniature charts that fit inside individual cells.
Guy Hart-Davis

Chapter 15. Crunching Numbers with Formulas and Functions

Abstract
To make your worksheets deliver the information you want, you’ll probably need to perform calculations with your data. To perform calculations, you enter formulas and functions in cells, as you’ll learn to do in this chapter.
Guy Hart-Davis

Chapter 16. Creating Simple Databases and Solving Business Problems

Abstract
Packed with more than 16,000 columns and more than 1 million rows, each Excel worksheet has enough space to contain serious amounts of data—so it’s great for creating a database to store information and quickly find the items you need.
Guy Hart-Davis

Chapter 17. Manipulating Data with PivotTables

Abstract
In this chapter, we’ll look at how you can manipulate the data in your worksheets to draw conclusions from it by creating PivotTables. PivotTables are great for asking questions of your data and looking at the data in different ways without having to enter it multiple times in separate worksheets.
Guy Hart-Davis

Creating Presentations with Microsoft PowerPoint

Frontmatter

Chapter 18. Starting to Build a Presentation in PowerPoint

Abstract
In this chapter, you’ll learn how to start building a presentation in PowerPoint.
Guy Hart-Davis

Chapter 19. Creating Clear and Compelling Slides

Abstract
In this chapter, I’ll show you how to create slides that convey your meaning clearly and powerfully to your audience.
Guy Hart-Davis

Chapter 20. Adding Life and Interest to a Presentation

Abstract
In the previous two chapters, you learned how to create a presentation and how to fill it with good-looking slides that convey the message you want.
Guy Hart-Davis

Chapter 21. Delivering a Presentation Live or Online

Abstract
By this point, chances are that you’ve created a powerful and compelling presentation stuffed with great content. Now it’s time to deliver that presentation.
Guy Hart-Davis

E-mailing and Organizing with Outlook

Frontmatter

Chapter 22. Using E-mail Effectively

Abstract
In this part of the book, you’ll learn to use Outlook, Office’s heavy-duty e-mail and organizer application.
Guy Hart-Davis

Chapter 23. Keeping Your Contacts in Order

Abstract
In this chapter, I’ll show you how to use Outlook to keep your contacts in order.
Guy Hart-Davis

Chapter 24. Managing Your Calendar

Abstract
In this chapter, you’ll look at how to use Outlook to schedule your appointments and keep your calendar in order.
Guy Hart-Davis

Chapter 25. Working with Tasks and Notes

Abstract
In this chapter, I’ll show you how to work with tasks and notes in Outlook.
Guy Hart-Davis

Backmatter

Weitere Informationen

Premium Partner

    Bildnachweise