A

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]

ABS() function (absolute value)
absolute cell references 2nd 3rd
absolute values
absolute vs. relative macro recording
accelerated depreciation
accepting changes 2nd 3rd
Access databases 2nd
accounting
        Accounting format
        financial functions
ACCRINT() function
ACCRINTM() function
ACOS() function
ACOSH() function
ActiveX controls
Add to Dictionary command (spell checker)
add-ins
        file format converter
        Save As PDF
        Solver
adding worksheets
addition
        adding multiple values (pivot tables)
        AutoSum
        operator (+)
ADDRESS() function
addresses
Adobe Reader (PDF files)
Align with Page Margins option (headers/footers)
aligning shapes
alignment (cell formatting) 2nd 3rd 4th
        determining data types based on
All Except Borders command (paste special)
AMORDEGRC() function
amortization tables
AND() function
angle brackets (<>)
appearance (cell)
area charts
AREAS() function
arguments
        optional
        parentheses and
arithmetic operators
        order of operations 2nd
arithmetic rounding
arranging shapes
arrays
        array formulas
arrow keys
        edit mode and
        navigating with
        scroll mode and
arrows
        Trace Precedents feature
ASIN() function
aspect ratios
assets
ATAN() function
ATANH() function
auditing
        circles (data validation)
        tools
authentication
Authenticode signing
author (document properties)
authorities
Auto Outline
AutoComplete 2nd
        Formula AutoComplete
AutoCorrect 2nd
AutoFill 2nd 3rd 4th
AutoFit
automatic formatting
automatic naming (ranges)
automating tasks (macros) 2nd
AutoRecover 2nd 3rd
AutoSelect
        keyboard activation
AutoSum
AVEDEV() function
Average indicator (status bar) 2nd
average value macro
AVERAGE() function 2nd
AVERAGEIF() function 2nd
AVERAGEIFS() function
averages
axes
        formatting 2nd
        Z