Excel 2007[c] The Missing Manual

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

data

        adding to charts

        editing

        embedded 2nd

        entering 2nd

        exchanging with other programs

        grouping 2nd 3rd 4th 5th 6th 7th 8th 9th

        hiding

        labels 2nd 3rd 4th 5th

        linked 2nd

        moving 2nd 3rd

        points 2nd

        scales

        series 2nd 3rd

        validation 2nd 3rd 4th 5th 6th 7th 8th

data bars (conditional formatting)

        editing

Data Connection wizard 2nd 3rd 4th 5th

data connections

data forms

Data tab

data tables

        calculation settings

        variable 2nd 3rd

data types 2nd 3rd 4th 5th 6th

        alignment of

        controlling

        how Excel determines 2nd 3rd 4th 5th 6th

        numeric

        ordinary text

data validation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

        auditing circles

        error alert

        formulas/ cell references 2nd

        input message

        lists

        settings

data visualizations

databases 2nd 3rd 4th 5th

        Access 2nd

        connections 2nd 3rd

        database functions

        end user vs. server side

        querying

        refreshing data 2nd 3rd

                automatically

        SQL Server 2nd

        vs. worksheets

DATE() function

DATEIF() function

dates and times 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th

        as scales (charts) 2nd 3rd

       calculations

                date 2nd 3rd 4th 5th 6th 7th

                time 2nd 3rd

        converting to serial numbers

        data type

        filtering

        format string codes 2nd 3rd

        inserting current

        internal representation

        pound symbol (#) error and

        regional

DATEVALUE() function

DAVERAGE() function

DAY() function

DAYS360() function

DB() function

DCOUNT() function

DCOUNTA() function

DDB() function

debugging macros 2nd 3rd

decimal places

        displayed

        limit on

        Number format and

decision variables (Solver)

declining balance method (depreciation)

Defer Layout Update setting (pivot tables)

deleting

        comments

        worksheets 2nd

depreciation 2nd 3rd 4th 5th

        straight line

descriptions

Design tab (Chart Tools)

detail columns

Developer tab

        Visual Basic editor and

DGET() function

diamonds

dictionary 2nd

digital certificates 2nd

digital signatures

Dim (dimension) keyword

direct precedents

disaster recovery 2nd 3rd

discount rates

display text

displayed values

        find feature and

        vs. stored values

distributed (alignment)

distributing documents 2nd

division

        operator (/)

DMAX() function

DMIN() function

Document Inspector

document prologs

Document Properties pane 2nd

Document window (Visual Basic editor)

document-oriented applications

documents

        compound

dollar sign ($)

        absolute cell references and

DOLLAR() function

donut charts

        percentage labels

double declining balance depreciation method

double lookups

downloading templates 2nd 3rd 4th 5th 6th 7th

DPRODUCT() function

draft-quality printing

drawing

        borders

        shapes 2nd 3rd 4th 5th 6th

DSTDEV() function

DSUM() function

duplicate rows 2nd 3rd

        removing automatically

duplicating styles

DVAR() function

DVARP() function

dynamic calculations

dynamic invoicers

dynamic links

dynamic spreadsheets