Index
A
+Shift+down arrow
+Shift+left arrow
+Shift+right arrow
+Shift+up arrow
+T
Absolute addressing
Activating and installing
Add-ins, generally
Analysis ToolPak
AutoFilter
Data Form
Solver
ActiveX controls
Add-Ins
activating/installing
Analysis ToolPak. See Analysis ToolPak
menu
Solver. See Solver
Add Mode
Addressing
absolute
relative
Advanced Options menu
ALT+
ALT+=
ALT+D+O
ALT+F1
Amortization tables
Analysis ToolPak
about
activation and installation
descriptive statistics
Excel 2003
Histogram feature
Mac Excel 2011
multi-regression
XIRR (IRR for uneven intervals)
XNPV (NPV for uneven intervals)
AnalystSoft
Animation, App. A
Apply Names
Arguments
Function Arguments
IF function
Payment Function
Rate
Array functions. See also FREQUENCY (statistical function)
Ascending order, sorting in
Attributes
charts
Scroll Bar
Auto Outline
AutoFill
Custom Lists
dates
Excel 2003
linear regressions
Mac ...
Get Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
