The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.
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
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 Windows and for Mac) and three generations of Microsoft Office Specialist certification study guides. She enthusiastically shares her love of technology through her participation in the creation of books, learning materials, and certification exams, and greatly enjoys communicating the benefits of new technologies by delivering training and facilitating learning events. 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.
Joan currently lives in a small town in Texas with her simply divine daughter, Trinity, two slightly naughty dogs, a naturally superior cat, a vast assortment of fish, and the super-automatic espresso machine that runs the house.
Joan’s team at OTSI specializes in the design and creation of Office, SharePoint, and Windows training solutions and the production of online and printed training resources.
For more information about OTSI, visit www.otsi.com or follow us on Facebook at www.facebook.com/Online.Training.Solutions.Inc for advance information about upcoming training resources and informative tidbits about technology and publishing.
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