Microsoft Office 2010

Word Lesson 1: Microsoft Word 2010 Jumpstart - Page 29
Word Lesson 1: Microsoft Word 2010 Jumpstart - Page 30
Creating a new document - Page 31
Customizing the Quick Access Toolbar - Page 32
Applying Styles - Page 33
Adding and positioning a graphic - Page 34
Adding and positioning a graphic - Page 35
Changing background color and margins - Page 36
Inserting additional pages - Page 37
Adding page numbers - Page 38
Protecting the document - Page 39
Self study - Page 40
Review - Page 41
Review - Page 42
Word Lesson 2: Getting Started with Microsoft Word 2010 - Page 43
Understanding Microsoft Word - Page 44
Understanding Microsoft Word - Page 45
Understanding Microsoft Word - Page 46
Understanding Microsoft Word - Page 47
Understanding Microsoft Word - Page 48
Understanding Microsoft Word - Page 49
Understanding Microsoft Word - Page 50
Getting help - Page 51
Getting help - Page 52
Getting help - Page 53
Converting Word documents from prior versions to Word 2010 - Page 54
Self study - Page 55
Self study - Page 56
Word Lesson 3: Editing the Document - Page 57
Opening and editing an existing document - Page 58
Opening and editing an existing document - Page 59
Opening and editing an existing document - Page 60
Opening and editing an existing document - Page 61
Opening and editing an existing document - Page 62
Opening and editing an existing document - Page 63
Opening and editing an existing document - Page 64
Working with fonts - Page 65
Reducing font size - Page 66
Emphasizing text - Page 67
Character Formatting tools - Page 68
Character Formatting tools - Page 69
Character Formatting tools - Page 70
Protect Document options - Page 71
Review - Page 72
Word Lesson 4: Formatting Paragraphs - Page 73
Working with paragraphs - Page 74
Working with paragraphs - Page 75
Working with paragraphs - Page 76
Working with paragraphs - Page 77
Working with paragraphs - Page 78
Working with paragraphs - Page 79
Working with paragraphs - Page 80
Working with paragraphs - Page 81
Displaying formatting marks and rulers - Page 82
Indenting paragraphs - Page 83
Indenting paragraphs - Page 84
Indenting paragraphs - Page 85
Adding paragraph borders - Page 86
Adding paragraph borders - Page 87
Self study - Page 88
Word Lesson 5: Working with Pages - Page 89
Introducing the page tools - Page 90
Introducing the page tools - Page 91
Choosing a layout - Page 92
Choosing a layout - Page 93
Working with columns - Page 94
Inserting column breaks - Page 95
Adding a page border - Page 96
Adding a page border - Page 97
Adding headers and footers - Page 98
Adding headers and footers - Page 99
Adding headers and footers - Page 100
Adding a background color - Page 101
Adding a watermark - Page 102
Adding pages and page numbers - Page 103
Adding pages and page numbers - Page 104
Adding pages and page numbers - Page 105
Adding pages and page numbers - Page 106
Inserting a section break - Page 107
Inserting a section break - Page 108
Self study - Page 109
Review - Page 110
Word Lesson 6: Working with Styles and Themes - Page 111
Understanding styles - Page 112
Understanding styles - Page 113
Understanding heading styles - Page 114
Switching between style sets - Page 115
Identifying the current style - Page 116
Removing a style - Page 117
Creating a new style - Page 118
Creating a new style - Page 119
Creating a new style - Page 120
Deleting a style - Page 121
Assigning a style shortcut key - Page 122
Customizing the Quick Styles Gallery - Page 123
Customizing the Quick Styles Gallery - Page 124
Customizing the Quick Styles Gallery - Page 125
Applying a document theme - Page 126
Customizing a theme - Page 127
Customizing a theme - Page 128
Self study - Page 129
Self study - Page 130
Word Lesson 7: Working with Tables - Page 131
Introducing the table tools - Page 132
Creating a table - Page 133
Creating a table - Page 134
Selecting cells within a table - Page 135
Changing the row height or column width - Page 136
Moving a table - Page 137
Adding and deleting rows - Page 138
Adding and deleting columns - Page 139
Enlarging a table - Page 140
Enlarging a table - Page 141
Splitting a table - Page 142
Adding shading to cells - Page 143
Adding a formula to a table - Page 144
Self Study - Page 145
Review - Page 146
Word Lesson 8: Working with Graphics - Page 147
Introducing the graphics tools - Page 148
Introducing the graphics tools - Page 149
Introducing the graphics tools - Page 150
Introducing the graphics tools - Page 151
Introducing the graphics tools - Page 152
Introducing the graphics tools - Page 153
Introducing the graphics tools - Page 154
Introducing the graphics tools - Page 155
Introducing the graphics tools - Page 156
Introducing the graphics tools - Page 157
Introducing the graphics tools - Page 158
Wrapping text around an image - Page 159
Adding a picture effect to a graphic - Page 160
Working with diagrams - Page 161
Self study - Page 162
Review - Page 163
Review - Page 164
Excel Lesson 1: Microsoft Excel 2010 Jumpstart - Page 165
Excel Lesson 1: Microsoft Excel 2010 Jumpstart - Page 166
Inserting rows and columns into a worksheet - Page 167
Merging and formatting cells - Page 168
Adjusting cell width and increasing font size - Page 169
Adding a column of numbers - Page 170
Self study - Page 171
Self study - Page 172
Excel Lesson 2: Getting Started with Microsoft Excel 2010 - Page 173
What Is Excel? - Page 174
Exploring the Excel workspace - Page 175
Exploring the Excel workspace - Page 176
Exploring the Excel workspace - Page 177
Exploring the Excel workspace - Page 178
Worksheet basics: a quick tour of Microsoft Excel - Page 179
The Excel user interface - Page 180
The Excel user interface - Page 181
The Excel user interface - Page 182
The Excel user interface - Page 183
The Excel user interface - Page 184
The Excel user interface - Page 185
Working within a workbook - Page 186
Working within a workbook - Page 187
Convert Excel documents from prior versions to Excel 2010 - Page 188
Convert Excel documents from prior versions to Excel 2010 - Page 189
Self study - Page 190
Excel Lesson 3: Editing Cells - Page 191
Generating a new workbook from an existing one - Page 192
Generating a new workbook from an existing one - Page 193
Using the Clear command - Page 194
Entering data - Page 195
Copying and pasting within Excel - Page 196
Copying and pasting within Excel - Page 197
Formatting cells for numbers - Page 198
Formatting cells for numbers - Page 199
Self study - Page 200
Review - Page 201
Review - Page 202
Excel Lesson 4: Formatting Cell Ranges - Page 203
Working with fonts - Page 204
Working with fonts - Page 205
Aligning cell data - Page 206
Aligning cell data - Page 207
Using the format painter - Page 208
Adding columns and rows - Page 209
Assigning Number Formats - Page 210
Finding the sum of a column - Page 211
Self study - Page 212
Excel Lesson 5: Building Formulas and Functions - Page 213
Understanding Excel formulas - Page 214
Building a formula - Page 215
Understanding Excel functions - Page 216
Understanding Excel functions - Page 217
Understanding Excel functions - Page 218
Adding a row or column of numbers - Page 219
Building an AutoSum formula - Page 220
Building an AutoSum formula - Page 221
Copying a formula - Page 222
Defining and using range names in formulas - Page 223
Self study - Page 224
Excel Lesson 6: Displaying Data with Charts - Page 225
Exploring chart elements - Page 226
Exploring chart elements - Page 227
Exploring chart elements - Page 228
Adjusting and moving the chart - Page 229
Adjusting and moving the chart - Page 230
Adjusting and moving the chart - Page 231
Adjusting and moving the chart - Page 232
Adjusting and moving the chart - Page 233
Adjusting and moving the chart - Page 234
Adjusting and moving the chart - Page 235
Adjusting and moving the chart - Page 236
Adjusting and moving the chart - Page 237
Adjusting and moving the chart - Page 238
Adding Sparkline graphics to a worksheet - Page 239
Self study - Page 240
Excel Lesson 7: Analyzing Excel Data - Page 241
Understanding data lists - Page 242
Understanding data lists - Page 243
Filtering a range - Page 244
Setting data validation rules - Page 245
Setting data validation rules - Page 246
Converting a range to a table - Page 247
Converting a range to a table - Page 248
Creating a data table - Page 249
Summarizing data with subtotals - Page 250
Exporting Excel data to Word - Page 251
Exporting Excel data to Word - Page 252
Creating a PivotTable - Page 253
Creating a PivotTable - Page 254
Creating a PivotChart - Page 255
Creating a PivotChart - Page 256
Self study - Page 257
Self study - Page 258
Excel Lesson 8: Adding Graphic Objects - Page 259
Manipulating graphics - Page 260
Manipulating graphics - Page 261
Moving graphic objects to a new layer - Page 262
Moving graphic objects to a new layer - Page 263
Aligning graphics - Page 264
Grouping graphics - Page 265
Importing and adjusting graphics - Page 266
Importing and adjusting graphics - Page 267
Formatting clip art and imported pictures - Page 268
Formatting clip art and imported pictures - Page 269
Working with shapes - Page 270
Working with shapes - Page 271
Working with shapes - Page 272
Working with text boxes - Page 273
Inserting WordArt - Page 274
Inserting WordArt - Page 275
Inserting SmartArt graphics - Page 276
Adding a screenshot - Page 277
Adding a screenshot - Page 278
Adding a theme - Page 279
Adding a theme - Page 280
PowerPoint Lesson 1: Microsoft PowerPoint 2010 Jumpstart - Page 281
PowerPoint Lesson 1: Microsoft PowerPoint 2010 Jumpstart - Page 282
Creating a presentation from an existing file - Page 283
Applying a theme and changing colors - Page 284
Changing the slide layout and aligning text - Page 285
Changing the slide layout and aligning text - Page 286
Adding pictures and text to the slide - Page 287
Adding pictures and text to the slide - Page 288
Adding pictures and text to the slide - Page 289
Adding pictures and text to the slide - Page 290
Adding pictures and text to the slide - Page 291
Adding pictures and text to the slide - Page 292
Adding pictures and text to the slide - Page 293
Self study - Page 294
PowerPoint Lesson 2: Getting Started with Microsoft PowerPoint 2010 - Page 295
Understanding Microsoft PowerPoint - Page 296
Understanding Microsoft PowerPoint - Page 297
Customizing the Quick Access Toolbar - Page 298
Customizing the Quick Access Toolbar - Page 299
Applying a theme - Page 300
Adding a slide and related notes - Page 301
Using the Notes pane - Page 302
Using the Notes pane - Page 303
Adding a shaped text box - Page 304
Adding a text box - Page 305
Adding a text box - Page 306
Adding a text box - Page 307
Adding a picture - Page 308
Getting help - Page 309
Getting help - Page 310
Self study - Page 311
Review - Page 312
PowerPoint Lesson 3: Working with Tables and Charts - Page 313
Table basics - Page 314
Table basics - Page 315
Table basics - Page 316
Table basics - Page 317
Selecting table elements - Page 318
Selecting table elements - Page 319
Selecting table elements - Page 320
Selecting table elements - Page 321
Selecting table elements - Page 322
Selecting table elements - Page 323
Selecting table elements - Page 324
Selecting table elements - Page 325
Selecting table elements - Page 326
Self study - Page 327
Self study - Page 328
PowerPoint Lesson 4: Working with Graphic Elements - Page 329
Using the drawing tools - Page 330
Using the drawing tools - Page 331
Working with shape styles - Page 332
Aligning graphics - Page 333
Ungrouping and regrouping graphic elements - Page 334
Ungrouping and regrouping graphic elements - Page 335
Creating a diagram - Page 336
Creating a diagram - Page 337
Customizing and saving a theme - Page 338
Customizing and saving a theme - Page 339
Customizing and saving a theme - Page 340
Self study - Page 341
Self study - Page 342
Access Lesson 1: Microsoft Access 2010 Jumpstart - Page 343
What Is Access? - Page 344
What Is Access? - Page 345
Quick tour of Access 2010 - Page 346
Quick tour of Access 2010 - Page 347
Quick tour of Access 2010 - Page 348
Quick tour of Access 2010 - Page 349
Exploring a database - Page 350
Exploring a database - Page 351
Exploring a database - Page 352
Exploring a database - Page 353
Exploring a database - Page 354
Exploring a database - Page 355
Working with records - Page 356
Working with records - Page 357
Working with records - Page 358
Customizing the Quick Access Toolbar - Page 359
Getting help - Page 360
Ending an Access session - Page 361
Ending an Access session - Page 362
Access Lesson 2: Getting Started with Microsoft Access 2010 - Page 363
Access 2010 database types - Page 364
Access 2010 database types - Page 365
Access 2010 database types - Page 366
Tables, views, and data types - Page 367
Tables, views, and data types - Page 368
Tables, views, and data types - Page 369
Tables, views, and data types - Page 370
Importing data from a Microsoft Excel spreadsheet - Page 371
Importing data from a Microsoft Excel spreadsheet - Page 372
Self study - Page 373
Self study - Page 374
OneNote Lesson 1: Microsoft OneNote 2010 Jumpstart - Page 375
Discovering OneNote - Page 376
Exploring the OneNote environment - Page 377
Exploring the OneNote environment - Page 378
Exploring the OneNote environment - Page 379
Working in Backstage view - Page 380
Searching OneNote - Page 381
Sharing a Notebook - Page 382
Customizing OneNote - Page 383
Getting help - Page 384
Self study - Page 385
Self study - Page 386
OneNote Lesson 2: Getting Started with Microsoft OneNote 2010 - Page 387
OneNote Lesson 2: Getting Started with Microsoft OneNote 2010 - Page 388
Managing Sections - Page 389
Grouping Sections - Page 390
Saving a Notebook - Page 391
Managing Pages - Page 392
Adding content - Page 393
Adding content - Page 394
Adding content - Page 395
Adding content - Page 396
Adding content - Page 397
Adding content - Page 398
Adding content - Page 399
Self study - Page 400
Publisher Lesson 1: Microsoft Publisher 2010 Jumpstart - Page 401
What is Publisher? - Page 402
What is Publisher? - Page 403
What is Publisher? - Page 404
What is Publisher? - Page 405
What is Publisher? - Page 406
Changing your view - Page 407
Changing your view - Page 408
Changing your view - Page 409
Self study - Page 410
Review - Page 411
Review - Page 412
Publisher Lesson 2: Getting Started with Microsoft Publisher 2010 - Page 413
Creating a blank publication - Page 414
Creating a blank publication - Page 415
Creating a blank publication - Page 416
Creating a blank publication - Page 417
Creating a blank publication - Page 418
Inserting a text box - Page 419
Formatting text - Page 420
Formatting text - Page 421
Inserting and modifying images - Page 422
Inserting and modifying images - Page 423
Printing your publication - Page 424
Using Pack and Go - Page 425
Sending a publication using e-mail - Page 426
Sending a publication using e-mail - Page 427
Self study - Page 428
Review - Page 429
Review - Page 430
Outlook Lesson 1: Microsoft Outlook Essentials - Page 431
What is Outlook? - Page 432
Composing email, Adding recipients, and sending messages - Page 433
Composing email, Adding recipients, and sending messages - Page 434
Composing email, Adding recipients, and sending messages - Page 435
Composing email, Adding recipients, and sending messages - Page 436
Archiving old messages - Page 437
Archiving old messages - Page 438
Contacts and the Address Book - Page 439
Calendar - Page 440
Calendar - Page 441
Self study - Page 442