Microsoft Office Excel 2007 QuickSteps

Acknowledgments     iv
Introduction     xii
Stepping into Excel     1
Opening Excel     3
Get Started with Excel     3
Explore the Excel Window     3
Create a Workbook     3
Understanding the Ribbon     7
Open an Existing Workbook     7
Change the Appearance of New Workbooks     8
Customize the Quick Access Toolbar     10
Get Help     14
Open Help     15
Use the Excel Help Window     16
Understanding Excel's XML File Formats     18
Close Your Excel Workbook     18
Save a Workbook Automatically     18
Save a Workbook Manually     21
Save a Copy of Your Workbook     22
Add Identifying Information     22
Understanding Excel File Compatibility     24
Exit an Excel Session     24
Entering and Editing Data     25
Understanding Data Types     26
Enter Data     26
Enter Text     26
Enter Numeric Data     29
Completing an Entry     30
Enter Dates     30
Use Times     31
Formatting Numbers     32
Understanding Excel Dates and Times     34
Edit Data     35
Edit Cell Data     35
Adding Data Quickly     36
Remove Cell Contents     36
Copy and Paste Data     38
Selecting Cells and Ranges     39
Use Paste Special     39
Find and Replace Data     39
Verify Spelling     42
Modify Automatic Corrections     44
Formatting a Worksheet     45
Adding and Removing Rows, Colunms, and Cells     46
Work with Cells, Rows, and Columns     46
Adjust Row Height     46
Adjust Column Width     47
Hide and Unhide Rows and Columns     48
Change Cell Borders     49
Add a Comment     51
Formatting Comments     53
Apply Formatting     53
Understanding Excel Formatting     54
Apply Themes     54
Create Custom Themes     59
Searching for Themes     60
Use Cell Styles     60
Change Fonts     64
Change Alignment and Orientation     65
Add a Background     66
Transfer Formatting     68
Arrange and Organize Worksheets     69
Lock Rows and Columns     69
Split a Worksheet     71
Working with Worksheets     72
View Worksheets from Multiple Workbooks     72
Compare Workbooks     72
Using Formulas and Functions     75
Understanding Cell Referencing Types     76
Reference Cells     76
Change Cell References     76
Change to R1C1 References     76
Name Cells     77
Using Cell Reference Operators     79
Go to a Named Cell     79
Build Formulas     79
Create a Formula     79
Working with Cell Names     80
Edit a Formula     82
Move Formulas     83
Using Formulas     84
Copy Formulas     84
Recalculate Formulas     85
Use External References in Formulas     85
Understanding the Trust Center     87
Format Conditionally     91
Using Functions Quickly     95
Use Functions     95
Enter a Function     95
Enter a Sum in Columns or Rows Quickly      98
Find and Correct Errors     98
Check for Errors     98
Trace Precedent and Dependent Cells     100
Watch a Cell     100
Evaluate a Formula in Pieces     101
Viewing and Printing Data     103
Understanding Excel Views     104
Lay Out a Worksheet     104
Add Headers and Footers     104
Adding Content to Headers and Footers     109
Add Pictures to Headers and Footers     109
Change Margins     110
Select Page Orientation     112
Use Headers as Page Titles     112
Working with Zoom     114
Print the Data     115
Change the Order in Which Pages Print     115
Choosing Worksheet Print Options     116
Print Comments     116
Use Print Areas     116
Choosing What to Print     118
Preview the Print Job     119
Scale Your Data Before Printing     125
Output the Print Job     125
Charting Data     129
Building a Chart     131
Create and Design a Chart     131
Choose a Chart Type     131
Selecting Data for Charting      134
Choose a Chart Location     134
Modify How the Data Is Plotted     137
Apply a Chart Layout     139
Change a Chart's Style     140
Selecting Chart Elements     141
Modify Chart Elements     141
Add Titles     141
Show or Hide Axes     142
Add or Remove Gridlines     142
Identifying Chart Elements     143
Show or Hide a Legend     143
Add Data Labels     143
Display the Data Table     145
Create Your Own Chart Type     145
Add a Second Value Axis     146
Format Chart Elements     147
Working with Charts     148
Use Charts     149
Add Charts Elsewhere     149
Analyze Charts     150
Print a Chart     153
Working with Shapes and Pictures     155
Understanding Shapes     156
Add Shapes, Pictures, and Text     156
Add Shapes     156
Working with Curves     157
Insert Pictures     158
Using Pictures     163
Organize Pictures     163
Add Text     167
Use SmartArt      169
Changing SmartArt     171
Working with Shapes     171
Select, View, and Delete Shapes     171
Using Handles and Borders to Change Shapes     173
Crop Pictures     174
Position Shapes     175
Combining Shapes by Grouping     177
Formatting Shapes and Text     177
Use Styles     177
Apply Styling Elements to Pictures     178
Changing a Picture's Attributes     180
Change a Shape's Fill     180
Add WordArt Styling to Text     181
Make Detailed Formatting Changes     184
Managing Data     185
Understanding Excel Tables     186
Build Tables     186
Create a Table     186
Adding Rows and Columns to a Table     189
Delete Rows and Columns Within a Table     189
Add a Total Row     189
Apply Styles to a Table     190
Working with Tables     192
Validate Data     195
Locating Validation Data     197
Organize Data     198
Sort Data by Columns     199
Sort Data by Rows     202
Removing Filters      203
Create an AutoFilter     203
Setting Up Criteria and Extract Ranges     206
Use Advanced Filtering     206
Outline Data Automatically     207
Using Outlines     208
Outline Data by Manually Grouping     210
Add Subtotals     210
Add Styles to an Outline     211
Analyzing and Sharing Data     213
Get the Results You Want     213
Use Goal Seek     214
Compare Alternatives Using Scenarios     216
Use Multiple Variables to Provide a Result     219
Save Solver Results and Settings     222
Changing Solver Settings     224
Work with PivotTables     224
Create a PivotTable     224
Understanding PivotTable Terms     225
Create the PivotTable Layout     225
Style a PivotTable     229
Using PivotTables     231
Create a PivotTable Chart     231
Work with Other Users     234
Protect Workbooks with Passwords     234
Share a Workbook     235
Working with Changes in a Shared Workbook     237
Protect a Shared Workbook     237
Discontinue Sharing a Workbook     238
Work with Views     240
Protect Worksheet and Workbook Elements     241
Extending Excel     243
Acquire Data     244
Convert Text to Data     244
Add a Table from an Access Database     246
Get Data from the Web     247
Add External Data from Existing Connections     248
Setting External Data Range Properties     249
Manage Connections     249
Use Excel with Web Technology     252
Understanding the Difference Between Save and Publish     253
Save a Workbook as a Web Page     253
Publish Workbook Items as a Web Page     255
Understanding Excel Services     256
Use Hyperlinks     256
Automate Excel     260
Use Recorded Macros     260
Edit a Macro     262
Index     265