Home > Store

My Office for iPad

Register your product to gain access to bonus material or receive a coupon.

My Office for iPad

eBook (Watermarked)

  • Your Price: $15.99
  • List Price: $19.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.


  • Copyright 2015
  • Dimensions: 6" x 9"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-326099-2
  • ISBN-13: 978-0-13-326099-1

Covers Excel, Word, PowerPoint, and OneNote for iPad

Step-by-step instructions with callouts to new Office for iPad screenshots that show you exactly what to do.
Help when you run into Office problems or limitations.
Tips and Notes to help you get the most from Office on your iPad.

Full-color, step-by-step tasks walk you through doing exactly what you want with Office. Learn how to:
• Master core skills you can use in every Office for iPad program
• Quickly create highly visual documents with advanced formatting and graphics
• Enter, edit, and work efficiently with text in Word
• Build complex documents with tables, headers, footers, columns, and footnotes
• Enter and organize Excel data more accurately and efficiently
• Visualize Excel data with charts
• Efficiently create high-powered PowerPoint presentations
• Add pizzazz to PowerPoint slide shows with transitions
• Bring all your ideas and notes together in a OneNote notebook
• Store your Office for iPad data on OneDrive and access it from anywhere
• Get the most out of OneDrive’s tools for working with files and folders
• Collaborate with others, including people using other versions of Office

For working professionals, Microsoft Office has been the #1 most requested software for iPad. It's in a powerful touch-based version that's fully designed for iPad and mobile work. Now, you can get the most out of Office for iPad -- the fast, easy way! Friendly, direct, and 100% practical, My Office for iPad  is the must-have companion for every Microsoft Office for iPad user.

Sample Content

Table of Contents

Introduction     1
Welcome to My Office for iPad      2
Chapter 1  Getting Started with Office for iPad     5
Understanding Office 365 and Office for iPad      6
   Learning How Office 365 Works      6
   Comparing Office for iPad with Desktop Office      7
Taking Your First Steps with Office for iPad      8
   Sign In to Your Microsoft Account      9
   Create a Microsoft Account      11
   Purchase an Office 365 Subscription      13
   Sign Out of Your Microsoft Account      15
   Switch Between Office for iPad Applications      16
   Quit an Office for iPad Application      17
Creating a New Document      17
   Create a Blank Document at Startup      18
   Create a Blank Document After an Office for iPad Application Is Running      19
   Creating a Document from a Template or Theme      20
Preserving Your Work      20
   Save a New Document      21
   Create a Duplicate of a Document      22
   Convert a Document to the Latest Format     23
Working with Documents      25
   Open a Document      25
   Pin a Document to the Recent Tab      26
   Restore an Older Version of a Document      27
Chapter 2  Formatting Documents     31
Selecting Text      32
   Select Text on a Touchscreen      33
Changing the Font      34
   Understanding Typefaces      35
   Set the Typeface      36
   Change the Type Size      36
   Apply Type Effects      38
   Set Text Colors      39
Formatting Paragraphs      40
   Align Paragraphs      40
   Set the Line Spacing     42
   Build a Bulleted List     43
   Create a Numbered List     44
   Set the Indentation      46
Working with Formatting      46
   Apply Styles      47
   Apply Text Effects      48
   Clear Formatting      49
Chapter 3  Working with Office for iPad Graphics     51
Inserting Images      52
   Insert a Picture      53
   Insert a Line      54
   Insert Any Other Shape      55
   Insert a Text Box      56
Working with Graphics      56
   Size a Graphic      57
   Move a Graphic      57
   Rotate a Graphic      58
   Reorder Graphics      59
Formatting Graphics      60
   Apply a Picture Style      60
   Add a Picture Shadow      61
   Enhance a Picture with a Reflection      62
   Apply a Shape Style      63
   Format the Shape Line and Fill      63
   Set the Text Style for a Shape or Text Box     65
Chapter 4  Working with Text in Word     67
Learning Text Basics      68
   Enter and Edit Text      68
   Entering Text with Shortcuts      69
   Insert Symbols      70
   Display the Ruler      71
   Set Tabs      71
   Enter Headings      72
Finding and Replacing Text      73
   Find Text      74
   Replace Text      75
Proofing Text      77
   Handle Spelling Errors      78
Adding Hyperlinks      79
   Insert a Hyperlink      79
Chapter 5  Working with Page Layout and Design in Word     83
Building a Table      84
   Insert a Table      84
   Select Table Elements      85
   Format a Table     86
   Insert New Rows      87
   Insert New Columns      88
   Delete Rows and Columns     89
Working with Headers and Footers      90
   Add a Header      90
   Add a Footer      93
Changing the Page Setup     94
   Change the Page Orientation      94
   Change the Paper Size      95
   Set the Margins      96
   Add a Page Break      97
   Understanding Sections      98
   Add a Section Break      99
   Display Text in Columns       100
Adding Footnotes       101
   Insert a Footnote       102
Chapter 6  Entering Excel Data     105
Understanding Worksheet Cells and Data       106
   Working with Numbers       107
   Working with Text       107
   Working with Dates and Times       108
