Microsoft Office for iPad Step by Step

Joan Lambert has worked closely with Microsoft technologies since 1986 and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently.   Joan is the author or coauthor of more than three dozen books about Windows and Office (for the Windows, Mac, and iPad platforms) and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for Office 2013, Office 2010, and Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer.

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