Microsoft Office Excel 2007

CHAPTER ONE Creating a Worksheet and an Embedded Chart - Page 18
What Is Microsoft Office Excel 2007? - Page 19
What Is Microsoft Office Excel 2007? - Page 20
Overview - Page 21
Overview - Page 22
Starting Excel - Page 23
The Excel Workbook - Page 24
The Excel Workbook - Page 25
Worksheet Window - Page 26
Worksheet Window - Page 27
Worksheet Window - Page 28
Formula Bar - Page 29
Quick Access Toolbar - Page 30
Office Button - Page 31
Key Tips - Page 32
Key Tips - Page 33
To Enter the Worksheet Titles - Page 34
Entering Text in a Cell - Page 35
Correcting a Mistake while Typing - Page 36
Correcting a Mistake while Typing - Page 37
To Enter Row Titles - Page 38
Entering Numbers - Page 39
To Enter Numbers - Page 40
Calculating a Sum - Page 41
To Sum a Column of Numbers - Page 42
Using the Fill Handle to Copy a Cell to Adjacent Cells - Page 43
To Copy a Cell to Adjacent Cells in a Row - Page 44
To Determine Multiple Totals at the Same Time - Page 45
Saving the Project - Page 46
To Save a Workbook - Page 47
To Save a Workbook - Page 48
To Save a Workbook - Page 49
Formatting the Worksheet - Page 50
Font Type, Style, Size, and Color - Page 51
To Change a Cell Style - Page 52
To Change the Font Type - Page 53
To Change the Font Type - Page 54
To Bold a Cell - Page 55
To Change the Font Color of a Cell Entry - Page 56
To Center Cell Entries across Columns by Merging Cells - Page 57
To Center Cell Entries across Columns by Merging Cells - Page 58
To Format Column Titles and the Total Row - Page 59
To Format Column Titles and the Total Row - Page 60
To Format Numbers in the Worksheet - Page 61
To Format Numbers in the Worksheet - Page 62
To Adjust the Column Width - Page 63
Using the Name Box to Select a Cell - Page 64
Other Ways to Select Cells - Page 65
Adding a 3-D Clustered Column Chart to the Worksheet - Page 66
To Add a 3-D Clustered Column Chart to the Worksheet - Page 67
To Add a 3-D Clustered Column Chart to the Worksheet - Page 68
To Add a 3-D Clustered Column Chart to the Worksheet - Page 69
To Add a 3-D Clustered Column Chart to the Worksheet - Page 70
Changing Document Properties and Saving Again - Page 71
To Change Document Properties - Page 72
To Save an Existing Workbook with the Same File Name - Page 73
Printing a Worksheet - Page 74
To Print a Worksheet - Page 75
Quitting Excel - Page 76
Starting Excel and Opening a Workbook - Page 77
Starting Excel and Opening a Workbook - Page 78
AutoCalculate - Page 79
Correcting Errors - Page 80
Correcting Errors - Page 81
Undoing the Last Cell Entry - Page 82
Clearing a Cell or Range of Cells - Page 83
Excel Help - Page 84
Excel Help - Page 85
Chapter Summary - Page 86
Learn It Online - Page 87
Learn It Online - Page 88
Extend Your Knowledge - Page 89
Make It Right - Page 90
In the Lab - Page 91
In the Lab - Page 92
In the Lab - Page 93
In the Lab - Page 94
In the Lab - Page 95
Cases and Places - Page 96
Cases and Places - Page 97
CHAPTER TWO Formulas, Functions, Formatting, and Web Queries - Page 98
Introduction - Page 99
Introduction - Page 100
Overview - Page 101
Overview - Page 102
Overview - Page 103
Entering the Titles and Numbers into the Worksheet - Page 104
Entering the Titles and Numbers into the Worksheet - Page 105
Entering the Titles and Numbers into the Worksheet - Page 106
Entering Formulas - Page 107
To Enter a Formula Using the Keyboard - Page 108
Arithmetic Operations - Page 109
To Enter Formulas Using Point Mode - Page 110
To Enter Formulas Using Point Mode - Page 111
To Copy Formulas Using the Fill Handle - Page 112
Smart Tags and Option Buttons - Page 113
Smart Tags and Option Buttons - Page 114
Using the AVERAGE, MAX, and MIN Functions - Page 115
To Determine the Average of a Range of Numbers Using the Keyboard and Mouse - Page 116
To Determine the Average of a Range of Numbers Using the Keyboard and Mouse - Page 117
To Determine the Highest Number in a Range of Numbers Using the Insert Function Box - Page 118
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu - Page 119
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu - Page 120
To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle - Page 121
To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle - Page 122
Verifying Formulas Using Range Finder - Page 123
Formatting the Worksheet - Page 124
Formatting the Worksheet - Page 125
To Change the Workbook Theme - Page 126
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle - Page 127
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle - Page 128
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle - Page 129
To Center Data in Cells and Format Dates - Page 130
Formatting Numbers Using the Ribbon - Page 131
To Apply an Accounting Style Format and Comma Style Format Using the Ribbon - Page 132
To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box - Page 133
To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box - Page 134
To Apply a Percent Style Format and Use the Increase Decimal Button - Page 135
To Apply Conditional Formatting - Page 136
To Apply Conditional Formatting - Page 137
Conditional Formatting Operators - Page 138
Changing the Widths of Columns and Heights of Rows - Page 139
Changing the Widths of Columns and Heights of Rows - Page 140
Changing the Widths of Columns and Heights of Rows - Page 141
To Change the Heights of Rows - Page 142
To Change the Heights of Rows - Page 143
Checking Spelling - Page 144
Checking Spelling - Page 145
Additional Spell Checker Considerations - Page 146
To Change the Worksheet’s Margins, Header, and Orientation in Page Layout View - Page 147
To Change the Worksheet’s Margins, Header, and Orientation in Page Layout View - Page 148
Previewing and Printing the Worksheet - Page 149
Previewing and Printing the Worksheet - Page 150
To Print a Section of the Worksheet - Page 151
Displaying and Printing the Formulas Version of the Worksheet - Page 152
To Display the Formulas in the Worksheet and Fit the Printout on One Page - Page 153
Importing External Data from a Web Source Using a Web Query - Page 154
To Import Data from a Web Source Using a Web Query - Page 155
To Import Data from a Web Source Using a Web Query - Page 156
Changing the Worksheet Names - Page 157
To Change the Worksheet Names - Page 158
E-Mailing a Workbook from within Excel - Page 159
Chapter Summary - Page 160
Learn It Online - Page 161
Apply Your Knowledge - Page 162
Apply Your Knowledge - Page 163
Extend Your Knowledge - Page 164
Make It Right - Page 165
In the Lab - Page 166
In the Lab - Page 167
In the Lab - Page 168
In the Lab - Page 169
In the Lab - Page 170
In the Lab - Page 171
In the Lab - Page 172
Cases and Places - Page 173
Cases and Places - Page 174
Cases and Places - Page 175
Cases and Places - Page 176
Cases and Places - Page 177
CHAPTER THREE What-If Analysis, Charting, and Working with Large Worksheets - Page 178
Introduction - Page 179
Introduction - Page 180
Introduction - Page 181
Overview - Page 182
Overview - Page 183
Overview - Page 184
Rotating Text and Using the Fill Handle to Create a Series - Page 185
To Rotate Text and Use the Fill Handle to Create a Series of Month Names - Page 186
To Rotate Text and Use the Fill Handle to Create a Series of Month Names - Page 187
Using the Auto Fill Options Menu - Page 188
Using the Auto Fill Options Menu - Page 189
To Increase Column Widths and Enter Row Titles - Page 190
Copying a Range of Cells to a Nonadjacent Destination Area - Page 191
To Copy a Range of Cells to a Nonadjacent Destination Area - Page 192
Using the Paste Options Menu - Page 193
Using Drag and Drop to Move or Copy Cells - Page 194
Using Drag and Drop to Move or Copy Cells - Page 195
Inserting Columns - Page 196
Deleting Columns and Rows - Page 197
To Enter Numbers with Format Symbols - Page 198
To Freeze Column and Row Titles - Page 199
Displaying a System Date - Page 200
To Enter and Format the System Date - Page 201
To Enter and Format the System Date - Page 202
Absolute versus Relative Addressing - Page 203
To Enter a Formula Containing Absolute Cell References - Page 204
To Enter a Formula Containing Absolute Cell References - Page 205
Making Decisions — The IF Function - Page 206
To Enter an IF Function - Page 207
To Enter an IF Function - Page 208
To Copy Formulas with Absolute Cell References Using the Fill Handle - Page 209
To Copy Formulas with Absolute Cell References Using the Fill Handle - Page 210
To Copy Formulas with Absolute Cell References Using the Fill Handle - Page 211
Nested Forms of the IF Function - Page 212
To Assign Formats to Nonadjacent Ranges - Page 213
To Assign Formats to Nonadjacent Ranges - Page 214
To Assign Formats to Nonadjacent Ranges - Page 215
To Format the Worksheet Titles - Page 216
To Format the Worksheet Titles - Page 217
Copying a Cell’s Format Using the Format Painter Button - Page 218
Copying a Cell’s Format Using the Format Painter Button - Page 219
Copying a Cell’s Format Using the Format Painter Button - Page 220
Adding a 3-D Pie Chart to the Workbook - Page 221
To Draw a 3-D Pie Chart on a Separate Chart Sheet - Page 222
To Insert a Chart Title and Data Labels - Page 223
To Insert a Chart Title and Data Labels - Page 224
To Insert a Chart Title and Data Labels - Page 225
To Rotate the 3-D Pie Chart - Page 226
To Rotate the 3-D Pie Chart - Page 227
To Apply a 3-D Format to the Pie Chart - Page 228
To Apply a 3-D Format to the Pie Chart - Page 229
To Explode the 3-D Pie Chart and Change the Color of a Slice - Page 230
To Explode the 3-D Pie Chart and Change the Color of a Slice - Page 231
To Explode the 3-D Pie Chart and Change the Color of a Slice - Page 232
Renaming and Reordering the Sheets and Coloring Their Tabs - Page 233
Renaming and Reordering the Sheets and Coloring Their Tabs - Page 234
Checking Spelling, Saving, Previewing, and Printing the Workbook - Page 235
Checking Spelling, Saving, Previewing, and Printing the Workbook - Page 236
Changing the View of the Worksheet - Page 237
Changing the View of the Worksheet - Page 238
To Split a Window into Panes - Page 239
What-If Analysis - Page 240
To Analyze Data in a Worksheet by Changing Values - Page 241
To Goal Seek - Page 242
To Goal Seek - Page 243
Goal Seeking - Page 244
Chapter Summary - Page 245
Learn It Online - Page 246
Extend Your Knowledge - Page 247
Extend Your Knowledge - Page 248
Make It Right - Page 249
In the Lab - Page 250
In the Lab - Page 251
In the Lab - Page 252
In the Lab - Page 253
In the Lab - Page 254
In the Lab - Page 255
In the Lab - Page 256
In the Lab - Page 257
In the Lab - Page 258
In the Lab - Page 259
In the Lab - Page 260
In the Lab - Page 261
Cases and Places - Page 262
Cases and Places - Page 263
Cases and Places - Page 264
Cases and Places - Page 265
WEB FEATURE Creating Web Pages Using Excel - Page 266
Web Feature Introduction - Page 267
Project — Workbook with Chart Saved as a Web Page - Page 268
Overview - Page 269
Overview - Page 270
Overview - Page 271
To Preview the Web Page - Page 272
To Save an Excel Workbook as a Web Page in a Newly Created Folder - Page 273
To Save an Excel Workbook as a Web Page in a Newly Created Folder - Page 274
Saving Workbooks as Web Pages - Page 275
File Management Tools in Excel - Page 276
To View and Manipulate the Web Page Using a Browser - Page 277
Feature Summary - Page 278
In the Lab - Page 279
In the Lab - Page 280
In the Lab - Page 281
CHAPTER FOUR Financial Functions, Data Tables, and Amortization Schedules - Page 282
Introduction - Page 283
Overview - Page 284
Overview - Page 285
Overview - Page 286
Overview - Page 287
Overview - Page 288
Adding Custom Borders and a Background Color to a Range - Page 289
Adding Custom Borders and a Background Color to a Range - Page 290
Adding Custom Borders and a Background Color to a Range - Page 291
Adding Custom Borders and a Background Color to a Range - Page 292
Creating Cell Names Based on Row Titles - Page 293
Creating Cell Names Based on Row Titles - Page 294
More About Cell Names - Page 295
To Enter the Loan Amount Formula Using Names - Page 296
To Enter the PMT Function - Page 297
Other Financial Functions - Page 298
Other Financial Functions - Page 299
Other Financial Functions - Page 300
Using a Data Table to Analyze Worksheet Data - Page 301
Using a Data Table to Analyze Worksheet Data - Page 302
To Create a Percent Series Using the Fill Handle - Page 303
To Create a Percent Series Using the Fill Handle - Page 304
To Define a Range as a Data Table - Page 305
To Define a Range as a Data Table - Page 306
More About Data Tables - Page 307
Adding a Pointer to the Data Table Using Conditional Formatting - Page 308
To Add a Pointer to the Data Table - Page 309
To Add a Pointer to the Data Table - Page 310
Creating an Amortization Schedule - Page 311
Creating an Amortization Schedule - Page 312
Creating an Amortization Schedule - Page 313
To Enter the Formulas in the Amortization Schedule - Page 314
To Enter the Formulas in the Amortization Schedule - Page 315
To Enter the Formulas in the Amortization Schedule - Page 316
To Enter the Formulas in the Amortization Schedule - Page 317
To Copy the Formulas to Fill the Amortization Schedule - Page 318
To Copy the Formulas to Fill the Amortization Schedule - Page 319
To Copy the Formulas to Fill the Amortization Schedule - Page 320
To Copy the Formulas to Fill the Amortization Schedule - Page 321
To Copy the Formulas to Fill the Amortization Schedule - Page 322
To Copy the Formulas to Fill the Amortization Schedule - Page 323
Printing Sections of the Worksheet - Page 324
More About Print Options - Page 325
To Set the Print Area - Page 326
To Name and Print Sections of a Worksheet - Page 327
To Name and Print Sections of a Worksheet - Page 328
To Name and Print Sections of a Worksheet - Page 329
Protecting the Worksheet - Page 330
Protecting the Worksheet - Page 331
More About Worksheet Protection - Page 332
To Hide and Unhide a Sheet - Page 333
To Hide and Unhide a Workbook - Page 334
Formula Checking - Page 335
Formula Checking - Page 336
More About Background Formula Checking - Page 337
More About Background Formula Checking - Page 338
Chapter Summary - Page 339
Learn It Online - Page 340
Learn It Online - Page 341
Extend Your Knowledge - Page 342
Make It Right - Page 343
In the Lab - Page 344
In the Lab - Page 345
In the Lab - Page 346
In the Lab - Page 347
In the Lab - Page 348
In the Lab - Page 349
In the Lab - Page 350
In the Lab - Page 351
Cases and Places - Page 352
Cases and Places - Page 353
CHAPTER FIVE Creating, Sorting, and Querying a Table - Page 354
Introduction - Page 355
Introduction - Page 356
Introduction - Page 357
Overview - Page 358
Overview - Page 359
Overview - Page 360
Overview - Page 361
Overview - Page 362
To Format a Range as a Table - Page 363
To Format a Range as a Table - Page 364
To Validate Data - Page 365
To Validate Data - Page 366
Data Validation Errors and Criteria - Page 367
To Modify a Table Quick Style - Page 368
To Modify a Table Quick Style - Page 369
To Enter Records into a Table - Page 370
To Enter Records into a Table - Page 371
Adding Computational Fields to the Table - Page 372
Adding a Lookup Table - Page 373
Adding a Lookup Table - Page 374
Adding a Lookup Table - Page 375
To Use the VLOOKUP Function to Determine Letter Grades - Page 376
To Use the VLOOKUP Function to Determine Letter Grades - Page 377
Guidelines for Creating a Table in Excel - Page 378
To Add a Conditional Formatting Rule with an Icon Set - Page 379
To Add a Conditional Formatting Rule with an Icon Set - Page 380
Working with Tables in Excel - Page 381
To Use the Total Row Check Box - Page 382
To Use the Total Row Check Box - Page 383
To Use the Total Row Check Box - Page 384
To Print the Table - Page 385
Sorting a Table - Page 386
Sorting a Table - Page 387
To Sort a Table Using the Sort Command on a Column Heading AutoFilter Menu - Page 388
To Sort a Table on Multiple Fields Using the Custom Sort Command - Page 389
To Sort a Table on Multiple Fields Using the Custom Sort Command - Page 390
Displaying Automatic Subtotals in a Table - Page 391
To Display Automatic Subtotals in a Table - Page 392
To Display Automatic Subtotals in a Table - Page 393
To Zoom Out on a Subtotaled Table and Use the Outline Feature - Page 394
To Zoom Out on a Subtotaled Table and Use the Outline Feature - Page 395
To Remove Automatic Subtotals from a Table - Page 396
Querying a Table Using AutoFilter - Page 397
Querying a Table Using AutoFilter - Page 398
More About AutoFilter - Page 399
To Enter Custom Criteria Using AutoFilter - Page 400
To Enter Custom Criteria Using AutoFilter - Page 401
Using a Criteria Range on the Worksheet - Page 402
To Query a Table Using the Advanced Filter Dialog Box - Page 403
Extracting Records - Page 404
To Create an Extract Range and Extract Records - Page 405
To Create an Extract Range and Extract Records - Page 406
More About the Criteria Range - Page 407
Using Database Functions - Page 408
More About Using Database Functions - Page 409
Other Database Functions - Page 410
Other Database Functions - Page 411
Saving a Workbook in Different File Formats - Page 412
To Save a Workbook in CSV File Format - Page 413
To Save a Workbook in CSV File Format - Page 414
To Use Notepad to Open and Print the CSV File - Page 415
Chapter Summary - Page 416
Learn It Online - Page 417
Learn It Online - Page 418
Extend Your Knowledge - Page 419
Extend Your Knowledge - Page 420
Make It Right - Page 421
In the Lab - Page 422
In the Lab - Page 423
In the Lab - Page 424
In the Lab - Page 425
In the Lab - Page 426
In the Lab - Page 427
In the Lab - Page 428
In the Lab - Page 429
In the Lab - Page 430
Cases and Places - Page 431
Cases and Places - Page 432
Cases and Places - Page 433
CHAPTER SIX Creating Templates and Working with Multiple Worksheets and Workbooks - Page 434
Introduction - Page 435
Introduction - Page 436
Introduction - Page 437
Overview - Page 438
Overview - Page 439
Creating the Template - Page 440
Creating the Template - Page 441
Creating the Template - Page 442
To Enter Dummy Data in the Template Using the Fill Handle - Page 443
To Enter Dummy Data in the Template Using the Fill Handle - Page 444
The ROUND Function and Entering Formulas in the Template - Page 445
To Enter Formulas Using Point Mode and Determine Totals in the Template - Page 446
To Enter Formulas Using Point Mode and Determine Totals in the Template - Page 447
To Enter Formulas Using Point Mode and Determine Totals in the Template - Page 448
To Enter Formulas Using Point Mode and Determine Totals in the Template - Page 449
To Save the Template - Page 450
Formatting the Template - Page 451
Formatting the Template - Page 452
To Assign a Currency Style Using the Format Dialog Box - Page 453
To Assign a Currency Style Using the Format Dialog Box - Page 454
To Create and Assign a Custom Format Code and a Comma Style Format - Page 455
To Create and Assign a Custom Format Code and a Comma Style Format - Page 456
To Create a New Style - Page 457
To Create a New Style - Page 458
To Create a New Style - Page 459
To Apply a New Style - Page 460
More About Using Styles - Page 461
More About Using Styles - Page 462
Creating a Workbook from a Template - Page 463
To Add a Worksheet to a Workbook - Page 464
To Add a Worksheet to a Workbook - Page 465
To Copy the Contents of a Worksheet to Other Worksheets in a Workbook - Page 466
To Copy the Contents of a Worksheet to Other Worksheets in a Workbook - Page 467
To Drill an Entry through Worksheets - Page 468
To Drill an Entry through Worksheets - Page 469
To Drill an Entry through Worksheets - Page 470
To Drill an Entry through Worksheets - Page 471
To Drill an Entry through Worksheets - Page 472
Referencing Cells in Other Sheets in a Workbook - Page 473
To Enter and Copy 3-D References Using the Paste Button Menu - Page 474
To Enter and Copy 3-D References Using the Paste Button Menu - Page 475
To Enter and Copy 3-D References Using the Paste Button Menu - Page 476
More About Pasting - Page 477
Drawing the Clustered Cone Chart - Page 478
To Draw the Clustered Cone Chart - Page 479
To Draw the Clustered Cone Chart - Page 480
To Draw the Clustered Cone Chart - Page 481
To Draw the Clustered Cone Chart - Page 482
To Add a Chart Title Using the WordArt Tool - Page 483
To Add a Chart Title Using the WordArt Tool - Page 484
To Add a Chart Title Using the WordArt Tool - Page 485
To Add a Text Box, Arrow, and Brace to the Chart - Page 486
To Add a Text Box, Arrow, and Brace to the Chart - Page 487
Adding a Header and Footer, Changing the Margins, and Printing the Workbook - Page 488
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally - Page 489
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally - Page 490
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally - Page 491
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally - Page 492
Selecting and Deselecting Sheets - Page 493
Selecting and Deselecting Sheets - Page 494
To Insert and Remove a Page Break - Page 495
To Hide Page Breaks - Page 496
Saving a Workbook as a PDF or XPS file - Page 497
The Find and Replace Commands - Page 498
The Find and Replace Commands - Page 499
Working with the Find and Replace Dialog Box - Page 500
Working with the Find and Replace Dialog Box - Page 501
Consolidating Data by Linking Workbooks - Page 502
To Search for and Open Workbooks - Page 503
To Search for and Open Workbooks - Page 504
To Create a Workspace File - Page 505
To Create a Workspace File - Page 506
Updating Links - Page 507
Chapter Summary - Page 508
Learn It Online - Page 509
Learn It Online - Page 510
Extend Your Knowledge - Page 511
Make It Right - Page 512
In the Lab - Page 513
In the Lab - Page 514
In the Lab - Page 515
In the Lab - Page 516
In the Lab - Page 517
In the Lab - Page 518
In the Lab - Page 519
In the Lab - Page 520
Cases and Places - Page 521
Cases and Places - Page 522
Cases and Places - Page 523
GRAPHICS FEATURE SmartArt and Images - Page 524
Graphics Feature Introduction - Page 525
Graphics Feature Introduction - Page 526
Working with SmartArt Graphics - Page 527
Working with SmartArt Graphics - Page 528
Working with SmartArt Graphics - Page 529
Working with SmartArt Graphics - Page 530
To Add Shapes and Modify Text in the Organization Chart - Page 531
To Add Shapes and Modify Text in the Organization Chart - Page 532
To Add Shapes and Modify Text in the Organization Chart - Page 533
To Add Shapes and Modify Text in the Organization Chart - Page 534
To Change the Position of Shapes and Add Effects to the Organization Chart - Page 535
To Change the Position of Shapes and Add Effects to the Organization Chart - Page 536
To Change the Position of Shapes and Add Effects to the Organization Chart - Page 537
Using Images on a Worksheet - Page 538
To Insert and Modify an Image in the Worksheet - Page 539
To Insert and Modify an Image in the Worksheet - Page 540
To Insert and Modify an Image in the Worksheet - Page 541
Feature Summary - Page 542
In the Lab - Page 543
In the Lab - Page 544
In the Lab - Page 545
APPENDIX A Project Planning Guidelines - Page 546
Gather Possible Content - Page 547
APPENDIX B Introduction to Microsoft Office 2007 - Page 548
Office 2007 and the Internet, World Wide Web, and Intranets - Page 549
Microsoft Office Excel 2007 - Page 550
Microsoft Office PowerPoint 2007 - Page 551
Microsoft Office 2007 Help - Page 552
Microsoft Office 2007 Help - Page 553
APPENDIX C Microsoft Office Excel 2007 Help - Page 554
To Open the Excel Help Window - Page 555
The Excel Help Window - Page 556
Toolbar Buttons - Page 557
Searching Excel Help - Page 558
Searching Excel Help - Page 559
To Obtain Help Using the Help Links - Page 560
To Obtain Help Using the Help Table of Contents - Page 561
Obtaining Help while Working in Excel Use Help - Page 562
Use Help - Page 563
APPENDIX D Publishing Office 2007 Web Pages to a Web Server - Page 564
Using FTP to Publish Office 2007 Web Pages - Page 565
APPENDIX E Customizing Microsoft Office Excel 2007 - Page 566
APPENDIX E Customizing Microsoft Office Excel 2007 - Page 567
APPENDIX E Customizing Microsoft Office Excel 2007 - Page 568
Screen Resolution and the Appearance of the Ribbon in Office 2007 Programs - Page 569
Customizing the Excel Window - Page 570
Customizing and Resetting the Quick Access Toolbar - Page 571
To Add Commands to the Quick Access Toolbar Using the Customize Quick Access Toolbar Menu - Page 572
To Add Commands to the Quick Access Toolbar Using the Shortcut Menu - Page 573
To Add Commands to the Quick Access Toolbar Using Excel Options - Page 574
To Add Commands to the Quick Access Toolbar Using Excel Options - Page 575
To Add Commands to the Quick Access Toolbar Using Excel Options - Page 576
To Remove a Command from the Quick Access Toolbar - Page 577
To Reset the Quick Access Toolbar - Page 578
Changing the Excel Color Scheme - Page 579
APPENDIX F Steps for the Windows XP User - Page 580
To Save a Workbook - Page 581
To Save a Workbook - Page 582
To Open a Workbook - Page 583
To Insert a Picture - Page 584
APPENDIX G Microsoft Business Certification Program - Page 585