Office for iPad® and Mac® For Dummies®

Published by: John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030-5774, www.wiley.com

Copyright © 2015 by John Wiley & Sons, Inc., Hoboken, New Jersey

Media and software compilation copyright © 2015 by John Wiley & Sons, Inc. All rights reserved.

Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the Publisher. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.

Trademarks: Wiley, For Dummies, the Dummies Man logo, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and may not be used without written permission. iPad and Mac are registered trademarks of Apple, Inc. All other trademarks are the property of their respective owners. Office for iPad® and Mac® For Dummies® is an independent publication and has not been authorized, sponsored, or otherwise approved by Apple, Inc.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.

For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002. For technical support, please visit www.wiley.com/techsupport.

Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.

Library of Congress Control Number: 2014955783

ISBN: 978-1-119-01017-3; ISBN 978-1-119-01020-3 (ebk); ISBN ePDF 978-1-119-01018-0 (ebk)

Office for iPad® and Mac® For Dummies®

Visit www.dummies.com/cheatsheet/officeipadmac to view this book's cheat sheet.

Table of Contents

Cover

Introduction

About This Book

Foolish Assumptions

Icons Used in This Book

Beyond the Book

Where to Go from Here

Part I: Getting Started with Office for iPad and Mac

Chapter 1: iPad for Beginners

What Is Office for the iPad?

What Is Office 2011 for Mac?

What Is Office 365?

Subscribing to Office 365

Installing Office for iPad

iPad — the Basics

Understanding the Screen Gestures

Running Apps on the iPad

Controlling the Volume

Handling Internet Wi-Fi Connections

Chapter 2: Making the iPad Work Your Way

Downloading and Installing Apps

Tidying the Home Screen

Deleting an App

Hanging Some Wallpaper

Handling Passcodes

Chapter 3: Exploring Office for the iPad Basics

Working with Files (Documents, Workbooks, and Presentations)

A Quick Tour of the Office for iPad Interface

Shrinking and Enlarging the Screen

Handling and Manipulating Text

Making Bulleted and Numbered Lists

Finding and Replacing Text

Part II: Word

Chapter 4: Word for the iPad

Applying Styles

Laying Out the Page

Spell Checking Your Work

Putting Footnotes in Documents

Tracking Editorial Changes

Chapter 5: Creating Sophisticated Documents with Word 2011

Introducing the Word Screen

Creating a New Document

Getting a Better Look at Your Documents

Selecting Text in Speedy Ways

Moving Around Quickly in Documents

Inserting a Whole File into a Document

Inserting Line, Page, and Section Breaks

Setting Up and Changing the Margins

Indenting Paragraphs and First Lines

Numbering the Pages

Putting Headers and Footers on Pages

Adjusting the Space between Lines

Adjusting the Space between Paragraphs

Creating Numbered and Bulleted Lists

Hyphenating Text

Chapter 6: Word Styles

All about Styles

Applying Styles to Text and Paragraphs

Creating a New Style

Modifying a Style

Creating Templates

Chapter 7: Constructing the Perfect Table

Talking Table Jargon

Creating a Table

Entering the Text and Numbers

Selecting Different Parts of a Table

Aligning Text in Columns and Rows

Merging and Splitting Cells

Laying Out Your Table

Formatting Your Table

Using Math Formulas in Tables

Chapter 8: Getting the Most Out of Word

Correcting Your Spelling Errors

Finding the Right Word with the Thesaurus

Churning Out Letters, Envelopes, and Labels for Mass Mailings

Outlines for Organizing Your Work

Generating a Table of Contents

Indexing a Document

Putting Cross-References in a Document

Putting Footnotes and Endnotes in Documents

Part III: Excel

Chapter 9: Excel for the iPad

Finding Your Way Around the Excel Screen

Changing Your View of a Worksheet

Entering and Editing Data

Choosing a Format for Data

Adding and Deleting Worksheets

Constructing a Formula

Dressing Up a Worksheet

Presenting Data in a Table

Chapter 10: Up and Running with Excel 2011

Creating an Excel Workbook

Getting Acquainted with Excel

Entering Data in a Worksheet

Quickly Entering Lists and Serial Data with the AutoFill Command

Formatting Numbers, Dates, and Time Values

Conditional Formats for Calling Attention to Data

Establishing Data-Validation Rules

Chapter 11: Refining Your Worksheet

Editing Worksheet Data

Moving Around in a Worksheet

Getting a Better Look at the Worksheet

Comments for Documenting Your Worksheet

Selecting Cells in a Worksheet

Deleting, Copying, and Moving Data

