Using the Microsoft Office Web Apps

Description

Get comfortable with the newest way to use Microsoft Office 2010. Don't just read about it: See it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you'll ever need...where you want, when you want!

learn fast, learn easy, using web, video, and audio

Show Me video walks through tasks you've just got to see--including bonus advanced techniques

Tell Me More audio delivers practical insights straight from the experts

UNLOCK THE FREE WEB EDITION--To register your USING book, visit quepublishing.com/using.

CONTENTS:

Introduction 1

How This Book Is Organized 2

Using This Book 2

Special Features 3

About the USING Web Edition 3

1 Introducing the Office Web Apps 4

Comparing the Web Apps and the Desktop Apps 5

Understanding Office Web App File Compatibility 6

Comparing General Interface Features 6

Comparing Excel and the Excel Web App 8

Comparing Word and the Word Web App 9

Comparing PowerPoint and the PowerPoint Web App 11

Comparing OneNote and the OneNote Web App 13

What You Need to Use the Office Web Apps 15

Browser Support 15

Obtaining a Windows Live ID 18

Installing Silverlight for Better Performance 19

Accessing the Office Web Apps 21

Accessing the Office Web Apps via SkyDrive 21

Accessing the Office Web Apps via SharePoint 2010 23

Scenarios for Using the Office Web Apps 24

Having Document Access Everywhere 25

Distribution Made Simple: One File, One Location 26

No Microsoft Office? No Problem! 26

Broadcasting Your Presentations 27

Collaborating in the Cloud 28

2 Learning Windows Live SkyDrive Essentials 29

Setting Up SkyDrive 29

Changing the Theme 29

Assigning a Picture to Your Profile 31

Working with SkyDrive Folders 32

Viewing a SkyDrive Folder 33

Navigating SkyDrive Folders 34

Creating a SkyDrive Folder 35

Changing the SkyDrive Folder View 37

Downloading a SkyDrive Folder 38

Deleting a SkyDrive Folder 38

Working with Office Documents in SkyDrive 39

Creating a New Office Document in SkyDrive 40

Uploading Office Documents to SkyDrive 41

Using Office 2010 to Save a Document to SkyDrive 45

Viewing an Office Document 46

Opening an Office Document for Editing 48

Working with SkyDrive Files 49

Moving a SkyDrive File to Another Folder 49

Copying a SkyDrive File to Another Folder 51

Renaming a SkyDrive File 51

Adding a Comment to a SkyDrive File 52

Disabling File Comments . . 53

Downloading a SkyDrive File 54

Deleting a SkyDrive File 55

3 Learning SharePoint 2010 Essentials 57

Managing SharePoint Document Libraries 57

Opening a Library 57

Navigating the Library Hierarchy 59

Adding a Library 61

Creating a Custom Library View 63

Downloading a Library 66

Deleting a Library 67

Dealing with Office Documents in SharePoint 68

Creating a New Office Document in SharePoint 68

Uploading Office Documents to SharePoint 70

Saving a Document to SharePoint Using Office 2010 72

Viewing an Office Document 74

Opening an Office Document for Editing 76

Managing SharePoint Files 78

Copying a SharePoint File to Another Library 78

Renaming a SharePoint File 80

Checking a Document Out and In 80

Deleting a SharePoint File 82

4 Collaborating with the Office Web Apps 84

Collaborating with the Office Web Apps Using SkyDrive 84

Working with SkyDrive Permissions 85

Configuring Your SkyDrive Network 86

Configuring Your SkyDrive User Categories 89

Configuring Your SkyDrive Folder Permissions 91

Letting People Know About Your SkyDrive Data 93

Collaborating on an Office Document in SkyDrive 99

Collaborating with the Office Web Apps Using SharePoint 2010 102

Working with Library Permissions 103

Letting People Know About Your SharePoint Data 110

Collaborating on an Office Document in SharePoint 115

5 Formatting Your Office Web Apps Documents 120

Changing the Font 120

Setting the Typeface 121

Changing the Type Size 123

Applying Type Effects 124

Setting Text Colors 126

Formatting Paragraphs 127

Building a Bulleted List 127

Creating a Numbered List 129

Setting the Indentation 130

Aligning Paragraphs 132

Applying Styles 134

Inserting a Link 136

Clearing Formatting 139

6 Working with the Office Web Apps File Features 140

Saving a File 140

Opening a Document in the Desktop Application 143

Downloading a Snapshot of an Excel Workbook 146

Downloading a Copy of an Excel Workbook 147

Closing a File 148

7 Using the Word Web App 150

Understanding the Word Web App's Restrictions 150

Finding Text 151

Building Word Tables 153

Inserting a Table 154

Selecting Table Elements 155

Inserting Rows and Columns 156

Changing the Column Width and Row Height 157

Aligning Table Elements 158

Deleting Table Elements 159

Inserting Images 159

Inserting a Picture 159

Inserting Clip Art 161

Formatting Images 162

Proofing Word Documents 163

8 Using the Excel Web App 165

Understanding the Excel Web App's Restrictions 165

Building a Worksheet 166

Entering Text, Numbers, and Dates 166

Building Formulas 170

Selecting Ranges 172

Making a Copy of a Range 174

Moving a Range 174

Inserting a Range 175

Deleting a Range 178

Formatting a Range 179

Adding Borders 179

Aligning Text Vertically Within a Cell 180

Wrapping Text Within a Cell 181

Applying a Numeric Format 181

Applying a Date Format 183

Controlling the Number of Decimal Places 185

Building Tables in the Excel Web App 186

Converting a Range to a Table 187

Toggling the Header Row and Total Row 188

Inserting New Table Records and Fields 189

Deleting Rows and Columns 190

Sorting Table Data 191

Filtering Table Data 192

Filtering Using a Filter List 193

Filtering Using Quick Filters 194

Clearing a Filter 197

9 Using the PowerPoint Web App 198

Understanding the PowerPoint Web App's Restrictions 198

Building a Presentation 199

Adding a New Slide 200

Adding Text to a Slide 202

Rearranging Slides 204

Duplicating a Slide 204

Hiding a Slide 204

Deleting a Slide 205

Adding Notes 206

Working with Slide Pictures 207

Adding a Picture to a Slide 207

Setting the Picture Style 208

Changing a Picture 210

Adding SmartArt Graphics to a Slide 210

Adding a SmartArt Graphic to a Slide 211

Applying a SmartArt Color Scheme 213

Setting the SmartArt Style 213

Changing the SmartArt Layout 215

Viewing a Presentation Online 215

Switching to Reading View 216

Switching to Slide Show View 217

10 Using the OneNote Web App 219

Understanding the OneNote Web App's Restrictions 219

Building a Notebook 220

Inserting a New Section 220

Inserting a New Page 222

Working with Page Containers 222

Tagging Items 223

Working with Pictures 226

Inserting a Picture 226

Inserting Clip Art 227

Formatting Images 228

Building OneNote Tables 229

Inserting a Table 229

Selecting Table Elements 232

Inserting Rows and Columns 232

Changing the Column Width and Row Height 233

Aligning Table Elements 234

Deleting Table Elements 234

Index 236