Skip to main content
main-content

Über dieses Buch

A practical, hands-on approach to using Office 2016 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.

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.

This book provides the best combination of accessible and focused coverage of the Office 2016 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 Will Learn

Create professional documents for home and business using Word

Edit documents collaboratively in real time with your colleaguesRecord and manipulate data using spreadsheetsUse your data to create powerful and convincing chartsBuild persuasive multimedia presentations in PowerPointDeliver presentations like an expertKeep your e-mail under control with Outlook

Stay on top of your schedule and your tasks

Who This Book Is For

Any Mac user who needs to work with Word, Excel, PowerPoint, or Outlook either for business or for pleasure. Professionals, students, and home user alike will benefit from straightforward explanations, step-by-step instructions, and effective workarounds for everyday problems.

Inhaltsverzeichnis

Frontmatter

Building Essential Office Skills

Frontmatter

Chapter 1. Getting Up to Speed with the Office Apps

You’re probably in a hurry to start being productive using Office 2016, so this chapter gets you moving quickly. First, you’ll meet each of the apps, find out what you can do with them, and master key features such as the Ribbon and the Gallery dialog box. Then, I’ll show you how to launch the apps 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

To save you time and effort, the Office apps have many common features, starting with the three elements you use to give most commands: the menu bar, the Ribbon control interface, and the Quick Access Toolbar.

Guy Hart-Davis

Chapter 3. Working with Text

In this chapter, I’ll show you how to work with text in the Office apps. As you’ll see, the operations are almost the same for each app, so once you learn to work with text in one app, you’ll be able to work with text in each of the other apps too.

Guy Hart-Davis

Chapter 4. Using Pictures and Shapes in Your Documents

To give your documents visual interest, you can add various types of graphical content to them—graphics themselves (I’ll use this 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

Microsoft has put a lot of work into making the Office apps easy to use, but only you know exactly how you work and what you need. To make the Office apps suit you better, you can customize their user interface a little and their behavior a lot.

Guy Hart-Davis

Creating Documents with Microsoft Word

Frontmatter

Chapter 6. Entering Text and Using Views

In this chapter, I’ll show you how to enter text quickly in Word documents by using the extra features that Word provides, which go beyond those in the other apps. You’ll see how to select text in advanced ways with the pointing device and the keyboard, how to move around your documents using keyboard shortcuts and the Go To feature, and how to tell Word where to find your custom templates.

Guy Hart-Davis

Chapter 7. Formatting Your Documents Swiftly and Easily

To make your documents look good, you must apply formatting to the text and other elements in them. That’s probably obvious, but Word gives you such a wide range of formatting options that it’s easy to use the wrong ones. This chapter teaches you the right way to format a document quickly and consistently by using styles—collections of formatting—rather than by applying direct formatting piece by piece. It also shows you how to use the Sidebar pane and the Find feature to navigate your documents and how to make the most of the versatile Replace feature.

Guy Hart-Davis

Chapter 8. Creating Complex Documents and Layouts

In this chapter, you’ll learn first how to use the extra table features that Word provides over those that the Office apps share. Then I’ll show you how to break a document into multiple sections; how to add headers, footers, and page numbers; and how to create newspaper-style columns of text.

Guy Hart-Davis

Chapter 9. Creating Business Documents with Mail Merge

In this chapter, you will 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 list, or data source, such as an Excel workbook or an address book.

Guy Hart-Davis

Chapter 10. Revising and Reviewing Documents

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

In this chapter, you’ll look at how to 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

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

In this chapter, you’ll learn how to format your worksheets so that they show the information you need and present it clearly. You’ll start by looking at how to work with rows and columns—inserting, deleting, and formatting them so that your worksheet is the right shape. Then you’ll learn how to format cells and ranges, how to apply conditional formatting to quickly flag values that need attention, and how to use data validation to check for invalid entries.

Guy Hart-Davis

Chapter 14. Creating Powerful and Persuasive Charts

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, which are miniature charts that fit inside individual cells.

Guy Hart-Davis

Chapter 15. Crunching Numbers with Formulas and Functions

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

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

In this chapter, you’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

In this chapter, you’ll learn how to start building a presentation in PowerPoint.

Guy Hart-Davis

Chapter 19. Creating Clear and Compelling Slides

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 Your Presentation

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. In this chapter, you’ll look at how to inject life and interest into a presentation by adding graphics, movies and sounds, animations, and transitions. You’ll also learn to hide slides so that they don’t appear during a slide show, allowing you to keep them in reserve, and how to create custom slide shows within a presentation so that you can show only specific parts of it.

Guy Hart-Davis

Chapter 21. Delivering a Presentation Live or Online

By this point, 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

In this chapter, you’ll learn how to use Outlook to send and receive e-mail and attachments.

Guy Hart-Davis

Chapter 23. Keeping Your Contacts in Order

In this chapter, I’ll show you how to use Outlook to keep your contacts in order. I’ll start by going through how to create contacts either from scratch or by importing your existing contacts from sources such as address books or spreadsheets. After that, I’ll show you how to work with contacts: viewing and arranging your contacts to reveal the ones you need, editing contact information when necessary, and quickly starting communications to your contacts.

Guy Hart-Davis

Chapter 24. Managing Your Calendar

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

In this chapter, I’ll show you how to work with tasks and notes in Outlook.

Guy Hart-Davis

Backmatter

Weitere Informationen

Premium Partner

Neuer Inhalt

BranchenIndex Online

Die B2B-Firmensuche für Industrie und Wirtschaft: Kostenfrei in Firmenprofilen nach Lieferanten, Herstellern, Dienstleistern und Händlern recherchieren.

Whitepaper

- ANZEIGE -

Best Practices für die Mitarbeiter-Partizipation in der Produktentwicklung

Unternehmen haben das Innovationspotenzial der eigenen Mitarbeiter auch außerhalb der F&E-Abteilung erkannt. Viele Initiativen zur Partizipation scheitern in der Praxis jedoch häufig. Lesen Sie hier  - basierend auf einer qualitativ-explorativen Expertenstudie - mehr über die wesentlichen Problemfelder der mitarbeiterzentrierten Produktentwicklung und profitieren Sie von konkreten Handlungsempfehlungen aus der Praxis.
Jetzt gratis downloaden!

Bildnachweise