O


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

image from book 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



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net