D

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
        editing
        entering
       exchanging with other programs [See exchanging data with other programs]
       grouping [See grouping data]
       moving around [See spreadsheet modification]
       outlining [See outlining data]
        time-saving features
                AutoComplete
                AutoCorrect
                AutoFill
                AutoFit
                Redo
                Undo
Data Analysis command
Data Form dialog box
data forms
        advanced seraching
                logical operators
        editing with
        searching with
        versus worksheets
data labels
        adding individual
        bubble size labels
        category name
        percentage labels
        series name
        value labels
data lists 2nd
        charting
        compared to pivot tables
        creating
       data forms [See data forms]
        editing
                adding new record
                adding or removing columns
                deleting records
                records
        Excel 2002 and
        filtering 2nd
                custom filters
                disappearing cells
                multiple sort keys
                restricting rows
        overview
        performing calculations with
                database functions
                dynamic calculations
                SUBTOTAL( ) function
                Total Row command
        sorting
                mulitple criteria
                simple sort order
        versus grouping data
Data menu
        Consolidate command
        Filter command
        Form command
        Group and Outline submenu
        Import External data submenu
        List submenu
        PivotTable and PivotChart Report command
        Refresh Data command
        Sort command
        Subtotals command
        Table command
        Text to Columns command
        Validation command
        XML submenu
data points
        formatting
data series
        adding labels
        changing order of
        formatting
data series (chart)
data source definition
data source, querying
data table
data types
        controlling
        dates and times
                how Excel determines if data is
                using dates trouble-free
        numbers
                how Excel determines if data is
        ordinary text
                how Excel determines if data is
        seeing how Excel is interpreting
        true or false
data validation
        conditional validation rules
        Custom data type and
        with formulas and cell references
        with lists
Data Validation dialog box 2nd
        Error Alert tab
        Input Message tab
        List option
        Setting tab
database functions
databases
        defining data source
        difference between worksheets and
        querying data source
        retrieving data from
        types of
Date format
date format strings
date formats, types of
DATE( ) function
DATEDIF( ) function
dates
        calculating difference between
        converting into serial numbers
        finding number of days between two
        formatting codes
        having time and date in same cell
        how Excel determines if data is
        intentional bug
        manipulating
        math with
        regional
        subtraction
        using dates trouble-free
DATEVALUE( ) function
DAVERAGE( ) function
DAY( ) function
DAYS360( ) function
DB( ) function
DCOUNT( ) function
DCOUNTA( ) function
DDB( ) function
decimals, fixed decimal places
declining balance depreciation
Define Name dialog box
        named ranges
        naming formulas and constants
DEGREES( ) function
Delete command
Delete Row command
Delete Sheet command
delimited text
depreciation
        declining balance
        double declining balance
        straight-line
        sum-of- years -digits
Detect and Repair command
DGET( ) function
Diagram command
digit placeholders
disaster recovery
DISC( ) function
discount rate
discussion server
Distributed (cell appearance formatting)
Distributed (Indent) (cell appearance formatting)
division
DMAX( ) function
DMIN( ) function
Do Not Distribute command
Document Updates task 2nd
DOLLAR( ) function
donut charts
double declining balance depreciation
double lookups
DPRODUCT( ) function
drag-and-drop
drawing shapes 2nd
        adding text to shapes
        AutoShapes button
        basic shape categories
        basic shapes
        block arrows
        callouts
        connectors
        Fill Color button
        flowcharts
        in charts
        layers
        Line Color button
        lines
        more autoshapes
        selecting shapes
        stars and banners
Drawing toolbar
Drop Page Fields Here region
DSTDEV( ) function
DSUM( ) function
DURATION( ) function
DVAR( ) function
DVARP( ) function
dynamic calculations
dynamic invoicing example
dynamic spreadsheets