You are previewing Pro Office for iPad: How to Be Productive with Office for iPad.
O'Reilly logo
Pro Office for iPad: How to Be Productive with Office for iPad

Book Description

Microsoft Office for iPad is here! So learn the tips, tricks, and get around the gotchas in Microsoft Office for iPad with Pro Office for iPad. This book shows you how you can become productive quickly by avoiding those annoyances and confusions and slow-me-downs that can happen when you start using Office with your fingers!

How is Office for iPad different from Office on your Mac or PC? Which features do the Office for iPad apps have, which do they lack, and how can you work around their limitations? How can you share your files among the different versions of Office? How quickly can you work without the physical keyboard and keyboard shortcuts you're used to -- and which keyboard shortcuts can you use if you connect a hardware keyboard to your iPad?

Whether you plan to write a few letters or your dissertation, run your home office away from home, or use your iPad for daily business, Pro Office for iPad will show you how to get the most out of Word, Excel, and other Office apps on your iPad. Enjoy your new freedom and still be as productive as ever with the skills and techniques you'll learn in Pro Office for iPad.

Table of Contents

  1. Cover
  2. Title
  3. Copyright
  4. Dedication
  5. Contents at a Glance
  6. Contents
  7. About the Author
  8. About the Technical Reviewer
  9. Acknowledgments
  10. Introduction
  11. Chapter 1: Up and Running with Office for iPad
    1. Understanding What Office for iPad Is and What You Can Do with It
    2. Getting Office for iPad
      1. Downloading and Installing the Office Apps
      2. Buying an Office 365Subscription
      3. Activating the Office Apps on Your iPad
    3. Opening and Closing the Apps
      1. Opening an App from the Home Screen
      2. Launching an App by Opening a Document
      3. Switching Among Apps
      4. Making the Office Apps’ Icons Easy to Access
      5. Closing an App
    4. Choosing Settings and Resetting the Apps
      1. Choosing Settings
      2. Resettingan Office App
    5. Using Gestures to Navigate Your iPad
      1. Turning on Gestures forMultitasking
      2. Using Gestures for Multitasking
      3. Locking theScreen Orientation
    6. Summary
  12. Chapter 2: Using Common Tools in the Office Apps
    1. Launching Word and Creating a New Document
    2. Using the Ribbon
    3. Naming and Saving a Document
    4. Working with Text
      1. Placing and Moving the Insertion Point
      2. Entering Text Quickly with the Onscreen Keyboard’s Hidden Features
      3. Entering Text via Dictation
      4. Entering Text Quickly by Using Shortcuts
      5. Entering Text via Optical Character Recognition
      6. Selecting Text
      7. Using Cut, Copy, and Paste
      8. Deleting Text
      9. Connecting a Hardware Keyboard
    5. Positioning Graphics, Shapes, and Other Objects
      1. Understanding How You Position Graphical Objects
      2. Arranging Graphical Objects to Control Which Is Visible
    6. Working with Graphics
      1. Resizing and Formatting a Picture
    7. Working with Shapes
    8. Working with Text Boxes
    9. Printing from Your iPad
    10. Summary
  13. Chapter 3: Managing Your Office Documents
    1. Setting Up Your Services
      1. Adding a Service
      2. Removing a Service
      3. Signing Out from Your Account
      4. Signing In to an Account
    2. Navigating the File Management Screens
      1. Displaying the File Management Screens
      2. Creating New Documents from the New Screen
      3. Working on the Recent Screen
    3. Managing the Active Document from the File Menu
    4. Sharing Documents
      1. Understanding the Ways of Sharing a Document
      2. Sharing a Document
    5. Troubleshooting Problems with Documents
      1. Dealing with Multiple Instances of Documents
      2. Dealing with Errors
    6. Summary
  14. Chapter 4: Getting Up to Speed with Word for iPad
    1. Understanding Word for iPad’s Features and Limitations
      1. Which Features Does Word for iPad Have and Lack?
      2. What Happens to Content That Word for iPad Does Not Support?
    2. Creating a New Document on Your iPad
    3. Navigating the Word Interface
    4. Entering and Editing Text in a Document
      1. Entering Text with the Onscreen Keyboard
      2. Inserting Tabs and Line Breaks
      3. Setting Tabs
      4. Entering Text with a Hardware Keyboard
      5. Copying and Pasting Text
      6. Editing Text
    5. Summary
  15. Chapter 5: Formatting and Laying Out Your Documents
    1. Setting the Page Size, Orientation, and Margins
    2. Understanding the Different Types of Formatting
      1. Understanding Direct Formatting and When to Use It
      2. Understanding Styles and When to Use Them
    3. FormattingSee also Formatting Your Documents the Best Way
    4. Applying Styles
    5. Applying Direct Formatting
      1. Applying Font Formatting
      2. Applying Paragraph Formatting
      3. Pasting Formatting
    6. Using Word’s Extra Table Features
      1. Converting Existing Text to a Table
      2. Using AutoFit
      3. Repeating Table Headers on Each Page
    7. Using Sections to Create Complex Documents
    8. Creating Columns of Text
    9. Wrapping Text Around Objects
    10. Summary
  16. Chapter 6: Revising and Completing Your Documents
    1. Adding Headers, Footers, and Page Numbers
      1. Adding Headers and Footers to a Document
      2. Removing a Header or Footer
      3. Adding Page Numbers to a Document
    2. Working with Footnotes and Endnotes
      1. Deciding Between Footnotes and Endnotes
      2. Inserting a Footnote
      3. Editing and Deleting Footnotes and Endnotes
    3. Working with Comments
      1. Adding a Comment
      2. Viewing and Deleting Comments
    4. Tracking Changes in Your Documents
      1. Turning on Track Changes and Working with It
      2. Integrating Tracked Changes into a Document
    5. Editing Your Documents Simultaneously with Colleagues
      1. Editing a Document Simultaneously
      2. Working with Blocking
      3. Resolving Conflicts
    6. Summary
  17. Chapter 7: Getting Started with Excel for iPad
    1. Understanding Excel for iPad’s Features and Limitations
      1. Which Features Does Excel for iPad Have and Lack?
      2. What Happens to Content That Excel for iPad Does Not Support?
    2. Creating a New Workbook on Your iPad
    3. Navigating the Excel Interface
      1. Navigating Workbooks and Worksheets
      2. Moving the Active Cell
      3. Selecting Cells and Ranges
    4. Entering Data in a Worksheet
      1. Opening a Cell for Editing
      2. Meeting Excel’s Numbers Keyboard
      3. Typing Data in a Cell
      4. Editing a Cell’s Contents
      5. Entering Data Quickly Using the Fill Feature
      6. Pasting Data into a Worksheet
      7. Moving Data with Cut and Paste and Drag and Drop
      8. Creating Tables
    5. Setting Up Your Preferred View
      1. Choosing Which Onscreen Items to Display
      2. Freezing Panes
    6. Summary
  18. Chapter 8: Building and Formatting Worksheets
    1. Creating the Structure of Your Workbook
      1. Inserting, Deleting, and Duplicating Worksheets
      2. Renaming, Reordering, and Hiding Your Worksheets
      3. Inserting and Deleting Rows, Columns, and Cells
      4. Setting Column Width and Row Height
      5. Hiding Rows and Columns
    2. Formatting Cells and Ranges
      1. Understanding How Formatting Works in Excel
      2. Controlling How Data Appears by Applying Number Formatting
      3. Applying Direct Formatting
      4. Formatting with Cell Styles
      5. Applying Table Formatting
    3. Using Find and Replace
    4. Sorting and Filtering Your Data
      1. Sorting Data
      2. Filtering Data
    5. Working with Comments
    6. Printing a Workbook
    7. Summary
  19. Chapter 9: Using Formulas and Functions in Your Worksheets
    1. Understanding the Difference Between Formulas and Functions
    2. Referring to Cells and Ranges in Formulas and Functions
      1. Referring to a Cell
      2. Referring to a Range
      3. Making One Row or Column Refer to Another Row or Column
    3. Creating Formulas to Perform Custom Calculations
      1. Understanding Excel’s Calculation Operators
      2. Using the Calculation Operators
      3. Overriding the Order in Which Excel Evaluates Operators
      4. Nesting Parts of a Formula to Control Operator Precedence
    4. Inserting Functions to Perform Standard Calculations
      1. Understanding Function Syntax
      2. Inserting a Function
      3. Nesting One Function Inside Another Function
      4. Meeting Excel’s Most Useful Functions
      5. SUM
      6. AVERAGE, MEDIAN, and MODE
      7. MAX and MIN
      8. DAY, MONTH, and YEAR
      9. IF
      10. ISBLANK, NA, and ISNA
      11. LEFT, RIGHT, and MID
      12. TRIM
      13. PI
    5. Summary
  20. Chapter 10: Creating Effective Charts
    1. Learning the Essentials of Charts in Excel
      1. Understanding Embedded Charts and Chart Sheets
      2. Understanding the Components of a Chart
    2. Choosing the Best Chart Type for Your Data
    3. Creating, Laying Out, and Formatting a Chart
      1. Creating a Chart
      2. Changing the Chart Type
      3. Switching the Rows and Columns in a Chart
      4. Changing the Source Data for a Chart
      5. Choosing the Layout and Adding Any Titles Needed
      6. Applying a Style and Changing the Colors
    4. Copying and Pasting a Chart
    5. Summary
  21. Chapter 11: Becoming Expert with PowerPoint for iPad
    1. Understanding PowerPoint for iPad’s Features and Limitations
      1. Which Features Does PowerPoint for iPad Have and Lack?
      2. What Happens to Content That PowerPoint for iPad Does Not Support?
    2. Creating a New Presentation on Your iPad
    3. Opening a Presentation
    4. Navigating the PowerPoint Interface
    5. Adding, Deleting, and Rearranging Slides
      1. Adding a Slide
      2. Deleting a Slide
      3. Rearranging Slides
      4. Duplicating a Slide
      5. Cutting and Copying Slides
      6. Hiding a Slide
    6. Adding Content to a Slide
      1. Adding Text
      2. Adding Text Boxes to Slides
      3. Adding Pictures to Slides
      4. Adding Videos to Slides
      5. Adding Tables, Shapes, and Text Boxes to Slides
      6. Adding a Chart from Excel to a Slide
      7. Adding Notes to Slides
    7. Adding Transition Effects Between Slides
    8. Reviewing Comments
    9. Giving a Presentation from Your iPad
      1. Ways of Giving a Presentation from Your iPad
      2. Setting Up the Presentation
      3. Delivering the Presentation
    10. Summary
  22. Chapter 12: Taking Notes in OneNote
    1. Understanding How OneNote for iPad Works and What It Can and Cannot Do
    2. Setting Up Your Notebooks
      1. Launching OneNote and Opening a Notebook
      2. Exploring the OneNote Interface
    3. Working with Notebooks, Sections, and Pages
      1. Looking Around in the Personal Notebook
      2. Adding a Section to a Notebook
      3. Deleting a Section
      4. Renaming and Reorganizing Sections
      5. Working with Section Groups
      6. Adding Pages
    4. Entering Notes on a Page
      1. Understanding Which Types of Information You Can Save in OneNote
      2. Adding Text to a Page
      3. Adding Graphics to a Page
      4. Creating Tables
      5. Applying Tags
      6. Using the Find Feature
    5. Sharing Your Notes with Others
    6. Summary
  23. Index