Entering and Editing Data       109
   Enter Cell Data       110
   Edit Cell Data       111
Working with Formulas and Functions       112
   Build a Formula       113
   Understanding Functions       115
   Add a Function to a Formula       116
   Select a Function from a List       118
Building a Table       119
   Converting Cells to a Table       119
   Select Table Elements       120
   Format a Table      120
   Insert New Rows       122
   Insert New Columns       123
   Delete Rows and Columns      124
   Sorting a Table       125
   Filtering a Table       126
Chapter 7  Getting More Out of Excel Ranges     129
Selecting a Range       130
   Select a Range on a Touchscreen       130
Working with Excel Ranges       131
   Fill a Range with a Specific Value      131
   Fill a Range with a Series of Values       132
   Copy a Range       133
   Move a Range       133
   Insert a Range       134
   Delete a Range       136
Formatting a Range       137
   Learning About Data Formats       138
   Apply a Numeric or Date Format       141
   Control the Number of Decimal Places      143
   Resize a Column       144
   Resize Rows       145
   Add Borders       146
   Wrap Text Within a Cell       147
Chapter 8  Visualizing Excel Data with Charts     149
Creating a Chart      149
   Create a Chart      151
Working with Charts       152
   Understanding Excel’s Chart Types       152
   Change the Chart Type       154
   Move a Chart       156
   Resize a Chart       157
   Apply a Chart Style       158
   Modify the Chart Colors       159
   Switch the Chart Layout       160
Chapter 9  Building a PowerPoint Presentation     163
Adding a Slide to the Presentation       164
   Understanding Slide Layouts       164
   Insert a New Slide       166
   Duplicate a Slide       166
Adding Data to a Slide       167
   Adding Text       167
   Create a Bulleted List       168
   Add a Table       170
Working with Slides       171
   Rearrange Slides       171
   Hide a Slide       172
   Add Notes to a Slide       173
Chapter 10  Working with PowerPoint Slide Shows     177
Defining Slide Transitions       178
   Transition Guidelines       178
   Set Up a Slide Transition       179
   Set Transition Effect Options       180
Running a Slide Show       181
   Start the Slide Show from the Beginning       181
   Start the Slide Show from a Specific Slide       182
   Navigate Slides       183
   Annotate a Slide Show       185
Chapter 11  Building a OneNote Notebook     189
Working with Sections      190
   Insert a New Section       191
   Rename a Section       191
Working with Pages       192
   Insert a New Page       192
   Change the Page Color       193
   Entering Text on a Page      193
   Insert the Date       194
   Add a Link to a Website       195
   Working with Page Containers       197
Building a OneNote Table       197
   Insert a Table       198
Working with Tags       199
   Tag an Item       200
   Building Lists       201
   Create a To-Do List       202
Working with Notebooks       203
   Create a New Notebook       204
   Switch Between Notebooks       204
Chapter 12  Collaborating with Others     207
Collaborating in Word with Comments and Changes       207
   Insert Comments in a Word Document       208
   Edit a Comment       209
   Delete a Comment       209
   Track Changes in a Word Document       210
   Controlling the Display of Comments and Changes       210
   Control the Markup Display       212
   Navigate Comments and Changes       212
   Accept or Reject Comments and Changes       213
Collaborating in Excel with Comments       214
   View a Cell’s Comment       215
   Navigate Workbook Comments       216
   Delete a Workbook Comment       217
Sharing a Document       218
   Email a Link to a Shared Document       218
   Copy a Link to a Shared Document       220
Chapter 13  Learning OneDrive Essentials     223
Setting Up OneDrive       224
   Change Your Display Name       224
   Assign a Picture to Your Profile       225
Working with OneDrive Folders       227
   View a OneDrive Folder       228
   Navigate OneDrive Folders       229
   Create a OneDrive Folder       230
   Change the OneDrive Folder View       231
   Delete a OneDrive Folder       231
Working with Office Documents in OneDrive       232
   Create a New Office Document in OneDrive       233
   Viewing Documents Online       233
   View a OneDrive Document      234
   Edit a OneDrive Document Online       235
   Edit a OneDrive Document on Your iPad       236
Working with OneDrive Files       236
   Move a OneDrive File to Another Folder       237
   Copy a OneDrive File to Another Folder       238
   Rename a OneDrive File       239
   Delete a OneDrive File       240
Collaborating with OneDrive       240
   Send an Invitation to Share a OneDrive Document or Folder       241
   Create a Link to Share a OneDrive Document or Folder       243
   Add a Comment When Viewing a Document       245
   Add a Comment When Editing a Document       247
Appendix A  Excel Worksheet Function Reference     249
   Financial Functions       252
   Logical Functions      256
   Text Functions       256
   Date and Time Functions       258
   Lookup and Reference Functions       259
   Math and Trigonometry Functions       260
   Statistical Functions       264
   Engineering Functions       268
   Information Functions       270
   Database Functions       271
Index     273


Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020