Teach Yourself VISUALLY Excel 2007 by Nancy C. Muir

Excel Basics
An Introduction to Excel     4
Start and Close Excel     6
Navigate the Excel Program Window     8
Understanding the Ribbon, Galleries, and Contextual Tools     10
Change Views     12
Customize the Quick Access Toolbar     14
Display Task Panes     16
Find Help     18
Workbook Fundamentals
Start a New Workbook File     22
Save a Workbook     23
Publish a Workbook as an Excel Binary Workbook     24
Open an Existing Workbook     25
Close a Workbook     26
Delete a Workbook     27
Arrange Workbook Windows     28
Protect a Workbook     30
Hide or Show a Worksheet     31
Entering Data
Enter Data     37
Turn On Text Wrapping     39
Resize Columns and Rows     40
Select Cells     40
Enter Data with AutoFill     42
Work with AutoCorrect     44
Edit Data     45
Work with Smart Tags     46
Check Spelling in a Worksheet     47
Working with Worksheets
Understanding Worksheet Structure     52
Navigate Worksheets     54
Name a Worksheet     56
Add a Worksheet     57
Delete a Worksheet     58
Move a Worksheet     59
Copy a Worksheet     60
Format Worksheet Tab Color     61
Protect Worksheet Data     62
Selecting Data with Formulas and Functions
Understanding Formulas     66
Create Formulas     68
Reference Absolute and Relative Cells     70
Copy Formulas     72
Name Cells and Ranges     74
Reference Ranges in Formulas     76
Reference Cells from Other Worksheets     77
Understanding Functions     78
Apply a Function     80
Total Cells with AutoSum     84
Check for Formula Errors     86
Audit a Worksheet for Errors     88
Rearranging Worksheet Data
Move and Copy Data     94
Delete Data or Cells     96
Add Columns and Rows     98
Delete Columns and Rows     100
Center Data across Columns     102
Transpose Columns and Rows     103
Set Column Width and Row Height     104
Hide Columns and Rows     106
Freeze a Column or Row      108
Split a Worksheet into Panes     109
Find and Replace Data     110
Formatting Worksheets
Apply Bold, Italics, and Underlining     114
Change the Font and Size     116
Change Number Formats     118
Increase or Decrease Decimals     120
Change Data Color     121
Apply Workbook Themes     122
Align Cell Data     124
Rotate Cell Data     126
Control Text Wrap     127
Add Borders     128
Add Background Color to Cells     130
Assign a Background to a Worksheet     132
Copy Cell Formatting     133
Apply a Style     134
Assign Conditional Formatting     136
Enhancing Worksheets with Graphics
Insert Image Files     140
Insert Clip Art     142
View Clip Art with the Clip Organizer     144
Download Clip Art from the Web     146
Draw Shapes     148
Add a WordArt Object     150
Move and Resize Objects     152
Rotate and Flip Objects     154
Crop a Picture     156
Add Shadow and 3-D Effects     158
Format an Object     160
Group and Ungroup Objects     162
Previewing and Printing
Add Headers and Footers     166
Insert Page Breaks     168
Preview a Worksheet     170
Set Up Printing Options     172
Print a Worksheet     174
Define a Print Area     175
Communicating Information with Charts
Understanding Excel Charts     178
Create a Chart with Galleries     180
Move and Resize Charts     182
Change the Chart Type     184
Change the Axes Titles     185
Manipulate 3-D Charts     186
Format Chart Objects     188
Add Chart Objects     190
Change the Chart Data     191
Format Charts with Layouts and Styles     192
Insert SmartArt Charts     193
Analyzing Worksheet Data
Understanding Database Lists     196
Create a Database Table     198
Add Records Using a Data Form     202
Edit Records     204
Search for Records     206
Identify Duplicate Values in a Table     207
Set Data Validation Rules     208
Sort Records     210
Filter Data with AutoFilter     212
Analyze Data with a PivotTable     214
Using Excel Tools
Add a Watch Window     220
Load Add-Ins     222
Analyze Data with Add-In Tools     224
Examine Alternatives with Goal Seek     226
Create Scenarios     228
Optimize Formulas with Solver     232
Sharing Excel Data
Link Data     236
Edit Linked Data     238
Link Between Worksheets     239
Embed Objects     240
Enable Workbook Sharing     242
Add a Comment     244
Track and Review Workbook Changes     246
Merge Workbooks     250
E-mail a Workbook     252
Import Data     254
Export Data     255
Using Excel on the Web
Add Web Tools to the Quick Access Toolbar     258
Publish a Workbook as a Web Page     260
Insert a Hyperlink     262
Download a Stock Quote     264
Copy Web Data to a Worksheet     266
Run a Web Query     268
Improving Excel Efficiency
Personalize the Excel Program Window     274
Change the Default Font     276
Change the Default File Location     277
Open Files in a Specified Folder Automatically     278
Set Macro Security     279
Record a Macro     280
Create an Excel Template     282
Apply an Excel Template     284