Handling the Worksheets in a Workbook

Keeping Others from Tampering with Worksheets

How Formulas Work

The Basics of Entering a Formula

Speed Techniques for Entering Formulas

Copying Formulas from Cell to Cell

Detecting and Correcting Errors in Formulas

Working with Functions

Chapter 12: Creating a Chart

The Basics: Creating a Chart

Choosing the Right Chart

Positioning Your Chart in a Workbook

Changing a Chart’s Appearance

Saving a Chart as a Template So That You Can Use It Again

Chart Tricks for the Daring and Heroic

Part IV: PowerPoint

Chapter 13: PowerPoint for the iPad

Finding Your Way Around the Screen

Handling Text and Text Boxes

Adding, Reordering, and Removing Slides

Writing and Reading Notes

Applying Slide Transitions

Giving a Presentation

Chapter 14: Getting Started in PowerPoint 2011

Getting Acquainted with PowerPoint

A Brief Geography Lesson

Creating a New Presentation

Advice for Building Persuasive Presentations

Creating New Slides for Your Presentation

Getting a Better View of Your Work

Hiding and Displaying the Slides Pane and Notes Pane

Selecting, Moving, and Deleting Slides

Hidden Slides for All Contingencies

Chapter 15: Fashioning a Look for Your Presentation

Looking at Themes and Background Styles

Choosing a Theme for Your Presentation

Creating Slide Backgrounds on Your Own

Changing the Background of a Single Slide or Handful of Slides

Using Master Slides and Master Styles for a Consistent Design

Putting Footers (and Headers) on Slides

Chapter 16: Delivering a Presentation

All about Notes

Rehearsing and Timing Your Presentation

Showing Your Presentation

Tricks for Making Presentations a Little Livelier

Delivering a Presentation When You Can’t Be There in Person

Part V: Sharing and Collaborating with Office 365

Chapter 17: Managing Files and Folders on OneDrive

Signing In to OneDrive

Exploring the OneDrive Window

Managing Your OneDrive Folders

Uploading Files to a Folder on OneDrive

Saving a File to OneDrive

Downloading Files from OneDrive to Your Computer

Managing Your Files on OneDrive

Syncing Files between OneDrive and Your Machine

Chapter 18: File Sharing and Collaborating

Sharing Files: The Big Picture

Sharing Your Files and Folders with Others

Seeing Files and Folders Others Shared with You

Investigating and Changing How Files and Folders Are Shared

Part VI: The Part of Tens

Chapter 19: Ten-Plus Functions for Crunching Numbers

AVERAGE for Averaging Data

COUNT and COUNTIF for Tabulating Data Items

CONCATENATE for Combining Values

PMT for Calculating How Much You Can Borrow

IF for Identifying Data

LEFT, MID, and RIGHT for Cleaning Up Data

PROPER for Capitalizing Words

LARGE and SMALL for Comparing Values

NETWORKDAY and TODAY for Measuring Time in Days

LEN for Counting Characters in Cells

Chapter 20: Ten Tips for Making Glorious PowerPoint Presentations

Don’t Let PowerPoint Tell You What to Do

Make Your Company Colors Part of the Design

Use Large Fonts

Use the Animation Feature in Bulleted Lists

Use Visuals, Not Just Words, to Make Your Point

Navigate in a Nonlinear Fashion

Ask the Audience Questions

Pretend You’re Speaking to Friends

Take Advantage of the Slide Show Gizmos

Spell Check Your Presentation

Chapter 21: Ten Things All iPad Users Should Know

Fix an iPad Screen That Won’t Rotate

Turn Down the Brightness to Save Battery Strength

Place Apps on the Dock

Browse the Internet in Private

Invert Colors to Work in the Dark

Take a Picture of the Screen

Split the Keyboard in Half

Use Your iPad in Flight

Make Folders for Storing Apps on the Home Screen

Turn on Multitasking Gestures

About the Author

Cheat Sheet

Advertisement Page

Connect with Dummies

End User License Agreement

Guide

Cover

Table of Contents

Begin Reading

Pages

i

ii

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

365

366

Introduction

This book is your guide to making the most of Office for the iPad and Office 2011 for the Mac. Its 21 chapters are jam-packed with how-to’s, advice, shortcuts, and tips. This book is for users of Office for the iPad and Office 2011 for the Macintosh who want to get to the heart of these applications without wasting time. Don’t look in this book to find out how the applications work. Look in this book to find out how can get work done better and faster with these applications.

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!

Lesen Sie weiter in der vollständigen Ausgabe!