Learn Office 2016 for Mac, 2nd Edition

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 colleagues
• Record and manipulate data using spreadsheets
• Use your data to create powerful and convincing charts
• Build persuasive multimedia presentations in PowerPoint
• Deliver presentations like an expert
• Keep your e-mail under control with Outlook
• Stay on top of your schedule and your tasks

Who This Book Is For

Table of Contents

Part 1: Building Essential Office Skills
Chapter 1: Getting Up to Speed with the Office Apps
Chapter 2: Learning Common Tools Across the Office Suite
Chapter 3: Working with Text
Chapter 4: Using Pictures and Shapes in Your Documents
Chapter 5: Customizing Office to Suit You

Part 2: Creating Documents with Microsoft Word
Chapter 6: Entering Text and Using Views
Chapter 7: Formatting Your Documents Swiftly and Easily
Chapter 8: Creating Complex Documents and Layouts
Chapter 9: Creating Business Documents with Mail Merge
Chapter 10: Revising and Reviewing Documents
Chapter 11: Printing, Securing, and Sharing Documents

Part 3: Analyzing Data withMicrosoft Excel
Chapter 12: Creating Workbooks and Entering Data
Chapter 13: Formatting Your Worksheets
Chapter 14: Creating Powerful and Persuasive Charts
Chapter 15: Crunching Numbers with Formulas and Functions
Chapter 16: Creating Simple Databases and Solving Business Problems
Chapter 17: Manipulating Data with PivotTables

Part 4: Creating Presentations withMicrosoft PowerPoint
Chapter 18: Starting to Build a Presentation in PowerPoint
Chapter 19: Creating Clear and Compelling Slides
Chapter 20: Adding Life and Interest to Your Presentation
Chapter 21: Delivering a Presentation Live or Online

Part 5: E-Mailing and Organizingwith Outlook
Chapter 22: Using E-mail Effectively
Chapter 23: Keeping Your Contacts in Order
Chapter 24: Managing Your Calendar
Chapter 25: Working with Tasks and Notes