Home > Store

Microsoft Office for iPad Step by Step

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

Microsoft Office for iPad Step by Step

eBook (Watermarked)

  • Your Price: $19.19
  • List Price: $23.99
  • Includes EPUB 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.

    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: 7-3/8" x 9"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-7356-9700-0
  • ISBN-13: 978-0-7356-9700-3

The quick way to learn Microsoft Word, Excel, PowerPoint, and OneNote for iPad!

This is learning made easy. Get productive fast with every Office for iPad app--plus OneNote, too! Jump in wherever you need answers--brisk lessons and colorful screen shots show you exactly what to do, step by step.

  • Quickly create Word documents by tapping, typing, or dictating
  • Organize and design professional documents of all kinds
  • Visually analyze information in tables, charts, and PivotTables
  • Deliver highly effective presentations in PowerPoint straight from your iPad
  • Save and send PDFs, with or without Office 365
  • Use OneNote to capture and share everything from text to iPad photos
Now in full color!
  • Easy lessons for essential tasks
  • Big full-color visuals
  • Skill-building practice files
Download your Step by Step practice files at: http://aka.ms/iPadOfficeSBS/files

Sample Content

Table of Contents

Introduction     xi
Who this book is for     xi
The Step by Step approach     xi
Download the practice files     xii
Sidebar: Adapt exercise steps     xiv
Ebook edition     xvi
Get support and give feedback     xvi
Part 1: Get started with Microsoft Office for iPad
Chapter 1: Office for iPad basics     3

Install Office for iPad apps     4
Hardware requirements     4
Sidebar: iTunes support for the iPad     5
Installation options     7
Microsoft account options     10
Office 365 subscription options     11
Configure iPad and Office app settings     15
Update Office apps     18
Remove and reinstall Office apps     22
Skills review     23
Practice tasks     24
Chapter 2: Get connected     27
Start and activate apps     28
Connect to an account     28
Sidebar: Organize apps in folders     30
Manage account connections     31
Sidebar: Alternative file access methods     34
Connect to additional storage locations     35
Sidebar: Use OneDrive to work anywhere     36
Connect to your OneDrive     38
Sidebar: Synchronize OneDrive with desktop computers     40
Get help with Office apps     41
Exit files and apps     43
Skills review     44
Sidebar: Switch among running apps     45
Practice tasks     46
Chapter 3: Create and manage files     49
Create, open, and save files     50
Create files     50
Open files     52
Sidebar: Switch among files     54
Sidebar: Font substitution     56
Save files     58
Sidebar: View and edit files online     59
Use common Office interface features     59
Identify standard features     60
Sidebar: Change the magnification level of file content     61
Work with the ribbon     62
Manage files     64
Sidebar: Hide and show the on-screen keyboard     67
Sidebar: Reconfigure the on-screen keyboard     68
Search file content     69
Print file content     72
Distribute files     74
Skills review     77
Practice tasks     78
Part 2: Microsoft Word for iPad
Chapter 4: Create professional documents     83

Sidebar: The Word feature set     84
Create documents from templates     88
Enter text in documents     93
Sidebar: Magnify the cursor position     98
Sidebar: Check spelling     99
Move, copy, and delete text     100
Sidebar: The Clipboard     100
Sidebar: Paste options     102
Align, space, and indent paragraphs     104
Configure alignment     105
Configure vertical spacing     106
Configure indents     107
Structure content manually     110
Change the appearance of text     111
Skills review     116
Practice tasks     117
Chapter 5: Add visual elements to documents     121
Present content in lists     122
Create bulleted lists     122
Create numbered lists     125
Create multilevel lists     127
Present content in tables     129
Insert and format pictures     136
Insert and modify pictures     136
Sidebar: About Photo Streams     138
Apply styles and effects to pictures     142
Replace and reset pictures     145
Insert and format shapes     146
Arrange images and text     151
Skills review     153
Practice tasks     154
Chapter 6: Enhance document content     159
Configure text in columns     160
Sidebar: Display column-related marks and tools     161
Draw and format text boxes     164
Reference additional information     168
Configure page layout     170
Specify the dimensions of the content area     170
Add page headers and footers     172
Manage page and section breaks     176
Collaborate on document content     178
Track and review changes     178
Sidebar: Simultaneous coauthoring     179
Insert and manage comments     183
Skills review     185
Practice tasks     186
Part 3: Microsoft Excel for iPad
Chapter 7: Store and retrieve data     191

Sidebar: The Excel feature set     192
Create workbooks     194
Create and manage worksheets     196
Add, rename, and remove worksheets     196
Move and hide worksheets     198
Show and hide worksheet elements     199
Enter and edit data on worksheets     200
Sidebar: Select cells, columns, and rows     201
Sidebar: Display and hide the shortcut bar     203
Modify columns and rows     206
Resize columns and rows     206
Insert and delete columns and rows     207
Hide and unhide columns and rows     210
Modify cells and cell content     210
Insert and delete cells     211
Modify cell structure     212
Format cell appearance     213
Manage the display of data     217
Freeze panes     217
Sort and filter data     219
Skills review     221
Practice tasks     222
Chapter 8: Process and present numeric data     227
Create and manage Excel tables     228
Perform data-processing operations     236
Create simple formulas     236
Sidebar: Efficiently reference cells in formulas     240
Insert formula constructs     244
Sidebar: Quickly display statistics     246
Build complex formulas     246
Sidebar: Refresh calculations manually     249
Display data in charts     249
Create charts     251
Modify chart structure     254
Format charts     258
Display data from PivotTables     260
Collaborate on workbook content     266
Skills review     268
Practice tasks     269
Part 4: Microsoft PowerPoint for iPad
Chapter 9: Create compelling presentations     275

Sidebar: The PowerPoint feature set     276
Create presentations     280
Create and manage slides     285
Add text to slides     290
Manage text containers     290
Insert and manage text     292
Present information in tables     296
Sidebar: Review comments     298
Add visual elements to slides     299
Insert pictures     299
Insert shapes     301
Animate slide elements     304
Skills review     310
Practice tasks     311
Chapter 10: Prepare and deliver slide shows     315
Add notes to slides     316
Animate slide transitions     319
Incorporate external media content     323
Sidebar: Format embedded video images     324
Manage and present slide shows     330
Skills review     333
Practice tasks     334
Part 5: Microsoft OneNote for iPad
Chapter 11: Store information in digital notebooks     339

Sidebar: The OneNote feature set     340
Create, open, and close notebooks     342
Create notebooks     342
Sidebar: OneNote gets you started     343
Open and switch among notebooks     343
Close and reopen notebooks     346
Configure notebook storage structure     347
Add information to notebooks     349
Enter and format text     349
Work with notebook containers     351
Organize notes in tables     352
Insert images     353
Insert files from cloud storage locations     357
Sidebar: Send, print, and link content to notes     359
Manage pages and sections     360
Skills review     365
Practice tasks     366
Chapter 12: Locate and share notebook content     369
Display notes in different ways     370
Switch notebook views     370
Fit content to the page     372
Sidebar: Zoom by touch     373
Find information in notebooks     373
Tag information for reference and retrieval     374
Search for text     376
Protect and share information     378
Protect notebook sections     378
Share notebook content     381
Synchronize notebook content     382
Skills review     383
Practice tasks     384
Appendix     387
Glossary     393
Index     405
About the author     429


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