Features and Benefits
top
Get to know Microsoft Office Web Apps fast, with this media-rich, customized, comprehensive hands-on learning experience!
# Practical, approachable coverage that flattens the Microsoft Office Web Apps learning curve
# Tightly integrated with online video, screencast tutorials, podcasts, and more: the total learning experience for new users
# Covers the entire suite: Word, Excel, PowerPoint, and OneNote
# Thoroughly covers online collaboration with Microsoft SkyDrive and SharePoint
Table of Contents
top
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
About the Authors
top
Paul McFedries is a Microsoft Office expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 70 books to his credit, which combined have sold more than 3 million copies worldwide. His titles include the Que Publishing books Formulas and Functions with Microsoft Excel 2010, Tricks of the Microsoft Office 2007 Gurus, VBA for the 2007 Microsoft Office System, and Tweak It and Freak It: A Killer Guide to Making Windows Run Your Way, as well as the Sams Publishing book Windows 7 Unleashed. Paul is also the proprietor of Word Spy (www.wordspy.com), a website devoted to lexpionage, the sleuthing of new words and phrases that have entered the English language. Please drop by Paul's personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.
