object layers, 882
object linking and embedding (OLE), 881
object models, 835
objectives (targets)
sensitivity of, 609–610
Solver add-in, 603–604
objects
assigning macros to, 394–395
compressing, 385
creating from scratch, 886–887
embedding or linking, 881, 886–888
examples of, 398–401
formatting, 384–386
hyperlinks in, 873–874
inserting, 366–368
inserting Excel data in Word, 897–899
jumping to, 133
layers, 882
linking workbooks to, 476
manipulating VBA object properties, 840
nonprinting, 390
Object Browser, 836–837
protecting and locking, 393–394
selecting without activating hyperlinks, 879
in VBA, 835–837
Watch Window, 245, 865
obsolete features, 16–18
OCT2BIN function, 975
OCT2DEC function, 975
OCT2HEX function, 975
ODC files (Office Data Connection), 745, 763, 764
ODD function, 501, 975
ODDFPRICE function, 976
ODDFYIELD function, 976
ODDLPRICE function, 976
odds of winning, 500
Office
Clipboard, 909
Excel Web Access, 820–821
Excel Worksheet Objects, 894–895
keyboard shortcuts, 945
macros and, 827
Office Assistant, 17
Office Diagnostics program, 80–81
Office Update Web site, 551
Office Data Connection (ODC) files, 745, 763, 764
Office Online
accessing, 47
active content, 47
clip art, 362–363, 364
dynamic links to, 109
offline Help. See Help
OFFSET function, 976
offset (index_num), 514
offset text, 372
OLAP (Online Analytical Processing), 711, 748, 759
older versions of Excel
Compatibility mode and tables, 670
finding commands and options in Excel 2007, 907–925
natural language formulas in, 456
recalculations and, 461
shared workbooks and, 792
using older PivotTable features, 721
OLE (object linking and embedding), 881. See also embedding; linking objects
OLE server applications, 886, 887
omitting arguments, 853–854
On Error statements, 867, 868
one-dimensional arrays, 468–469
one-variable data tables, 583–586
Online Analytical Processing (OLAP), 711, 748, 759
online contacts, 807
online Help. See Help
open-high-low-close charts, 649–651, 663
opening
Access tables, 749–750
chart templates, 631–632
copies of files, 65
dBase files, 754
dependent workbooks, 474–475
displaying Open dialog box, 63–65
document libraries on SharePoint sites, 807
documents, 63–65
exporting files, 68
files in browsers, 65
importing files, 68
IRM-protected documents, 806
Personal Macro Workbook, 845
Query, 764–766
read-only files, 65
related SharePoint documents, 814
repairing files, 65, 66–67
saved queries, 764
shared workbooks, 792
supporting workbooks (sources), 475
workbooks with custom functions, 854–857
workbooks with links, 476
XML files, 755–759
OperaSked.xlsx file, 733–734
Operations area, 188–189
operators
filtering with, 688–689
list of, 478
precedence, 427–428
Query, 762, 773–774
reference, 458
Solver add-in, 605
Option Explicit statements, 861–862
optional arguments in custom functions, 853–854
Options tab commands and options, 918, 920
OR conjunction
filters, 689
OR and AND example, 694
three ORs on a column, 693
two columns joined by OR, 690–693
OR function, 508–509, 976
ordinary annuities, 536
Organization Chart feature, 358, 914. See also SmartArt feature
organizing clip art and collections, 363–364
orientation
pages, 403
text, 320
transposing arrays, 520
outline controls
in Excel Web Access, 821
hiding, 724
in querying, 761
Outline PivotTable format, 722
outlines (shapes), 371, 631
outlining
- (minus sign), 256
+ (plus sign), 256
automatic styles, 255
collapsing or expanding levels, 256, 257
displaying details, 256
displaying specific levels, 256–257
extending outlines, 255
grouping or ungrouping columns and rows, 257–258
hiding details, 256
hiding outlines, 255
level bars, 256
nonstandard layout, 254–255
in reports, 596
selecting only visible cells, 257
in shared workbooks, 792
Outlook, 800–802, 808, 817
output tools, 6
overlapping chart labels, 647
overlay charts, 618
overlay titles on charts, 621–622
Overtype mode, 127