Index
Numbers
2-D charts, backgrounds, 185
3-D charts
backgrounds, 186
formatting options, 199
3-D references, 272
cell or range by clicking, 273
cell or range by typing, 274
named cell or range, 273
Paste Link command, 274
sum formula for same cell, 276
writing formulas, 275
A
ABS function, 85
absolute references, 50–51
Accept or Reject Changes dialog, 241
Accounting Number Format button, 107
accounting, number formatting, 106
activating cells, 24–25
Add View dialog, 282
addresses, cells, 24
advanced options, Options dialog
cut, copy, and paste, 310
Display, 310–313
editing, 308–309
Formulas, 314
General, 315–316
Lotus compatibility, 317
print, 310
advanced techniques, 265
3-D references, 272
cell or range by clicking, 273
cell or range by typing, 274
named cell or range, 273
Paste Link command, 274
sum formula for same cell, 276
writing formulas, 275
Consolidate command, 279–281
custom views, 282–283
macros, 284–285
names feature, 266
applying to existing formulas, 270
creating names, 268
defining name, 267
deleting name, 268
entering name in formula, 269
modifying name, 268
selecting named cells, 271
opening workbooks with links, 277–278
alignment
chart formatting, 198
cell orientation, 116–117
changing text direction, 117
indent cell content, 113
merge and center, 115
text, 111–112
wrap text, 114
graphic objects, 160
Alignment group options
cell orientation change, 116
indent cell contents, 113
merge and center cells, 115
text alignment, 111–112
wrapping text, 114
Allow Users to Edit Ranges dialog, 246
amortization tables, financial functions, 94
Apply Names dialog, 270
arguments, functions, 74–75
Arrange Windows dialog, 68
arrows, drawing, 145–146
AutoCorrect dialog, 304
AutoCorrection options, 304
AutoFill feature, 48
AutoFilter, tables, 229–230
AutoFit Column Width command, 138
AutoFit feature, formatting cells, 138
AutoRecover, 306
AutoShapes, modifying, 159
AutoSum button, 82–83
AVERAGE function, 88
Axes group, 182
Axis options, 190
category axis options, 191
series axis options, 193
value axis options, 192
axis, chart options, 182–183
B
Background group, 185
backgrounds
chart fill, 185–186
printing, 214
Blank Workbook template, 20
Bold command, 9
Border button, 121
borders
charts
color formatting, 195
style, 196
formatting
Border button, 121
cells, 105
Format Cells dialog, 122
Bottom align option, 111
Breaks menu, 215–216
Bring to Front button, 161
browsing, help feature, 15
buttons, 8
Accounting Number Format, 107
Insert Options, 310
Paste Options, 310
Redo, 56
Ribbon, 5
Save, 72
Undo, 56
C
Calculation options, Options dialog, 301–303
cascading windows, 68
category axis options, 191
cell pointers, 2–3
Cell Styles menu, 129
cells
activating, 24–25
converting to table, 225
editing content, 38–39
Copy and Paste command, 44–45
copying, 43
deleting, 40–42
Fill command copying, 47
fill handle copying, 46
formulas, 49
inserting, 40–42
moving, 52–53
Error Checking Smart Tags, 35
fill handles, 46
formatting
alignment, 110–117
AutoFit, 138
basics, 105
borders, 121–122
column width, 135–137
Conditional, 130–133
font, 118–120
Format Painter, 134
numbers, 105–109
removing, 139
row height, 135–137
shading, 123–124
styles, 125–129
themes, 125–129
inserting, 40–42
orientation, 116–117
pointer movement keys, 25
selecting
columns, 26
deselecting, 28
entire worksheet, 27
going to, 26
multiple columns or rows, 27
multiple ranges, 28
range of cells with mouse, 25
rows, 26
series, 48
worksheet inputs, 17
Centered Overlay Title option, 178
centering
cells, 115
printing options, 206–207
Change Chart Type dialog, 173
Changes group, 243
Chart Floor menu, chart background, 185
Chart Layouts group, 176
inserting, 61
sheet types, 59
Chart Style group, 176
Chart Wall menu, chart background, 185
charts, 167
axis options, 182–183
background fill, 185–186
deselecting, 170
design options, 172
data series change, 174–175
set layout, 176
style, 176
switch row and column data, 174
templates, 173
types, 173
elements, 177
formatting, 187–188
3-D options, 199
alignment options, 198
axis options, 190–193
border color, 195
border style, 196
data table options, 190
fill options, 194
label options, 189
legend options, 189
line color, 195
line style, 196
number options, 198
shadow options, 197
gridlines, 184
inserting, 168
labels
customizing text, 181
data table, 181
horizontal axis title, 179
legend, 180
setting data labels, 180
title, 178
vertical axis title, 179
moving, 171
printing options, 213
resizing, 170
selecting, 170
worksheet links, 169
Charts group, 168
check boxes, dialog components, 11
Clear menu commands, 39
clicking
entering functions, 79
mouse, 4
clip art, 141
inserting, 143–144
Clip Art pane, 143
Close button, 3
closing windows, 69
collaboration
comments, 236–238
Document Properties pane, 234–235
document protection, 243
allowing editing of ranges, 246–247
locking selected cells, 245
Protect Sheet dialog, 244
unprotect sheet, 244
unprotecting workbook, 248
workbook protection, 248–249
features, 233
save options
opening file, 253
setting, 252
sharing workbooks, 250–251
tracking
accept or reject revisions, 241
removing revisions, 242
revisions, 240
turning on or off, 239–240
viewing information, 240
color
chart formatting
borders, 195
lines, 195
shading, 123
sheet tab change, 63
table styles, 227
Color dialog, 307
Column Width dialog, 137
columns
charts, switching data, 174
deleting, 41
formatting cells, 105
headings, 2–3
inserting, 40
matching record contents, 229
multiple selection, 27
Print Preview, 221
selecting, 26
special table formatting, 227
width formatting, 135
changing with mouse, 136
hiding, 137
menu command changes, 137
commands
Bold, 9
Clear menu, 39
Copy, 44–45
Cut, 52
Delete Sheet, 62
Fill, 47
Hide Sheet, 64
Insert Sheet, 61
menu selection, 7
Move or Copy Sheet, 65
New Window, 67
Paste Link, 274
Print, 9
Rename Sheet, 62
Ribbon, 5
Save, 9
Series, 48
Sort, 231
Start Mail Merge, 261
Stop Recording, 284
Tab Color, 63
Undo, 56
Unhide Sheet, 64
comments, collaboration, 236–238
components, dialogs, 11–12
CONCATENATE function, 102
Conditional Formatting
add data bars to cells, 132
cells above certain value, 131
customizing rules, 133
rules, 130
Confirm Password dialog, 248
connectors, drawing, 145–146
Consolidate command, 279–281
Consolidate dialog, 279
Context-sensitive Help, 14
contextual menus, 6–7
Copy command, 44–45
Office Clipboard, 54
copying
cells
Copy and Paste commands, 44–45
editing worksheet content, 43
Fill command, 47
fill handle, 46
formulas, 49
graphic objects, 154
Office Clipboard, 54
sheets, 65
COS function, 87
COUNT function, 89
COUNTA function, 89
Create Names from Selection dialog, 268
Create Table dialog, 224
currency, number formatting, 106
Current Selection group, 177
Curve tool, 146
Custom AutoFilter dialog, 230
Custom Footer button, 208
custom formatting
headers and footers, 208–209
numbers, 106
custom views, 282–283
Custom Views dialog, 282
Cut command
moving cells, 52
moving graphic objects, 153
D
data
charts, 167
axis options, 182–183
background fill, 185–186
deselecting, 170
design options, 172–176
elements, 177
formatting, 187–199
gridlines, 184
inserting, 168
labels, 178–181
moving, 171
printing options, 213
resizing, 170
selecting, 170
worksheet links, 169
entering in table, 228
Word data merge source, 261
data bars, adding to cells, 132
Data Labels menu, 180
data series, chart design options, 174–175
Data Table menu, 181
Data Table options, 190
DATE function, 100–101
date, number formatting, 106
DAY function, 101
DB function, 91
DDB function, 91
decimals, place change, 107
Defined Names group, 267
DEGREES function, 87
Delete Sheet command, 62
deleting
cells, 40–42
columns, 41
comments, 237
custom views, 283
graphic objects, 154
hyperlinks, 296
names, 268
Office Clipboard, 54
rows, 41
sheets, 62
depth axis options, 183
depth gridline options, 184
deselecting cells, 28
designs, chart options, 172
data series change, 174–175
set layout, 176
style, 176
switch row and column data, 174
templates, 173
types, 173
Dialog Box Launcher button, 10
dialogs
components, 11–12
displaying, 10
ellipsis (...), 6
display, Options dialog options, 310–311
document files. See also workbooks
collaboration protection, 243
allowing editing of ranges, 246–247
locking selected cells, 245
Protect Sheet dialog, 244
unprotect sheet, 244
unprotecting workbook, 248
workbook protection, 248–249
creating, 20
based on existing, 23
blanks, 21
installed template, 21
online templates, 22
including Word document content, 260
running Excel program, 18
Document Properties pane, collaboration, 234–235
document windows, scrolling, 13
double-clicking, mouse, 4
drag & drop, moving cells, 53
dragging
mouse, 4
resizing graphic objects, 155
rotating graphic objects, 157
drawing, graphic objects
line, arrow, or connector, 145–146
shapes, 147
drop-down lists, 6
dialog components, 11
Number Format, 107
E
Edit Hyperlink dialog, 296
Edit Name dialog, 268
Edit Series dialog, 175
editing
comments, 237
names, 268
Options dialog, 308–309
worksheets, 37
AutoFill, 48
cell contents, 38–39
copy and pasting, 44–45
copying cells, 43
deleting cells, 40–42
Fill command copying, 47
fill handle copying, 46
formulas, 49
inserting cells, 40–42
moving cells, 52–53
Office Clipboard, 54–55
redo actions, 57
references, 50–51
series, 48
undoing actions, 56
elements, charts, 177
ellipsis (...), dialogs, 6
empty tables, creating, 224
entry fields, dialog components, 11
equal signs, functions, 75
Error Checking Smart Tags, 35
error checking, Calculation options, 302–303
error values, function arguments, 76
EVEN function, 85
Excel
exiting, 19
screen, 2–3
starting program, 18
Excel Help and How-to, 14
Excel Options dialog, 278
expressions, Excel evaluation, 31
F
files, documents. See document files
Fill Color menu, applying shading, 123
Fill command, copying cells, 47
fill handles
copying cells, 46
creating series, 48
Fill options, 194
fills
chart background, 185–186
formatting cells, 105
filters, tables, 229–230
financial functions
amortization table, 94
DB, 91
DDB, 91
FV, 96
IRR, 96
loan payment calculation, 93
PMT, 92
PV, 96
savings goal contributions, 95
SLN, 91
SYD, 91
Font groups
applying formatting fonts, 119
Border button, 121
Fill Color menu, 123
fonts, formatting cells, 105, 118
Font group options, 119
Format Cells dialog, 120
footers
built-in, 207
custom, 208–209
removing, 209
setting additional options, 210
Format Cells dialog, 10, 108–109
border formatting, 122
cell orientation change, 116–117
creating custom rules, 133
font formatting, 120
indent cell contents, 113
merge and center cells, 115
shading, 124
text alignment, 111–112
wrapping text, 114
Format dialog, 188–198
Format Legend dialog, 187
Format Painter, 134
Format Picture button, 208
Format Shape dialog, 162
Format Text button, 208
formatting
cells
alignment, 110–117
AutoFit, 138
basics, 105
borders, 121–122
column width, 135–137
Conditional, 130–133
font, 118–120
Format Painter, 134
numbers, 105–109
removing, 139
row height, 135–137
shading, 123–124
styles, 125–129
themes, 125–129
charts, 187–188
3-D options, 199
alignment options, 198
axis options, 190–193
border color, 195
border style, 196
data table options, 190
fill options, 194
label options, 189
legend options, 189
line color, 195
line style, 196
number options, 198
shadow options, 197
formulas, 29
3-D references, 272
cell or range by clicking, 273
cell or range by typing, 274
named cell or range, 273
Paste Link command, 274
sum formula for same cell, 276
writing formulas, 275
basics, 31–32
Calculation options, 302
copying cells, 49
entering by clicking, 34
entering by typing, 33
function arguments, 76
name feature
applying to existing, 270
entering, 269
Options dialog options, 314
worksheet inputs, 17
fraction, number formatting, 106
Freeform tool, 146
Function Argument ToolTips feature, 77
Function Arguments dialog, 77, 80–81
functions
anatomy, 75
arguments, 74–75
date and time, 100–101
entering, 77
Insert Function dialog, 80–81
typing, 78
typing and clicking, 79
financial
amortization table, 94
DB, 91
DDB, 91
FV, 96
IRR, 96
loan payment calculation, 93
PMT, 92
PV, 96
savings goal contributions, 95
SLN, 91
SYD, 91
information, 99
logical, 97
lookup, 98
mathematical and trigonometric
ABS, 85
AutoSum button, 82–83
COS, 87
DEGREES, 87
EVEN, 85
INT, 85
ODD, 85
PI, 86
PRODUCT, 84
RADIANS, 87
RAND, 86
ROUND, 84
SIN, 87
SQRT, 86
SUM, 82
TAN, 87
statistical
AVERAGE, 88
COUNT, 89
COUNTA, 89
MAX, 89
MEDIAN, 88
MIN, 89
MODE, 89
STDEV, 90
STDEVP, 90
text, 102–103
FV function, 96
G
General options, 315–316
General Options dialog, 252
graphic objects, 141
alignment, 160
applying styles, 162
clip art, 143–144
copying, 154
deleting, 154
deselecting, 151
drawing
line, arrow, or connector, 145–146
shapes, 147
grouping, 152
modifying AutoShapes, 159
moving, 153
pictures, 142
applying styles, 165–166
setting adjustment, 164
resizing, 155–156
rotating, 157–158
selecting, 151
SmartArt, 148
stacking order change, 161
text boxes, 149
ungrouping, 152
Greater Than dialog, 131
grouping graphic objects, 152
groups, Ribbon, 5
H
Header dialog, 208
headers
adding to table, 226
built-in, 207
custom, 208–209
removing, 209
setting additional options, 210
headings
columns, 2–3
rows, 2–3
help feature
browsing, 15
displaying, 14
searching, 16
Hide Columns command, 137
Hide Sheet command, 64
hiding
columns and rows, 137
sheets, 64
windows, 69
Highlight Changes dialog, 239
HLOOKUP function, 98
horizontal axis, chart title, 179
horizontal text alignment, 111–112
horizontal windows, 68
HTML (HyperText Markup Language), 287
hyperlinks, 287
Web publishing, 292
following, 295
inserting, 293–294
modify or delete, 296
HyperText Markup Language (HTML), 287
I
icons, previous Excel versions, 18
IF function, 97
indenting cell content, 113
information functions, 99
inputs
formulas, 29
values, 29
worksheet cells, 17
Insert Date button, 208
Insert File Name button, 208
Insert File Path button, 208
Insert Function dialog, 77, 80–81
Insert Hyperlink dialog, 293
Insert Number of Pages button, 208
Insert Options button, 310
Insert Page Number button, 208
Insert Picture button, 208
Insert Picture dialog, 142
Insert Sheet command, 61
Insert Sheet Name button, 208
Insert Time button, 208
inserting
cells, 40–42
chart sheets, 61
charts, 168
columns, 40
hyperlinks, 293–294
objects, 256–258
pictures, 142
rows, 40
WordArt, 150
worksheets, 61
INT function, 85
Internet publishing, 287
creating Web pages, 288
automatic workbook save, 291
save workbook, 289–290
hyperlinks, 292
following, 295
inserting, 293–294
modify or delete, 296
IRR function, 96
IS function, 99
J
keyboard shortcut keys, 9
L
labels, charts
customizing text, 181
data table, 181
formatting options, 189
horizontal axis title, 179
legend, 180
setting data labels, 180
titles, 178
vertical axis title, 179
LEFT function, 102
Legend menu, 180
Legend Options pane, 189
legends
chart formatting, 189
chart labels, 180
lines
chart formatting
color, 195
style, 196
drawing, 145–146
links
hyperlinks, 287
opening workbooks with, 277–278
worksheet and charts, 169
list boxes, dialog components, 11
loan payments, financial functions, 93
logical functions, 97
logical values, function arguments, 76
lookup functions, 98
Lotus compatibility, 317
LOWER function, 102
H
Macro dialog, 285
macros
recording, 284
running, 284
magnification, windows, 70
margins
Print Preview, 221
printing options, 206
mathematical functions
ABS, 85
AutoSum button, 82–83
COS, 87
DEGREES, 87
EVEN, 85
INT, 85
ODD, 85
PI, 86
PRODUCT, 84
RADIANS, 87
RAND, 86
ROUND, 84
SIN, 87
SQRT, 86
SUM, 82
TAN, 87
mathematical operators, 31
MAX function, 89
Maximize button, 3
MEDIAN function, 88
menus, 6
button use, 8
command selection, 7
shortcuts, 7
merging cells, 115
Microsoft Office button, 2
Microsoft Office Security Options dialog, 277
MID function, 102
Middle align option, 111
MIN function, 89
Minimize button, 3
mixed references, 51
MODE function, 89
modifier keys, shortcuts, 9
MONTH function, 101
mouse
appearance, 4
pointer, 2–3
row and column formatting, 136
techniques, 4
worksheet cell movement, 25
Move Chart dialog, 61
Move or Copy dialog, 65
Move or Copy Sheet command, 65
moving
charts, 171
graphic objects, 153
sheets, 65
N
name functions, 75
Name Manager dialog, 268
names feature, 266
applying to existing formulas, 270
creating names, 268
defining name, 267
deleting name, 268
entering name in formula, 269
modifying name, 268
selecting named cells, 271
New Formatting Rule dialog, 133
New from Existing Workbook dialog, 23
New Name dialog, 267
New Range dialog, 246
New Window command, 67
New Workbook dialog, 20
based on existing, 23
blanks, 21
installed template, 21
online templates, 22
NOW function, 101
Number Format drop-down list, 107
numbers
chart formatting, 198
formatting cells, 105–106
decimal place change, 107
Format Cells dialog, 108–109
Number group option, 107
function arguments, 76
O
Object and Linking and Embedding (OLE), 256–258
Object dialog, 257
ODD function, 85
Office Clipboard, 54–55
offline editing, 307
OLE (Object and Linking and Embedding), 256–258
Open dialog, 74
operators, formulas, 31
option buttons, dialog components, 11
Options button, 298
advanced options
cut, copy, and paste, 310
Display, 310–313
editing, 308–309
Formulas, 314
General, 315–316
Lotus compatibility, 317
print, 310
Calculation options, 301–303
Popular category, 299–300
Proofing options, 304–305
Save options, 306–307
options, setting. See Options dialog
orientation, printing, 204
Outlook, using with Excel, 262–263
P
Page Break Preview, 216
page breaks, printing, 215–216
Page Layout view, 217–218
Page options, printing, 205
Page Setup dialog, 203, 205–206
page setup options, printing, 202–203
built-in header and footers, 207
centering options, 206–207
chart options, 213
custom header and footers, 208–209
margins, 206
opening Page Setup dialog, 203
Page options, 205
paper size, 204
print area, 211
removing headers and footers, 209
scaling, 204
setting additional options, 210
setting orientation, 204
sheet options, 211–213
panes, adjusting windows, 71
paper size, printing options, 204
Paste command, 44–45
moving cells, 52
moving graphic objects, 153
Paste Link command, 3-D references, 274
Paste Options button, 310
Paste Special dialog, 45
percentage, number formatting, 106
personal information management software, 262
PI function, 86
Picture Border menu, 165
Picture dialog, 142
Picture Styles group, 165
pictures, 141
applying styles, 165–166
inserting, 142
setting adjustments, 164
Plot Area menu, chart background, 185
PMT function, 92
pointer (mouse), appearance, 4
pointing, mouse, 4
pop-up menus, 6
Popular category, Options dialog, 299–300
preview areas, dialog components, 11
Primary Horizontal Axis Title submenu, 179
Primary Horizontal Gridlines submenu, 184
Primary Vertical Axis Title submenu, 179
Print Area menu, 211
print areas, 211
Print command, 9
Print dialog, 222
Print Preview, 219
margin and column options, 221
reports, 220
printing, 201
background images, 214
comments, 238
Options dialog options, 310
page breaks, 215–216
Page Layout view, 217–218
page setup options, 202–203
built-in header and footers, 207
centering options, 206–207
chart options, 213
custom header and footers, 208–209
margins, 206
opening Page Setup dialog, 203
Page options, 205
paper size, 204
print area, 211
removing headers and footers, 209
scaling, 204
setting additional options, 210
setting orientation, 204
sheet options, 211–213
Print dialog, 222
Print Preview, 219
margin and column options, 221
reports, 220
PRODUCT function, 84
programs
OLE (Object and Linking and Embedding), 256–258
Outlook, using with Excel, 262–263
using Excel with, 255
Word, 259
Excel table as data source, 261
including content in Excel, 260
Proofing options, Options dialog, 304–305
PROPER function, 102
Properties dialog, 235
Properties group, 225
Protect Sheet button, 244
Protect Sheet dialog, 244
Protect Structure and Windows dialog, 248
Publish button, 291
push buttons, dialog components, 12
PV function, 96
Q
Quick Access toolbar, 2
R
RADIANS function, 87
RAND function, 86
Range Finder feature, 169
Range Finder frames, editing cells, 38
ranges
converting to table, 225
Record Macro dialog, 284
Redo button, 56–57
references
3-D, 272
lookup functions, 98
relative versus absolute, 50–51
relative references, 50–51
Rename Sheet command, 62
renaming sheets, 62
reports, Print Preview, 220
resizing
charts, 170–171
graphic objects, 155–156
table, 225
Restore button, 3
revisions
accept or reject, 241
removing, 242
Ribbon, 2
commands, 5
menus, 6
RIGHT function, 102
right-clicks, 4
Rotate menu commands, rotating graphic objects, 157
rotating graphic objects, 157–158
ROUND function, 84
Row Height dialog, 137
rows
charts, switching data, 174
deleting, 41
formatting cells, 105
headings, 2–3
height formatting, 135
changing with mouse, 136
hiding, 137
menu command changes, 137
inserting, 40
multiple selection, 27
selecting, 26
special table formatting, 227
S
Save button, 72
Save Chart Template dialog, 173
Save command, 9
saving workbooks, 72–73
Scale to Fit group, 204
scaling, printing options, 204
scientific, number formatting, 106
ScreenTips
buttons, 8
shortcut keys, 9
Scribble button, 145
Scribble tool, 146
scroll boxes, 13
searches, help feature, 16
Select Data Source dialog, 174, 175
Select Table dialog, 261
selecting
cells
columns, 26
deselecting, 28
entire worksheet, 27
going to, 26
multiple columns or rows, 27
multiple ranges, 28
multiple sheets, 60
range of cells with mouse, 25
rows, 26
charts, 170
graphic objects, 151
named cells, 271
Send to Back button, 161
Series command, creating series, 48
Series dialog, 48
SERIES formula, 169
series, cells, 48
Set Page Title dialog, 289
Fill Color menu, 123
Format Cells dialog, 124
shadows, chart formatting, 197
Shape Effects menu, 162
Shape Fill menu, 162
Shape Outline menu, 162
Shape Styles group, 162
shapes, 141
applying styles, 162
drawing, 147
Shapes menu button, 145
Share Workbook dialog, 250–251
Sheet Background dialog, 214
Sheet Options group, 211
sheet tabs, 2–3
sheets, 59
copying, 65
deleting, 62
hiding, 64
inserting chart sheet, 61
inserting worksheet, 61
moving, 65
printing options, 211–213
renaming, 62
selecting multiple, 60
switching between, 60
tab color change, 63
unhide, 64
shortcuts
font formatting, 119
keys, 9
menus, 6–7
Show All Comments button, 237
Show Table of Contents button, 15
SIN function, 87
Size and Properties dialog
resizing graphic objects, 156
rotating graphic objects, 157–158
Size group options, resizing graphic objects, 155
SLN function, 91
Smart Tags, error checking cells, 35
SmartArt Graphic dialog, 148
Sort & Filter group, 229
Sort commands, 231
Sort dialog, 232
sorting tables, 231–232
special formatting, numbers, 106
spell checking, 305
splitting windows, 71
SQRT function, 86
stacking orders, graphic objects, 161
Start Mail Merge command, 261
statistical functions
AVERAGE, 88
COUNT, 89
COUNTA, 89
MAX, 89
MEDIAN, 88
MIN, 89
MODE, 89
STDEV, 90
STDEVP, 90
status bar, 2–3
STDEV function, 90
STDEVP function, 90
Stop Recording command, 284
styles
chart design options, 176
formatting cells, 125
applying, 129
basics, 126
submenus, 6
Switch Row/Column button, 174
SYD function, 91
T
Tab Color command, 63
Table of Contents, help feature, 15
Table Style Options group, 226
tables
AutoFilter, 229–230
basics, 223
creating, 224–225
entering data, 228
setting options, 226–227
sorting, 231–232
Word data source, 261
Tables group, 224
dialogs, 11
Ribbon, 5
sheet, 2–3
sheets, color change, 63
TAN function, 87
taskbars, running Excel program, 18
teamwork
comments, 236–238
Document Properties pane, 234–235
document protection, 243
allowing editing of ranges, 246–247
locking selected cells, 245
Protect Sheet dialog, 244
unprotect sheet, 244
unprotecting workbook, 248
workbook protection, 248–249
features, 233
save options
opening file, 253
setting, 252
sharing workbooks, 250–251
tracking
accept or reject revisions, 241
removing revisions, 242
revisions, 240
turning on or off, 239–240
viewing information, 240
techniques, advanced, 265
3-D references, 272
cell or range by clicking, 273
cell or range by typing, 274
named cell or range, 273
Paste Link command, 274
sum formula for same cell, 276
writing formulas, 275
custom views, 282–283
macros, 284–285
names feature, 266
applying to existing formulas, 270
creating names, 268
defining name, 267
deleting name, 268
entering name in formula, 269
modifying name, 268
selecting named cells, 271
opening workbooks with links, 277–278
templates
chart design options, 173
workbooks, 20
installed, 21
online, 22
text
alignment formatting, 111–112
arguments, 76
chart labels, 181
direction change, 117
functions, 102–103
number formatting, 106
text boxes, 141
dialogs, 11
graphic objects, 149
Text Effects menu, 163
Theme menu, 127
themes, formatting cells, 125
applying, 127
basics, 126
customizing, 128
tiled windows, 68
time
functions, 100–101
number formatting, 106
Title bar, 2
TODAY function, 101
toolbars
button use, 8
Quick Access, 2
Tools group, 225
Top align option, 111
totals, table, 227
tracking, collaboration
accept or reject revisions, 241
removing revisions, 242
revisions, 240
turning on or off, 239–240
viewing information, 240
trigonometric functions
ABS, 85
AutoSum button, 82–83
COS, 87
DEGREES, 87
EVEN, 85
INT, 85
ODD, 85
PI, 86
PRODUCT, 84
RADIANS, 87
RAND, 86
ROUND, 84
SIN, 87
SQRT, 86
SUM, 82
TAN, 87
Trust Center dialog, 278
types, chart design options, 173
typing, entering functions, 78
U
Undo button, 56
Unhide Sheet command, 64
unhiding
sheets, 64
windows, 69
Uniform Resource Locators (URLs), 292
following, 295
inserting, 293–294
modify or delete, 296
Unprotect Sheet dialog, 244
UPPER function, 102
URLs (Uniform Resource Locators), 292
following, 295
inserting, 293–294
modify or delete, 296
V
value axis options, 192
values, 29
entering, 30
worksheet inputs, 17
vertical axis title, chart labels, 179
vertical text alignment, 112
vertical windows, 68
View buttons, 2–3
VLOOKUP function, 98
W
Web browsers, viewing Web pages, 287
Web Options dialog, 315–316
Web pages, creating, 288
automatic workbook save, 291
save workbook, 289–290
Web publishing, 287
creating Web pages, 288
automatic workbook save, 291
save workbook, 289–290
hyperlinks, 292
following, 295
inserting, 293–294
modify or delete, 296
WEEKDAY function, 101
Windows Taskbar, starting Excel program, 18
windows, workbooks, 66
activating, 67
adjusting pane size, 71
arranging, 68
changing magnification, 70
closing, 69
creating new, 67
hiding, 69
opening existing files, 74
removing split, 71
saving, 72–73
splitting, 71
unhiding, 69
Word, 259
Excel table as data source, 261
including content in Excel, 260
word processor, 259
WordArt, 141
applying styles, 163
inserting, 150
WordArt Styles group, 163
Workbook Views group, 216, 218, 282
workbooks. See also document files
collaboration
protection, 248–249
sharing, 250–251
creating, 20
based on existing, 23
blanks, 21
installed template, 21
online templates, 22
display options, 312
opening with links, 277–278
sheets, 59
copying, 65
deleting, 62
hiding, 64
inserting chart sheet, 61
inserting worksheet, 61
moving, 65
renaming, 62
selecting multiple, 60
switching between, 60
tab color change, 63
unhide, 64
windows, 66
activating, 67
adjusting pane size, 71
arranging, 68
changing magnification, 70
closing, 69
creating new, 67
hiding, 69
opening existing files, 74
removing split, 71
saving, 72–73
splitting, 71
unhiding, 69
workplace, 1
buttons, 8
dialogs
components, 11–12
displaying, 10
Excel screen, 2–3
help feature
browsing, 15
displaying, 14
searching, 16
menus, 6–7
mouse, 4
Ribbon, 5
scroll bars, 13
shortcut keys, 9
worksheets
basics, 17
cells
activating, 24–25
Error Checking Smart Tags, 35
selecting, 25–28
chart links, 169
creating workbooks, 20
based on existing, 23
blanks, 21
installed template, 21
online templates, 22
display options, 313
editing, 37
AutoFill, 48
cell contents, 38–39
copy and pasting, 44–45
copying cells, 43
deleting cells, 40–42
Fill command copying, 47
fill handle copying, 46
formulas, 49
inserting cells, 40–42
moving cells, 52–53
Office Clipboard, 54–55
redo actions, 57
references, 50–51
series, 48
undoing actions, 56
exiting Excel, 19
formulas, 29
basics, 31–32
entering by clicking, 34
entering by typing, 33
inserting, 61
sheet types, 59
starting Excel program, 18
values, entering, 29–30
window, 2–3
wrapping text, 114
Y
YEAR function, 101
Z
Zoom dialog, 70