You are previewing Office for iPad and Mac For Dummies.
O'Reilly logo
Office for iPad and Mac For Dummies

Book Description

The easy way to work with Office on your iPad or Mac

Are you a Mac user who isn't accustomed to working with Microsoft Office? Consider this friendly guide your go-to reference! Written in plain English and packed with easy-to-follow, step-by-step instructions, Office for iPad and Mac For Dummies walks you through every facet of Office, from installing the software and opening files to working with Word, Excel, PowerPoint, and Outlook—and beyond. Plus, you'll discover how to manage files, share content and collaborate online through social media, and find help when you need it.

Two things are clear: the iPad and Microsoft Office are here to stay. Office for iPad was downloaded 27 million times in its first six weeks on the Apple app store, and Office 365 received nearly one million new subscribers in the last quarter reported. While iPads continue to dominate the enterprise with a 91% market share, the current version of Office for Mac is fully supported by Office 365 and brings Exchange support via Outlook and native compatibility with Windows Office documents. There's never been a better time to bring Office to your iPad or Mac, and this hands-on guide makes it easier than ever to get up and running fast.

  • Take advantage of Word and its many features and tools

  • Make impressive PowerPoint presentations using your Mac or iPad

  • Use Excel to refine worksheets for data analysis and reporting

  • Email with Outlook on a Mac or iPad

  • If you're an Apple enthusiast who wants to get the most out of Microsoft Office, Office for iPad and Mac For Dummies shows you how simplifying and organizing your work or personal life is just a click away.

    Table of Contents

      1. Cover
      2. Introduction
        1. About This Book
        2. Foolish Assumptions
        3. Icons Used in This Book
        4. Beyond the Book
        5. Where to Go from Here
      3. Part I: Getting Started with Office for iPad and Mac
        1. Chapter 1: iPad for Beginners
          1. What Is Office for the iPad?
          2. What Is Office 2011 for Mac?
          3. What Is Office 365?
          4. Subscribing to Office 365
          5. Installing Office for iPad
          6. iPad — the Basics
          7. Understanding the Screen Gestures
          8. Running Apps on the iPad
          9. Controlling the Volume
          10. Handling Internet Wi-Fi Connections
        2. Chapter 2: Making the iPad Work Your Way
          1. Downloading and Installing Apps
          2. Tidying the Home Screen
          3. Deleting an App
          4. Hanging Some Wallpaper
          5. Handling Passcodes
        3. Chapter 3: Exploring Office for the iPad Basics
          1. Working with Files (Documents, Workbooks, and Presentations)
          2. A Quick Tour of the Office for iPad Interface
          3. Shrinking and Enlarging the Screen
          4. Handling and Manipulating Text
          5. Making Bulleted and Numbered Lists
          6. Finding and Replacing Text
      4. Part II: Word
        1. Chapter 4: Word for the iPad
          1. Applying Styles
          2. Laying Out the Page
          3. Spell Checking Your Work
          4. Putting Footnotes in Documents
          5. Tracking Editorial Changes
        2. Chapter 5: Creating Sophisticated Documents with Word 2011
          1. Introducing the Word Screen
          2. Creating a New Document
          3. Getting a Better Look at Your Documents
          4. Selecting Text in Speedy Ways
          5. Moving Around Quickly in Documents
          6. Inserting a Whole File into a Document
          7. Inserting Line, Page, and Section Breaks
          8. Setting Up and Changing the Margins
          9. Indenting Paragraphs and First Lines
          10. Numbering the Pages
          11. Putting Headers and Footers on Pages
          12. Adjusting the Space between Lines
          13. Adjusting the Space between Paragraphs
          14. Creating Numbered and Bulleted Lists
          15. Hyphenating Text
        3. Chapter 6: Word Styles
          1. All about Styles
          2. Applying Styles to Text and Paragraphs
          3. Creating a New Style
          4. Modifying a Style
          5. Creating Templates
        4. Chapter 7: Constructing the Perfect Table
          1. Talking Table Jargon
          2. Creating a Table
          3. Entering the Text and Numbers
          4. Selecting Different Parts of a Table
          5. Aligning Text in Columns and Rows
          6. Merging and Splitting Cells
          7. Laying Out Your Table
          8. Formatting Your Table
          9. Using Math Formulas in Tables
        5. Chapter 8: Getting the Most Out of Word
          1. Correcting Your Spelling Errors
          2. Finding the Right Word with the Thesaurus
          3. Churning Out Letters, Envelopes, and Labels for Mass Mailings
          4. Outlines for Organizing Your Work
          5. Generating a Table of Contents
          6. Indexing a Document
          7. Putting Cross-References in a Document
          8. Putting Footnotes and Endnotes in Documents
      5. Part III: Excel
        1. Chapter 9: Excel for the iPad
          1. Finding Your Way Around the Excel Screen
          2. Changing Your View of a Worksheet
          3. Entering and Editing Data
          4. Choosing a Format for Data
          5. Adding and Deleting Worksheets
          6. Constructing a Formula
          7. Dressing Up a Worksheet
          8. Presenting Data in a Table
        2. Chapter 10: Up and Running with Excel 2011
          1. Creating an Excel Workbook
          2. Getting Acquainted with Excel
          3. Entering Data in a Worksheet
          4. Quickly Entering Lists and Serial Data with the AutoFill Command
          5. Formatting Numbers, Dates, and Time Values
          6. Conditional Formats for Calling Attention to Data
          7. Establishing Data-Validation Rules
        3. Chapter 11: Refining Your Worksheet
          1. Editing Worksheet Data
          2. Moving Around in a Worksheet
          3. Getting a Better Look at the Worksheet
          4. Comments for Documenting Your Worksheet
          5. Selecting Cells in a Worksheet
          6. Deleting, Copying, and Moving Data
          7. Handling the Worksheets in a Workbook
          8. Keeping Others from Tampering with Worksheets
          9. How Formulas Work
          10. The Basics of Entering a Formula
          11. Speed Techniques for Entering Formulas
          12. Copying Formulas from Cell to Cell
          13. Detecting and Correcting Errors in Formulas
          14. Working with Functions
        4. Chapter 12: Creating a Chart
          1. The Basics: Creating a Chart
          2. Choosing the Right Chart
          3. Positioning Your Chart in a Workbook
          4. Changing a Chart’s Appearance
          5. Saving a Chart as a Template So That You Can Use It Again
          6. Chart Tricks for the Daring and Heroic
      6. Part IV: PowerPoint
        1. Chapter 13: PowerPoint for the iPad
          1. Finding Your Way Around the Screen
          2. Handling Text and Text Boxes
          3. Adding, Reordering, and Removing Slides
          4. Writing and Reading Notes
          5. Applying Slide Transitions
          6. Giving a Presentation
        2. Chapter 14: Getting Started in PowerPoint 2011
          1. Getting Acquainted with PowerPoint
          2. A Brief Geography Lesson
          3. Creating a New Presentation
          4. Advice for Building Persuasive Presentations
          5. Creating New Slides for Your Presentation
          6. Getting a Better View of Your Work
          7. Hiding and Displaying the Slides Pane and Notes Pane
          8. Selecting, Moving, and Deleting Slides
          9. Hidden Slides for All Contingencies
        3. Chapter 15: Fashioning a Look for Your Presentation
          1. Looking at Themes and Background Styles
          2. Choosing a Theme for Your Presentation
          3. Creating Slide Backgrounds on Your Own
          4. Changing the Background of a Single Slide or Handful of Slides
          5. Using Master Slides and Master Styles for a Consistent Design
          6. Putting Footers (and Headers) on Slides
        4. Chapter 16: Delivering a Presentation
          1. All about Notes
          2. Rehearsing and Timing Your Presentation
          3. Showing Your Presentation
          4. Tricks for Making Presentations a Little Livelier
          5. Delivering a Presentation When You Can’t Be There in Person
      7. Part V: Sharing and Collaborating with Office 365
        1. Chapter 17: Managing Files and Folders on OneDrive
          1. Signing In to OneDrive
          2. Exploring the OneDrive Window
          3. Managing Your OneDrive Folders
          4. Uploading Files to a Folder on OneDrive
          5. Saving a File to OneDrive
          6. Downloading Files from OneDrive to Your Computer
          7. Managing Your Files on OneDrive
          8. Syncing Files between OneDrive and Your Machine
        2. Chapter 18: File Sharing and Collaborating
          1. Sharing Files: The Big Picture
          2. Sharing Your Files and Folders with Others
          3. Seeing Files and Folders Others Shared with You
          4. Investigating and Changing How Files and Folders Are Shared
      8. Part VI: The Part of Tens
        1. Chapter 19: Ten-Plus Functions for Crunching Numbers
          1. AVERAGE for Averaging Data
          2. COUNT and COUNTIF for Tabulating Data Items
          3. CONCATENATE for Combining Values
          4. PMT for Calculating How Much You Can Borrow
          5. IF for Identifying Data
          6. LEFT, MID, and RIGHT for Cleaning Up Data
          7. PROPER for Capitalizing Words
          8. LARGE and SMALL for Comparing Values
          9. NETWORKDAY and TODAY for Measuring Time in Days
          10. LEN for Counting Characters in Cells
        2. Chapter 20: Ten Tips for Making Glorious PowerPoint Presentations
          1. Don’t Let PowerPoint Tell You What to Do
          2. Make Your Company Colors Part of the Design
          3. Use Large Fonts
          4. Use the Animation Feature in Bulleted Lists
          5. Use Visuals, Not Just Words, to Make Your Point
          6. Navigate in a Nonlinear Fashion
          7. Ask the Audience Questions
          8. Pretend You’re Speaking to Friends
          9. Take Advantage of the Slide Show Gizmos
          10. Spell Check Your Presentation
        3. Chapter 21: Ten Things All iPad Users Should Know
          1. Fix an iPad Screen That Won’t Rotate
          2. Turn Down the Brightness to Save Battery Strength
          3. Place Apps on the Dock
          4. Browse the Internet in Private
          5. Invert Colors to Work in the Dark
          6. Take a Picture of the Screen
          7. Split the Keyboard in Half
          8. Use Your iPad in Flight
          9. Make Folders for Storing Apps on the Home Screen
          10. Turn on Multitasking Gestures
      9. About the Author
      10. Cheat Sheet
      11. Advertisement Page
      12. Connect with Dummies
      13. End User License Agreement