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
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
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
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
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
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
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
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
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
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
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
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
Introduction
This Step by Step book has been designed so you can read it from the beginning to learn about the infrastructure that supports the Microsoft Office for iPad apps, the common user interface elements, and the skills you can use when working in any of them; and then build your skills as you learn to perform increasingly specialized procedures Or, if you prefer, you can jump in wherever you need ready guidance for supporting the apps or performing tasks in Microsoft Word for iPad, Excel for iPad, PowerPoint for iPad, and OneNote for iPad The how-to steps are delivered crisply and concisely-just the facts You’ll also find informative, full-color graphics that support the instructional content
Who this book is for
Microsoft Office for iPad Step by Step is designed for use as a learning and reference resource by home and business users of Office programs who want to use Word, Excel, PowerPoint, and OneNote to create and edit documents, workbooks, presentations, and notebooks on iPads The content of the book is designed to be useful for people who have previously used Word, Excel, PowerPoint, and OneNote on other platforms and for people who are discovering Office apps for the first time
The Step by Step approach
The book’s coverage is divided into parts representing general Office app skills or specific apps Each part is divided into chapters representing skill set areas, and each chapter is divided into topics that group related skills Each topic includes expository information followed by specific procedures At the end of the chapter, you’ll find a series of practice tasks you can complete on your own You can use the practice files that are available from this book’s website to work through the practice tasks, or you can use your own files
